Linked Tables to Back End, "file already in use" Error

[Shippwreck]

Hi,

I've got an odd little issue... Where I work we have a number of Access DB's all split in a Front End/Back End config via linked tables (Access used for both, FE is in MDE format). This has been working great and all DB's work fine... except...

We had a new user start the other day and for some reason whenever he tries to open the front ends he gets the error that says:

"Could not use 'BE_DB_Path.mdb'; file already in use."

It doesn't matter which of the many FE/BE DB's we have that he opens, they all give the same error as most are always in use by at least one person and it doesn't even matter what machine he uses... he always gets the same error. And its only his user, if others logon on the same machines with there user they work fine!

So all that leads me to the conclusion that it is a user specific setting somewhere but for the life of me I can't work out where...

Any ideas?

Thanks guys

http://www.simpleits.co.uk

http://www.tazforum.thetazzone.com

"Google is god...of the internet" - Me

 

[PHV]

Be sure that this new user has the same privileges as other on the shared directory.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Shippwreck]

Yeah, that was the first thing that I did and he does have all the correct permissions. It seems to be the way access is treating the linked file.

What I mean is that it is exactly the same message that you would get if you were trying to directly open a DB file that someone else had already opened except he isn't in this case, he's opening a front end that is linked to the back end that is giving the error... very frustrating!

http://www.simpleits.co.uk

http://www.tazforum.thetazzone.com

"Google is god...of the internet" - Me