Can’t open MS Access database on file server

pts.
Tags:
Networking
Access 2000 database is now installed on Window 2000 Server (File Server and Domain Controller), using Active Directory. Win98 SE Client running Access 2000 can open it, but when I try to open it with Access 2002 on my XP Pro client, Access refuses, telling me it's not a trusted site or outside the Intranet, and suggesting I copy the database to a local drive to open it. This works OK when the database is closed - I can copy it, modify it, and copy it back just fine. Obviously it doesn't allow me to modify the database when it's in use elsewhere... I'm still in the process of setting up the Server, am a total Rookie with 2000 Server, so you may have some questions I don't know enough to answer yet... I've looked at Access and Windows security settings, poked around the Registry a bit too, and have yet to figure out where the source of the problem is. Here's hoping (as seems to happen a lot here) that you'll see this, remember solving the same issue yourself, and get me online. Otherwise, let me know the questions I haven't answered yet - very likely in looking for those answers I'll see the problem, otherwise over time I'm confident you'll help me reach the solution! I will be gradually adding Read-Only or Read-Write access to other Clients in the LAN, and eventually on the VPN as well, so I'd also welcome words of wisdom on networking MS Access and on Win 2000 Server/Active Directory configuration. Thanks, -Bob

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can you provide the exact error message you are receiving from both the Win98 and WinXP clients?

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Howard2nd
    A) You will get an error message every time you try to open the 2000 db with 2002 Access on three counts. Version 2002 wants to upgrade the DB from 2000, And XP wants to 'lock' the database which the 2000 server doesn't like, And every save MUST be 'save AS' to DB in 2000 format. B) Look at permissions on the server for folder, DB, and share - especially group and login names for 2000 and "Pre2000". C) check domain shares for user and computer - XP is more secure by being more difficult to setup. Check permissions from the Server console AND from the workstation. A = B = C therfore A = C is true in math but not always true in the wonderful world of 'Windows'!
    30 pointsBadges:
    report
  • Ghigbee
    Check out this Microsoft Article: http://support.microsoft.com/default.aspx?scid=kb;en-us;303650
    0 pointsBadges:
    report
  • VietBob
    Thanks, the KB article does appear to directly address my problem! I have some confidence the workaround will solve it, either way I'll get back to you all! -Bob
    0 pointsBadges:
    report
  • VietBob
    Thanks to your help, all is well! Presently about half my day there is usually nobody needing access to the database, so I can do design work without a problem (and now know to close the database after I'm done). In the future, this won't be the case. I'll start a new thread on the pros and cons of splitting the database... Thanks again for your help! -Bob
    0 pointsBadges:
    report
  • Tommyfarren28
    To restore ms access database you may use next software. http://www.access.fixtoolbox.com restores access databases in cases: database cannot be opened or read, .mdb file is corrupted and so on.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following