Cannot Open Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to open a database all morning. It is a 300+ Mb file.
For a while this morning it opened but there were no objects at all, no
tables, queries, reports etc. I used this database over the weekend last. I
tried to compact and repair and got message about no having necessary
permissions. I have never used security on the database.

Now when I try and open it I get a message that another user is modifying
the file.

The file is on a secured network drive, I have checked on this, no one else
is in the drive but me. I can't even get to the database window now.

Any ideas? Thank you.
 
Jeff said:
I have been trying to open a database all morning. It is a 300+ Mb
file.
For a while this morning it opened but there were no objects at all,
no tables, queries, reports etc. I used this database over the
weekend last. I tried to compact and repair and got message about no
having necessary permissions. I have never used security on the
database.

Now when I try and open it I get a message that another user is
modifying the file.

The file is on a secured network drive, I have checked on this, no
one else is in the drive but me. I can't even get to the database
window now.

Any ideas? Thank you.
Click to expand...

Take a look around. Is the a file there call YOURFILENAME.LDB ? Is
anyone else currently using that file? Can you delete that file (maybe more
important is can you delete any files in that directory)?

Do you have full rights to the files in that directory? Open Create,
Edit Delete?
 
I'd reccomend using SQL Server if you have that much data

Access MBD isn't reliable with more than 25 mb of data
 
I'd reccomend using SQL Server if you have that much data

Access MBD isn't reliable with more than 25 mb of data
Click to expand...

Maybe not with your database design.

I have had larger databases in a multi-user environment with no
problems.

Note: I am not suggesting that SQL is bad or should be avoided, but it
is not a universal answer and not the best solution for every situation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
What are the steps to fix damaged MDF files in SQL Server? 0
CANNOT OPEN DATABASE - ERROR MESSAGE! 4
Clarity needed re: compacting a database 11
HELP! CANNOT OPEN DATABASE!! 11
Database Not Opening 2
Recover my database 1
HELP! "The database....needs to be repaired" 17

Back
Top