LDB file created at front end and back-end 1

[kiberu]

I need help to prevent lock file from being created in the back end folder when users open forms from the front end copy on their desktops
This back end lock slows down all users.
Thanks.

 

[Remou]

This cannot be changed. When tables are accessed in the back-end, a lock file will be created. You could rewrite to limit the time tables are accessed.

 

[kiberu]

Thank you but the purpose of splitting is to improve multi user experience,how best can one prevent the first user from locking out others? Can Disconnected recordsets help and would this close the lock when the connection object (ADO) is closed? Please point me to a practical approach for my users are frustruated.

 

[Remou]

Have you checked that the users have full permissions on the directory in which the back-end resides? Does the first user, no matter who the user is, always lock the back-end? Is the default open mode shared?

 

[kiberu]

Actually all users have full permissions on the back end folder as advised in similar threads on this forum.
The default open mode is shared. I need ideas on how to allow multiple users without reduction in speeds on the front ends.

 

[Remou]

Have you see this article? Does it apply to you?

http://msdn2.microsoft.com/en-us/li...x#odc_acmultibest_changesmaybediscardedinmdbs

 

[kiberu]

Thanks,
Just read the article and realise that short of migrating the BE to SQL Server Express, i'll be moving in circles.
I have SQLEXPRESS (2005) instance running and wish to migrate development to that engine.
Could you post a routine to create and save records using access forms with subforms via access data project(ADP) to guide me?