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.
 |
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 
------------- http://www.iportalx.net" rel="nofollow"> 
|