If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships
Hi
I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. When I look at the relationship window, and scroll left/right/up/down, there are no tables in the window. I have selected Show All and one table is displayed. However if I select Database documenter relationships, it is showing that there is a relationship Can someone tell me what's happening? Tks |
#2
|
|||
|
|||
Relationships
Are you using lookup tables at table level?
Any forms or reports with subforms or subreports? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Alex Hammerstein" wrote: Hi I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. When I look at the relationship window, and scroll left/right/up/down, there are no tables in the window. I have selected Show All and one table is displayed. However if I select Database documenter relationships, it is showing that there is a relationship Can someone tell me what's happening? Tks . |
#3
|
|||
|
|||
Relationships
Hi No I have checked all fields and no lookup tables. All of the forms have been deleted - there are no other objects A On 17/02/2010 16:46, in article , "Jerry Whittle" wrote: Are you using lookup tables at table level? Any forms or reports with subforms or subreports? |
#4
|
|||
|
|||
Relationships
Have you tried a Compact and Repair?
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Alex Hammerstein" wrote: Hi No I have checked all fields and no lookup tables. All of the forms have been deleted - there are no other objects A On 17/02/2010 16:46, in article , "Jerry Whittle" wrote: Are you using lookup tables at table level? Any forms or reports with subforms or subreports? . |
#5
|
|||
|
|||
Relationships
Yes, twice
I am assuming that somehow the tables are corrupt? A On 17/02/2010 19:36, in article , "Jerry Whittle" wrote: Have you tried a Compact and Repair? |
#6
|
|||
|
|||
Relationships
I have just copied the table without data, and the new table works Ok, so I
guess there is data corruption A On 17/02/2010 19:36, in article , "Jerry Whittle" wrote: Have you tried a Compact and Repair? |
#7
|
|||
|
|||
Relationships
Do you have any queries that join that table and field combination with
another? -- Build a little, test a little. "Alex Hammerstein" wrote: Hi No I have checked all fields and no lookup tables. All of the forms have been deleted - there are no other objects A On 17/02/2010 16:46, in article , "Jerry Whittle" wrote: Are you using lookup tables at table level? Any forms or reports with subforms or subreports? . |
#8
|
|||
|
|||
Relationships
Hi, no
There are just three tables in the database A On 17/02/2010 20:50, in article , "KARL DEWEY" wrote: Do you have any queries that join that table and field combination with another? |
#9
|
|||
|
|||
Relationships
On Wed, 17 Feb 2010 15:59:31 +0000, Alex Hammerstein wrote:
Hi I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. When I look at the relationship window, and scroll left/right/up/down, there are no tables in the window. I have selected Show All and one table is displayed. However if I select Database documenter relationships, it is showing that there is a relationship Can someone tell me what's happening? Tks It sounds like you've resolved it, but just in case you or someone else runs into this, here's a little function that might help: Sub ShowAllRelations() Dim db As DAO.Database Dim rel As Relation Dim fld As Field Set db = CurrentDb For Each rel In db.Relations Debug.Print "Relation "; rel.Name, rel.Table, rel.ForeignTable For Each fld In rel.Fields Debug.Print fld.Name; " linked to "; fld.ForeignName Next fld Next rel End Sub -- John W. Vinson [MVP] |
#10
|
|||
|
|||
Relationships
|
Thread Tools | |
Display Modes | |
|
|