Problem with relationship screen

[fictionwelive]

Ive been creating my relationship for my new Inventory database, and everything seemed to be going well.

I needed to change a field in my table, but it said I couldnt change it until I deleted it's relationship. I went to do that, but none of the relationships where there. I created them all again and saved. Opened the relationship screen, and still none of them were there. I cant chnage a few things now, and I'm really stuck. Anyone run into anything like this before?

 

[traingamer]

Try the scroll bars on the relationships screen.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[fictionwelive]

I did that, couldnt find any. Is there any way to just delete all relationships?

 

[dhookom]

What do you mean by "but none of the relationships where there"? Do you see anything? Did you click the button to display all relationships?

If you don't see any tables, try press the tab key a few times.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[bclegg9]

I have been developing a particular database for the last 10 years. About a month ago I experienced a similar problem to yours. All the relationship lines disappeared although the program still worked, so the relationships were still there and working or the program would certainly not have worked. I have many backups so I knew where the relationship lines should be. I recreated the relationships (although they were present) and everything has been fine since. If I delete the relationship now it does delete the line and the relationship which is what you want.
I believe it is a bug in Access. I am using Access 2000 file format in Access 2003

 

[willir]

Some PC therapy may be in order, perhaps a resource issue of some type...
- Make sure your database is backed up
- Delete your TEMP and TEMP Internet files. (If your temp files are too numerous, it can cause various system problems)
- Scan for viruses and spyware / malware -- be sure to use up-to-date definition files.
- Open the database with no other applications open. (Your problem could be insufficient video RAM to display the relationship lines)
- Compact and Repair your database
- Open the Relationship GUI window -- do you see your tables and relationships?
- Use the menu, "Relationships" -> "Show all"

Richard