Relationship lines no longer showing

[PNGBill]

Sometime ago, the lines in my relationships disappeared.

I have been too lazy to do anything about this but I guess it may be serious.

What could cause this to happen and how can I get them back apart from going through the squiline tables and redrawing them - and getting some wrong

I tried to delete a table today and it wouldn't allow me until I had deleted the relationship first yet I can not see the table or the relationship line.

Appreciate any guidance.

 

[HiTechCoach]

Sometime ago, the lines in my relationships disappeared.

I have been too lazy to do anything about this but I guess it may be serious.

What could cause this to happen and how can I get them back apart from going through the squiline tables and redrawing them - and getting some wrong

I tried to delete a table today and it wouldn't allow me until I had deleted the relationship first yet I can not see the table or the relationship line.

Appreciate any guidance.

In the back end is split (hopefully it is), open the relationships window. Select the the Option "Show All"

 

[PNGBill]

Thanks, Show all allowed me to see a few lines and clear the old tables I wanted to do but virtually all of the tables still do not have lines showing.

What is meant by back end split?

Our database is about 380mb and shared by 3 to 5 users. Access 2000.

 

[boblarson]

See here for splitting the database.

This is a MUST for shared users.

 

[PNGBill]

We need a Smilie for a "Can of Worms"

Looks like I have another job for the weekend splitting our trusty database.

All these years and we thought we were plodding along ok.

 

[HiTechCoach]

Thanks, Show all allowed me to see a few lines and clear the old tables I wanted to do but virtually all of the tables still do not have lines showing.

What is meant by back end split?

Our database is about 380mb and shared by 3 to 5 users. Access 2000.

Bob gave you a great link about why you need to split your database.

What may have happened to your relationships? Since your database is not split, any user could have deleted the relationships. When you split your database into a front end and back end, all the tables and relationships are in the back end. The tables and relationships can not be modified from the front end, at least not easily. It requires VBA code.

 

[PNGBill]

Database now Split.

Had fire extinguishers ready but not to much smoke and sparks evident.

Database is now some 250 queries lighter then it was and virtually no macros or temp tables now.

One issue with splitting...
Advice is to not use mapped drives.

I tried my best to follow instructions and link via the full path to the shared hdd but the FE still wants to link to the Mapped drive name.

Using "Y" and have done so for many years without any changes.

Any tips on forcing the mapping to not be used by the FE?

 

[boblarson]

Database now Split.

Had fire extinguishers ready but not to much smoke and sparks evident.

Database is now some 250 queries lighter then it was and virtually no macros or temp tables now.

One issue with splitting...
Advice is to not use mapped drives.

I tried my best to follow instructions and link via the full path to the shared hdd but the FE still wants to link to the Mapped drive name.

Using "Y" and have done so for many years without any changes.

Any tips on forcing the mapping to not be used by the FE?

Don't know if this will help, but perhaps.

 

[PNGBill]

Thanks Bob, Solved the problem. I should have noticed the little box in the corner

Some reports of improved speed since the split.