Re: How are .ldb files unloaded

Bob,

Tracked down the problem. File permissions were OK, but it was that there
was an instantiation of a form object (so as to get its name property), and
when that instantiation was done it opened the connections that that
particular form had. So, even though the form had been unloaded and its
connection set to nothing, the instantion was enough to do enough of the
same thing as a load!

AK



"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:evXYTJOCHHA.4892@xxxxxxxxxxxxxxxxxxxxxxx
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.




.

Relevant Pages

  • Re: ActiveConnection works at one host but not at another
    ... I'd set the permissions for the .mdb file, ... I used a connection string because I'd read some forum ... Access 2002 database. ... I notice that instead of an explicit connection object, ...
    (microsoft.public.inetserver.asp.db)
  • Re: vpn permissions
    ... I configured the office's incoming connection to fixed IP ... So you are allowing your home computer to specify its PPP IP address? ... If you are using the same account credentials to authenticate the VPN that you use as your regular account at work, there shouldn't be any permissions issues. ...
    (microsoft.public.win2000.networking)
  • Re: Clients not able to login to Domain
    ... Ethernet adapter LAN connection: ... I have check permissions on all the shares in question. ... as if they never got logged into the SBS server to begin with. ... How did you join the laptop to the domain? ...
    (microsoft.public.windows.server.sbs)
  • RE: Jet database access problem from web service
    ... "Sonya" wrote: ... > I have trouble connecting to Access database from my web service. ... > normal user who has full permissions over Data directory; ... > I also tried an Odbc connection with with the follwoing string: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: dial up connection
    ... permissions. ... Install ppp and pppconfig. ... If you want to monitor this connection bring up gkrellm and it should have ...
    (Debian-User)