Question 3045 Error on multiple user App.

[marlan]

3045 Error on multiple user App - no .ldb file

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, and is used by up to 3 users: 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).​

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 with the list of BE_2s. The user can select one, or use the default BE_2. BE_2 is actually accessed after opening the next form.​

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" ​

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.
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.
Any ideas? ​

Thanks in advance!
Mike​

 

[boblarson]

Check out Access MVP Tony Toews' page here and look at item #24.

 

[marlan]

Hi Bob, and thanks for your reply!
I haven't tried recreating BE_2, but I have tried using a 2 week old backup copy I have, and the problem has still occurred (it didn't occur 2 weeks earlier), so I don't think the file is corrupted.
I think a point is the missing .ldb file: one is created for BE_1, not for BE_2, and therefore BE_1 can be accessed simultaneously, while BE_2 can not. Could there be something preventing BE_2.ldb from being created? All files are in the same directory. Could it be some kind of network definition? OS? Server OS? I am quite week in those issues, but I know they are slowly migrating the network from XP to Win-7.

Thanks again,
Mike

 

[marlan]

Re: 3045 Error on multiple user App. NO LDB FILE

Hi Bob and all of you!
I'm switching back to here from the new thread I've opened.

After checking out things in the client location and surfing the web, here is where I am holding:

1) Error 3045 accurse when simultaneously accessing BE_2, and not BE_1, because BE_2.ldb is not created, and BE_1.ldb is. (See http://support.microsoft.com/kb/299373).
2) I've tried creating a new BE_2, and importing all Data into it – no luck there.
3) The ldb file is not created in the server directory, even if I double-click the file icon.

4) WHEN I COPY BE_2 TO a WORK-STATION DIRECTORY BE_2.ldb IS CREATED whether I access it via FE or by a double click.

5) System person says all users have all rights on App directory, any-way that shouldn't be the problem, since BE_1.ldb is created and deleted by all users in the same directory.
6) Most work-stations run on Win-XP, one runs on Win-7. I don't think this point makes a deferens, since, again, BE_1.ldb is created.

I really need other people's experience here!

Thanks,
Mike

 

[marlan]

Hi everybody!

OK, I've solved the issue together with network administrator:

It seems network administrator has let the entire department full rights on the application directory (that was taken care of). One of the department supervisors has probably opened one of the files (FE or BE_2) from his lap-top, and disconnected it from the docking station without closing the mdb file. As a result, BE_2.ldb that was created on the network directory, and WAS INVISIBLE TO THE REST OF THE USERS was not deleted, and could not be deleted, or written over by anyone else (but the NW Admin).
It seemed at first to be a file corruption, but after recreating it in many various ways, and when I saw the same file can create the ldb when I change its location or name, I understood it was a network problem, and had the network administrator assist me in locating the problem.

Hope I am the last one to tumble on this one…

Mike