I have a database with multiple tables, forms, etc. that I have successfully split. The front and back ends reside on a common server with the Front end on the users desktops.
The problem is with some of the users times when they open thier database no one else can "Err; the file U:\Data\BackendDatabase.mdb is currently in use". Once the user closes his/her database then some one else can open it.
This error does not happen with all the users (have noted 3 users out of 30) It seems that these users are opening thier database in exclusive mode.(Options, Advanced tab, Default Open Mode set to exclusive). Or is there another reasion this might be happining. (all server permissions are identical for each user)
How do I make sure it is opened in a shared mode only using VB? is there a SetOption "Open database shared mode" = true?
Dalain
The problem is with some of the users times when they open thier database no one else can "Err; the file U:\Data\BackendDatabase.mdb is currently in use". Once the user closes his/her database then some one else can open it.
This error does not happen with all the users (have noted 3 users out of 30) It seems that these users are opening thier database in exclusive mode.(Options, Advanced tab, Default Open Mode set to exclusive). Or is there another reasion this might be happining. (all server permissions are identical for each user)
How do I make sure it is opened in a shared mode only using VB? is there a SetOption "Open database shared mode" = true?
Dalain
