Re: How are .ldb files unloaded

AK wrote:
Bob,

Thanks!
Here is my connection string.


strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Password=MyPassword;User ID=MyUserId;" & _
"Data Source=" & My_DatabasePath & ";" & _
"Jet OLEDB:Engine Type=5;" & _
"Jet OLEDB:Database Password=MyDataBasePassword;" & _
"Persist Security Info=True;" & _
"Jet OLEDB:System database=" &
My_DatabasePath_MDW_SecurityFilePath & ";" & _
"Jet OLEDB:Encrypt Database=True"

Are your saying that I need a Mode=ReadWrite somewhere in here?

No. Your connection string is irrelevant. File system permissions are
required


This is probably a permissions problem. All users of the database
file must have read/write permissions for the _folder_ containing
the file. The ldb file needs to be created under the context of the
first user to open the database, modified under the contexts of
subsequent users, and deleted under the context of the last user to
exit the database.

Keep in mind that with OLEDB session pooling, connections are kept
open for 60 sec. enabling their re-use.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.