Ray Stantz
Registered User.
- Local time
- Today, 06:06
- Joined
- Nov 16, 2006
- Messages
- 63
Good morning,
I have a multi user database setup with a FE and BE. The BE (with tables)record locking is set to no locks and i have installed a copy of the FE (with queries, forms, reports, etc.) as a mde file on each of the users C drive with a shortcut to their personal FE on their desktop. However, i am still getting record lock errors when multiple users are in the database and moving from record to record.
I read somewhere on this board where it was suggested to base the forms off of queries instead of the tables directly. My question is if i have the tables relationships setup currently with One To Many cascading rules, will i have to set the new queries for the forms up with these same realtionships or will the queries automatically inherent the tables original relationships? Also, if i base the forms off of queries, will they still remain on the FE or should i move them to the BE? Hope that made sense.
I have a multi user database setup with a FE and BE. The BE (with tables)record locking is set to no locks and i have installed a copy of the FE (with queries, forms, reports, etc.) as a mde file on each of the users C drive with a shortcut to their personal FE on their desktop. However, i am still getting record lock errors when multiple users are in the database and moving from record to record.
I read somewhere on this board where it was suggested to base the forms off of queries instead of the tables directly. My question is if i have the tables relationships setup currently with One To Many cascading rules, will i have to set the new queries for the forms up with these same realtionships or will the queries automatically inherent the tables original relationships? Also, if i base the forms off of queries, will they still remain on the FE or should i move them to the BE? Hope that made sense.