Print Page | Close Window

Access not showing relationships

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12884
Printed Date: 30 March 2026 at 5:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Access not showing relationships
Posted By: Mattblack
Subject: Access not showing relationships
Date Posted: 07 December 2004 at 7:21pm
Folks,
 
Access wont let me view any relationships in any databases ive got.  Just get an error box saying "Unknown" and thats all. Cant create queries either - get the same error (Only after opening the 2nd table which is relational)
 
Tearing my hair out, please help.
 
Matt



Replies:
Posted By: dpyers
Date Posted: 07 December 2004 at 11:50pm
IIRC, you have to have the table views closed before viewing relationships.
Also, if you're linking an Autonumber field in one table with a numeric field in another table, both fields must be the same size.


-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: Mattblack
Date Posted: 08 December 2004 at 9:09am
nope, all the ones that i know work (On other PCs) dont work on my main PC all of a sudden. Even the blank default WWF one.
 
Even DBs without relationships wont work, cant open the relationships window at all.
Confused


Posted By: dj air
Date Posted: 08 December 2004 at 9:39am
try re installing Access and see if that fixes it.

i had a smilar problem when m,aking a user based database, it kept asking for username/password when i had disabled it.

ended up re installing it.


Posted By: Gullanian
Date Posted: 08 December 2004 at 1:28pm
Send it to someone else with access see if they have the same problem with it or if it's your software.


Posted By: dpyers
Date Posted: 08 December 2004 at 2:02pm
The relationships view has always been a pain. IIRC, there's a coupl of different option boxes for types of relationship views. You might try toggling them.
 
The only other thing might be if there's conflicting version of access - e.g. your program is Access 2000 and the db is Access 2003 - ore vice versa. You're supposed to be able to convert older versions of a db to a newer version supported by the Access program when you open the db but the conversion is not always total.


-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: Mattblack
Date Posted: 08 December 2004 at 6:23pm
sorted it, the following dll files had unregisterred themselves on my PC....
Msjtes40.dll
scrrun.dll
 
Chuffed now.  Photodraw has cocked up though. DOH!


Posted By: MadDog
Date Posted: 08 December 2004 at 6:47pm
cocked up LOL

-------------
http://www.iportalx.net" rel="nofollow">



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net