can't change a field data type (1 Viewer)

L

Lee Weaver

Registered User.

Local time

Today, 04:55

Joined

Jun 6, 2008

Messages

20

• Aug 13, 2008

• #1

I need to change a field data type but when i try it tells me that i need to delete a relationship in the relationships window. but when i open the relationships window it doesn't show any.

 

D

dkinley

Access Hack by Choice

Local time

Today, 06:55

Joined

Jul 29, 2008

Messages

2,016

• Aug 13, 2008

• #2

My only guess is what I've ran into before ... right-click on the relationships window and left-click 'Show All'. It sometimes doesn't show them all .. if nothing appears - beats me.

-dK

 

L

Lee Weaver

Registered User.

Local time

Today, 04:55

Joined

Jun 6, 2008

Messages

20

• Aug 13, 2008

• #3

OK now i see it. I also see why the relationship is interfering. but I can't seem to delete the relationship. I click the offending relationship and the 'X' delete button. and the relationship goes away. i click save. but if i "show all" again it reappears. How do I get it to go away and stay gone so i can change this data type?

 

D

dkinley

Access Hack by Choice

Local time

Today, 06:55

Joined

Jul 29, 2008

Messages

2,016

• Aug 13, 2008

• #4

Ughr?!

I have no idea unless you have something running in the background that keeps you from deleting it.

Anyone else?

-dK

 

L

Lee Weaver

Registered User.

Local time

Today, 04:55

Joined

Jun 6, 2008

Messages

20

• Aug 13, 2008

• #5

I figured it out. I was clicking the box not the line for the acutal relationship. got it deleted.