A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Relationships



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2010, 04:59 PM posted to microsoft.public.access.tablesdbdesign
Alex Hammerstein
external usenet poster
 
Posts: 70
Default 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  
Old February 17th, 2010, 05:46 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old February 17th, 2010, 07:56 PM posted to microsoft.public.access.tablesdbdesign
Alex Hammerstein
external usenet poster
 
Posts: 70
Default 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  
Old February 17th, 2010, 08:36 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old February 17th, 2010, 09:16 PM posted to microsoft.public.access.tablesdbdesign
Alex Hammerstein
external usenet poster
 
Posts: 70
Default 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  
Old February 17th, 2010, 09:20 PM posted to microsoft.public.access.tablesdbdesign
Alex Hammerstein
external usenet poster
 
Posts: 70
Default 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  
Old February 17th, 2010, 09:50 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old February 17th, 2010, 10:20 PM posted to microsoft.public.access.tablesdbdesign
Alex Hammerstein
external usenet poster
 
Posts: 70
Default 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  
Old February 17th, 2010, 10:42 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.