persist security info

[Dinçer]

I have a program which is written with VB6.
It connects to a Access database with this string:
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\dbfolder\mydb.mdb;Persist Security Info=False"

However, when the program is run on Windows 95, it cannot connect to
database and gives the error:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done."

When I change the connection string to:
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\dbfolder\mydb.mdb"
Then, it connects to the database..

What is the job of "Persist Security Info=False" in this string? Do I lose
something when I remove it from the connection string? Does this cause any
problems on W98, or W2K ?

 

[Arvin Meyer]

If you don't have any security set at all, removing it won't hurt anything.
The argument only comes into play when you need to pass a username and
password to the connection in order to open the database. This is clearly
not the case in your connection string.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access