Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Network Database access (Access 2000)

    I have a frontdoor/Backdoor Access database. The backdoor is running on an XP Pro workstation and the frontdoor machines are Win2000. Although the database has been split for some time, I have been doing all the form creation and editing on the same workstation that the backdoor is on and everything worked fine. Today I put the frontdoor files on the 2000 workstations and linked the tables to the backdoor. Still everything worked fine. Now for some reason, if I try to run the program on the 2000 workstations, I get the following error: "The Microsoft Jet engine cannot open the file Data_2005.mdb. It is already opened exclusively by another user, or you need permission to view its data." I

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Network Database access (Access 2000)

    Have you applied user-level security to the databases (more commonly called frontend and backend)?

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    I do have user level security on the frontdoor but it has been there all along. The is no security on the backdoor database. I am admin on all machines and have admin rights to all tables, queries and forms on the frontdoor. I hope that helps you help me.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    In the folder your backend resides in, is there an errant lockfile? (Data_2005.ldb)?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Network Database access (Access 2000)

    Are you usung the same workgroup file (.mdw) on the backend machine as on the frontend machines? If not, copy the secured .mdw from the backend to the frontends, and join it there, using the Workgroup Administrator application.

  6. #6
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    There is no locked database file on the backend. and "mdw" file is the same on both ends

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Network Database access (Access 2000)

    Are you absolutely sure that the users on the frontend machines have full permissions to the folder containing the backend database? This is required for Access to operate correctly.

    Are you absolutely sure that the old frontend database stored on the backend machine still works correctly? Can you relink the tables successfully there?

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Network Database access (Access 2000)

    The FE / BE works fine on the XP Pro workstation, but do the 2000 workstations have all the read/write etc permissions on the XP Pro workstations?

  9. #9
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    I just deleted and re-linked the old tables from the frontend database that is on the XP Pro workstation. They linked back up just fine and are accessing the backend without a problem. I personally have every access right on both the XP and 2000 workstations I am working with. The usernames and passwords are the same on both machines.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Network Database access (Access 2000)

    Can you relink the tables in the frontend on the XP machine using a UNC network path instead of a local path? If so, does this version of the frontend work when copied to a Win2000 machine (you shouldn't have to relink)?

    If you create a small new database on the XP machine with one dummy table, can you link to that from a database on a Win2000 machine?

  11. #11
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    What version of MSJet are you using?

  12. #12
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    Hans, that worked. I hope it stays now that I don't have to re-link. Do you think it was more of an XP/2000 problem more than a database problem?

    How do I find out the version of MSJet I have?

  13. #13
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    Search your hard drive for MSJet40.dll, right click file, click properties, click on version tab. Version should be 4.0.8618.0 on the Windows 2000 machines.

  14. #14
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Network Database access (Access 2000)

    That is the correct version on the w2000 machine

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Network Database access (Access 2000)

    > Do you think it was more of an XP/2000 problem more than a database problem?

    Unfortunately, I don't know. Glad it works now.

Page 1 of 2 12 LastLast

Posting Permissions

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