Helo,
I am developing an application in VBA for my business that is being used by many users.
I am using the reference Microsoft ActiveX Data Objects 2.7 and the following connection string:
Path = basisPath
Path = Path & "\" & "DBGF.mdb"
cnn.Open ConnectionString: = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =" & Path & "Persist Security Info = False; Jet OLEDB: Database Password = password"
Some users are having a problem in time to connect. An error message appears saying that the database is being used by an administrator (but it isn't true) or any other error:
I think it's a problem in DLL installed on users' machines.
a friend suggested me to use the JET expression library reference service ....
I have some questions:
Which one is better?
How to solve my problem?
If the solution is to use the library JET, please send me a code fragment of the connection or that I can rely as never used that.
Thank you for your attention.
I am developing an application in VBA for my business that is being used by many users.
I am using the reference Microsoft ActiveX Data Objects 2.7 and the following connection string:
Path = basisPath
Path = Path & "\" & "DBGF.mdb"
cnn.Open ConnectionString: = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =" & Path & "Persist Security Info = False; Jet OLEDB: Database Password = password"
Some users are having a problem in time to connect. An error message appears saying that the database is being used by an administrator (but it isn't true) or any other error:
I think it's a problem in DLL installed on users' machines.
a friend suggested me to use the JET expression library reference service ....
I have some questions:
Which one is better?
How to solve my problem?
If the solution is to use the library JET, please send me a code fragment of the connection or that I can rely as never used that.
Thank you for your attention.