Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Question Unanswered: Cannot open an .mdb file

    OK
    I have a file called "Work Order.mdb" Access2000. It is on a computer using Windows98.
    I want to move the file to another (faster computer) it uses WindowsXP. I copied the file using a memory stick. The file works fine on the new computer. However, when I try to access the file from one of our other (networked) computers, no LUCK??
    It gives a message that the file is in use or not in the directory.
    I know it's not a network problem, because I tried doing the same with an excel file and it worked just fine.

    Any ideas?

    Michael
    Gotta to do some code

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Are you trying to open the file on each pc from the memory stick, or
    have you copied it to each computer?

    If your computers are networked, why not store it on the network?

    Is it 1 db, or a front end/back end setup?
    Inspiration Through Fermentation

  3. #3
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Are you trying to open the file on each pc from the memory stick, or
    have you copied it to each computer?
    The file is on the new faster computer. No we are not opening it from the memory stick.

    If your computers are networked, why not store it on the network?
    They are networked through a router. There is no server. It is just on one of the 8 copmuters in our office. We are a small construction company.

    Is it 1 db, or a front end/back end setup?
    It is one database. No front/back end setup.

    I am confused because I can put an excel file in the directory, and I am able to open it through the network from any other computer. This is why I don't think it is a network problem.

    Michael
    Gotta to do some code

  4. #4
    Join Date
    Feb 2004
    Posts
    90
    Could you post the exact wording of the error message?

  5. #5
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Microsoft Access can't find the database file "z:\WorkOrder.mdb."Make sure you entered the current path and file name.
    Gotta to do some code

  6. #6
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    My guess is that when you open the MDB you are creating an LDB file. If the user trying to open the MDB does not have write access on the faster computer then thay will not be able to open the MDB.

    One other note. The faster computer will not influence the speed of the database. Access does not work like SQL Server. The majority of the 'work' is done locally. So if you open the database on a slow system the database will be slow.

    An example, if you are looking for a few records in the Order table, the faster computer will send the Order table to the slow computer to have the slow computer search the Order table for the records it is looking for. The faster computer does not do any searching for the slower computer.

  7. #7
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Did you ensure that the shared drive that houses the mdb file is mapped as Z on the other users machines?

  8. #8
    Join Date
    Feb 2004
    Posts
    90
    What OSs are you using on the network? (Win 2k, XP Pro, XP home?)

    Is this happening on all of the networked PCs?

    Does it happen if you close the database on all machines, then open it on network PC through Access's File > Open dialog box?

    If you are using XP Pro, how are you assingning permissions? On each file? On folders?

  9. #9
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    rogue,
    Did you ensure that the shared drive that houses the mdb file is mapped as Z on the other users machines?
    Yes I did make sure both machines were mapped accordingly.
    Note: I get a new message though!

    The Microsoft Jet Database Engine cannot open the file 'Z:\\WorkOrder.mdb'. It is already opened exclusively by another user, or you need permission to view it's data.

    goldy,
    What OSs are you using on the network? (Win 2k, XP Pro, XP home?)
    We have 6 computers with WindowsXP home, 1 with Windows98, 2 with Windows 2000, sometimes 2 laptops WindowsXP professional.

    Is this happening on all of the networked PCs?
    Yes, I cannot open the file from any PC??

    Does it happen if you close the database on all machines, then open it on network PC through Access's File > Open dialog box?
    Yes, it gives the new message you see above.

    If you are using XP Pro, how are you assingning permissions? On each file? On folders?
    The computer with XP Pro is not really an issue right now!


    Michael
    Gotta to do some code

  10. #10
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    "The Microsoft Jet Database Engine cannot open the file 'Z:\\WorkOrder.mdb'. It is already opened exclusively by another user, or you need permission to view it's data."

    There are two \ in that path, if that is not a typo recheck your mappings.

    You stated that you can open an xls file on your Z drive from the other computers, can you also make changes to that xls file and save them on the Z drive from other computers?

  11. #11
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Sorry, the extra "\" is a typo!!

    I can edit, change, delete items and then save on the Excel file.

    Michael
    Gotta to do some code

  12. #12
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    By the way DCKnuckle,
    I appreciate your feedback on the speed of the computer.
    I would like it to be on the XP computer vs the Windows98 computer.
    Also, The hard drive is larger on the XP computer.

    Michael
    Gotta to do some code

  13. #13
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Is there any security set up on the db?

    Is there any code that fires on start up?

    Have you tried creating a new db (not a copy of the offending db) on the Z drive and accessing it from other pcs?

    Are all of the pcs running the same version of Access?

    What version of Access is the db in?

  14. #14
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    No security set up!
    No code that fires up at Start up!
    No, I have not tried to create another database. I am going to now though, just to see if it is an issue.
    Yes, All pcs run Access 2000
    Gotta to do some code

  15. #15
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Tried to create another database. same message
    Gotta to do some code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •