file in use, could not use

Question posted by: knawtn via AccessMonster.com (Guest) on August 24th, 2007 11:46 AM

Hi. I have two databases that are both linked to the same backend table. I
can't use them both at the same time, yet other users can have both
functioning simultaneously on their machines. Opening them is not the problem.
..but the error message appears when I run any queries linked to the table.
It works in one database, but not the other. All users are running XP sp2
with Access 2003.

The error message is the same regardless if anyone is using the backend or
not. I believe it is machine specific...MY machine.

I haven't a clue. Any ideas?

--
Message posted via http://www.accessmonster.com

Quote | Subscribe

2 Answers Posted

Stuart McCall August 24th, 2007 12:25 PM

Guest - n/a Posts

#2: Re: file in use, could not use

Check your shortcuts that start your front-end. Make sure noone is using
/excl (open for exclusive use)

HTH

"knawtn via AccessMonster.com" <u13973@uwewrote in message
news:772b59e050975@uwe...

Quote:

Originally Posted by

Hi. I have two databases that are both linked to the same backend table. I
can't use them both at the same time, yet other users can have both
functioning simultaneously on their machines. Opening them is not the
problem.
.but the error message appears when I run any queries linked to the table.
It works in one database, but not the other. All users are running XP sp2
with Access 2003.
>
The error message is the same regardless if anyone is using the backend or
not. I believe it is machine specific...MY machine.
>
I haven't a clue. Any ideas?
>
--
Message posted via http://www.accessmonster.com
>

knawtn via AccessMonster.com August 24th, 2007 12:35 PM

Guest - n/a Posts

#3: Re: file in use, could not use

That has been confirmed. Shortcut or direct access results in the same. The
only thing I have learned is that the other machines were part of an XP clone.
My machine was not. I don't know if that has anything to do with it.

--
Message posted via http://www.accessmonster.com

Not the answer you were looking for? Post your question . . .
197,040 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 197,040 network members.

Post your question now . . .
It's fast and it's free

Top Community Contributors

file in use, could not use

What is Bytes?

Popular Articles

Top Community Contributors