Upgrading DB from access 2003 to access 2007 problem

[Guest]

I have several DB I would like to upgrade to the access 2007 version.
Everytime I try I get the following error. "You attempted to open a database
that is already opened exclusively by user 'Admin' on machine 'xxxxx'. Try
again with the database is available"

Any ideas

 

[Guest]

Where are the databases located? Are they on your local hard drive, or on a
shared file server? If they are on a shared file server, are you certain that
no one else has them open?

Look in the same folder as the databases for small 1 KB locking database
files (*.ldb), which have the same filename, but with the .ldb extension. If
you see a .ldb file present, try to delete it. Then see if you can convert.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

These DB's are on my local C drive. I have checked and the directory
permissions are correct and the file is not set to read only.
I am wondering if it isn't some security setting in access 2007 that is
causing the problem. I have googled the problem and I cannot find an answer

Thanks

 

[Guest]

Just an idea:
Did you try to open MDB in previous version of Access ? Try to open it in
the same version that you created it with, then open a module and try to
compile.
You may also want to de-compile before upgrade.

HTH

Vlado

 

[Guest]

Brian,

Were there any small 1 KB locking database files (*.ldb), which have the
same filename, but with the .ldb extension in the same folder? If a .ldb
file was not properly deleted when a database was closed, then Access may
very well think that someone else has the file open.

Introduction to .ldb Files
http://support.microsoft.com/?id=299373


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Nope I searched my complete c drive for any .ldb files are thier are none. I
am the only one that has access to these DB's so no one else would have them
open. I have even disconnected from my corprate network and tried and I still
got the saem error

 

[Guest]

Hi Brian,

On the .ldb files, you only need to look in the same folder as the .mdb file
that you are trying to convert. Try holding down the shift key for the entire
time that the database is being opened, to prevent an Autoexec macro or
Startup form from loading. Don't let up on the Shift key too early; wait
until your application has finished opening. Then see if you can convert.

If not, close the database. Create a brand new database in Access 2007. Then
try importing all objects from the source database to your new database. You
will need to check the references list in the source database, to make sure
that equivalent references are loaded in your new database.

If you still do not have any joy, then I invite you to send me a copy of
your database. You can remove any sensitive data first, but I'd like to see
if I can convert it on my PC. If you are interested, send me a private e-mail
message with a compacted and preferably zipped copy of your database. My
e-mail address is available at the bottom of the contributor's page indicated
below. Please do not post your e-mail address (or mine) to a newsgroup reply.
Doing so will only attract the unwanted attention of spammers. If you do
this, please use this subject:

RE: Upgrading DB from access 2003 to access 2007 problem

and reference this URL:

http://www.microsoft.com/office/com...cess&mid=950b6933-e7ec-484a-927f-3f77c8e319d3


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[bahaaskf]

These DB's are on my local C drive. I have checked and the directory
permissions are correct and the file is not set to read only.
I am wondering if it isn't some security setting in access 2007 that is
causing the problem. I have googled the problem and I cannot find an
answer

Thanks

 

[Guest]

Can you open your project in A2003?

Nope I searched my complete c drive for any .ldb files are thier are none.
I
am the only one that has access to these DB's so no one else would have
them
open. I have even disconnected from my corprate network and tried and I
still
got the saem error