Can someone help me with a connection to an Access Database
With the below connection, everything works fine until we set the database
password and add these details to the connection string. When we try and
run this we get:
Microsoft JET Database Engine error '80040e4d'
Cannot start your application. The workgroup information file is missing or
opened exclusively by another user.
Anyone have any suggestions? and is it necessary to password protect your
on-line data?
Set objconn=server.createobject("adodb.connection")
'objconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" & 'Server.MapPath("/Data/Test.mdb")
objconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
& Server.MapPath("/Data/Test.mdb")_
& ";Persist Security info=False; User ID = admin; Password = password"
objconn.Errors.Clear
objconn.Open
Thanks
Martin