We have the problem that sometimes the relation between two tables disappear.
It's in Access 2010 using a accde.
And the application is multi user with 10-20 users.
Does anyone know the reason why a relation can disappear?
We have the problem that sometimes the relation between two tables disappear.
It's in Access 2010 using a accde.
And the application is multi user with 10-20 users.
Does anyone know the reason why a relation can disappear?
if you build the relationships in a non split db with forms and tables, then split the db, the frontend should inherit the relations.
if you build the relationships in a split db, then deliver the frontend to each user, the relations should remain in the copies.
Ive never seen them vanish, unless you didnt save the relation upon changing it.
The database is split and the frontend is delvired to each user.
We think the relation sometimes disappear when to users at the same time change the same record.
?
Do you mean each user has their own copy of the ACCDE on their own computer....or a shortcut to the same ACCDE which is shared?
Each user has their own copy of the ACCDE
On a form there is no record locking set.
In the general settings of access 'Use Row Level Locking' is set True and 'Default Record Locking' is set False