| Author |
 Topic Search  Topic Options
|
Mattblack 
Groupie
Joined: 21 January 2003
Location: United Kingdom
Status: Offline
Points: 139
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access not showing relationships
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
|
 |
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
Mattblack
Groupie
Joined: 21 January 2003
Location: United Kingdom
Status: Offline
Points: 139
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
Mattblack
Groupie
Joined: 21 January 2003
Location: United Kingdom
Status: Offline
Points: 139
|
Post Options
Thanks(0)
Quote Reply
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!
|
|
MadDog
Mod Builder Group
Joined: 01 January 2002
Status: Offline
Points: 3008
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2004 at 6:47pm |
cocked up 
|
|
|
|
