Access 2000 Locked/Readonly

[Jim Bunton]

Access 2000 (o2ksp3.exe installed - before running o2ksp3on the office2000
installation acwx*.mde renamed to
acwx*.old)

Running on Windows Xp

A web application (being tested on LocalHost)
1. If I have the access database open (in Shared mode) database operations
gives the error 'locked by another user'. [This is not the case in the same
situation using the same code as my (old) Win 2000 set up on a different
machne.

2. With the database closed, the web app can displat data from the Access
database BUT cannot alter the data - error > data is 'read only'

*** Code snippet - Connect to database **
Function OpenConnToGoodsInStock()
dim Cn
Set Cn=Server.CreateObject("ADODB.Connection")
Cn.Provider = "Microsoft.Jet.OLEDB.4.0"
Cn.Properties("Data Source") = "e:\ . . \Test.mdb"
Cn.Properties("User ID") = "Admin"
Cn.Properties("Password") = ""
Cn.open
set OpenConnToGoodsInStock = Cn
End Function
*** end code ***

[NOTE: not to do with the web based application -
when a second Access application is run it opens very slowly (compared with
the old installation on win 2000) - subjectively it looks/feels like there
is a sharing issue related to the access installation. The screen first very
briefly shows the access openening screen, goes balnk and 'waits' for a
second or two before opening the second access application]


--
Jim Bunton
13 Westbourne Road
Trowbridge
Wilts BA14 0AJ
01225 765 541
+447919 283 968