[AccessD] Problem with .Net and Access

Doug,

  Given that the strings are identical, a first guess would be permissions.
Make sure the Web server account and the other user both have full privs
(read, write, delete) for the DB directory.  Also that you don't have two
DB's in the directory with the same base name (ie. myApp.MDB and myApp.MDW).
If you do, the LDB file will end up with the same name in both cases and all
kinds of weird things will happen.  Finally, make sure it's not being virus
scanned at open. 

 Those are all the usual culprits.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Tuesday, October 25, 2011 12:15 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Problem with .Net and Access

Hello All:

I have two very similar .Net 4.0 websites which use Access back ends.

The first site runs on a Windows 7 server with IIS7 and has no problem
accessing the Access back end in a multi user environment.

The second site runs OK on my development machine on Win 7 and IIS7.

I am trying to get the second site to run on the client's Windows XP server
with  IIS5.1.  It runs perfectly well as long as it has exclusive access to
the back end db, but as soon as the back end db is opened by another user, I
get a "Could not use ''; file already in use" message.

The connection strings in the two sites are identical.

Does anyone have any suggestions?

Thanks,
Doug
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com