Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Relationships disappeared after user-level security and splitting?
This is how I solved the problem. 1. I made a copy of the database. Named it DatabaseNameBE. 2. Opened DatabaseNameBE. Threw away all my queries, forms, reports, macros and modules (ough!!). The database was only left with its tables (AND relationships between them!!!). 3. Compacted...- drfreako
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Relationships disappeared after user-level security and splitting?
Had the same problem. All the foreign key relationships between tables gone after splitting database into front and backend. Would let me delete records from tables being referenced by other tables without any problem ??? Found no warning about this in the online help of MS. Luckily I had done a...- drfreako
- Post #3
- Forum: Microsoft: Access Tables and Relationships
