Hi to all!
I am having some difficulties with an Access 2003 (mdb) App. It has bin running in this architecture for the past few years: FE on each machine, BE(s) on server. (If to be accurate: each work-station has an app that copies the FE from a network location). Used by up to 3 users.
The FE is linked to 2 BE files: one has a list of Data files (BE_1.mdb), and the other is a selected Data file from the list (BE_2s.mdb).
On start-up the user gets a form containing a combo-box linked to BE_1. BE_2 is not accessed until after opening the next form.
My proble: all users can open this start-up form, but only the first one can open the next form. the rest of them get 3045 Error: "Could not use <name>; file already in use"
In other words: BE_1 can be accessed simultaneously, BE_2 can-not.
A few more details:
1. All files are opened in "shared" mode (Tools->Options-Advanced tab).
2. ldb file is created only for BE_1, not for BE_2 (I have a feeling this is the issue).
3. These problems began after I preformed some Data manipulations, but they now occur on older backups I have.
4. Security is based on the LAN - no one but my users can access my application's directory on the server.
Any ideas?
Thanks in advance!
Mike