Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Problem with database connection


Message #1 by Martin Lee <access@o...> on Wed, 27 Mar 2002 08:02:13 +0800
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


  Return to Index