connect to a user name and password protected Access file

  • Thread starter Thread starter Reny J Joseph Thuthikattu
  • Start date Start date
R

Reny J Joseph Thuthikattu

Hi,
When i try to connect to a user name and password protected Access file from
VB.NET i mam getting workgroup information file missiong.
Can any one tell me how to connect to it?
Reny
 
Hi Reny:

It'd help if you posted your connection string, but here is some general
guidelines... If you have a workgroup, use the following:

"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\PathHere\IWishIWasSqlServer.mdb;Jet OLEDB:Database
Password=xxxxxxxxxxx;"

To use User ID, just slip it in ... ";User Id=WannaBeSA;
Password=xxxxxxx;"

If these don't work, can you post your string.. .it'd help.

Thanks,

Bill
 
¤ Hi,
¤ When i try to connect to a user name and password protected Access file from
¤ VB.NET i mam getting workgroup information file missiong.
¤ Can any one tell me how to connect to it?
¤ Reny
¤

As Bill mentioned I would post your connection string. If you have implemented user level security
it sounds like you need to specify the path to the System.mdw file in your connection string.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top