Connection to Access DB problem when moving from NT Server to Server2003

From: pvictor (pvictor_at_eudaemonics.com)
Date: 03/28/04 

Date: Sat, 27 Mar 2004 18:06:09 -0800

I have a standalone VB6 application under which multiple LAN stations use an Access 2000 database stored in the server. The application runs fine under NT Server (e.g. all stations can read and update the DB concurrently). All Access DB usage is via ADO. The server is just a file repository and all logic, including ADO, is out on the LAN stations (running Win2000 and WinXPPro)

We are converting to Server 2003 Enterprise. Everything works fine EXCEPT that only one (1) LAN station at a time can open a connection to the Acces DB on the server. The application runs fine on this station. so I am pretty sure that the basic DB logic is okay.

However, when a second station tries to open an ADO connection to the DB, we get Error 16389 with the message "[Microsoft] [ODBC Microsoft Access Driver] Could not Use '(Unknown)' File is in use".

The only change between the two setups is the change from NT Server to Server 2003. I suspect a difference in the security or permissions between the two environments, but have not been able to solve the problem so far.

Any help would be very much appreciated.

Relevant Pages

  • Re: Access Control Best Practices for shared hosting seem at odds with Web Site Starters
    ... the server can write a file somewher. ... Security depends on the application itself. ... The MS Shared Hosting Deployment Guide lists among best practices: ... Ensure strong permissions are used on Web content ...
    (microsoft.public.inetserver.iis.security)
  • Re: File Sharing Nightmares
    ... Vista's SP1 has some stuff disabling secedit in favor of gpedit.msc. ... that the server was the issue. ... "The Group Policy security settings that apply to this machine could not be ... >> Permissions trouble for the registry entries. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Moved & Deleted Files
    ... > share has correct share/ntfs permissions and that the permissions are not ... > share will not go to the recycle bin on the server. ... > For Windows 2000 you can enable auditing of object access in the Local ... > Security Policy or Domain Controller Security Policy for domain controllers ...
    (microsoft.public.security)
  • Re: 80004005 Unspecified Error
    ... every update that comes down the pike restricts access and hardens security. ... Just because your Jet database has none of Jet's security ... it has associated launch and activation permissions. ... It worked just fine (I had to restart my win2000 server) TILL I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problem sending emails
    ... you may want to review the security you've put into place and undo it to see ... The 5.7.1 event you're seeing is usually a permissions related issue on the ... SMTP virtual server. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.exchange.connectivity)