Daaf1
asked on
Conneting .NET windows app to a password secured MS Access Database
Hi,
I've created a Windows App which works with a MS Access Database.
I don't use an external app.config file, so it is integrated in the installer.
When i use the app with the db without password protection everything works fine.
Then when i set a password for the db and set it also in the Connection properties window (With the remember my password checked) the connection test result is fine, but when i run my app i get an Error that says "Not a valid password."
What am i missing?
I've created a Windows App which works with a MS Access Database.
I don't use an external app.config file, so it is integrated in the installer.
When i use the app with the db without password protection everything works fine.
Then when i set a password for the db and set it also in the Connection properties window (With the remember my password checked) the connection test result is fine, but when i run my app i get an Error that says "Not a valid password."
What am i missing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scott McDaniel (EE MVE )
How does your .NET app connect to the database?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi all,
I tried to set the password in the settings.settings file. Now the result is the following error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I don't know if maybe the problem lies in the way i set the password for the DB:
I opened the .mdb exclusive, then went to set password and set one.
I didn't do anything with the "WorkGroup information file". I don't really understand that (yet).
How do i connect with the DB?
I have set up a simple Homenetwork, nothing fancy...
I run two apps on two different machines. One of the machines functions as db-bearer.
The bearer machine links through the ConnectionString dirtect to it's harddisk, the satellite links, also through the ConnStr, to the bearers harddisk. The disk of the bearer is set to be shared and can be modified by the satellite.
Is that enough info?
I tried to set the password in the settings.settings file. Now the result is the following error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I don't know if maybe the problem lies in the way i set the password for the DB:
I opened the .mdb exclusive, then went to set password and set one.
I didn't do anything with the "WorkGroup information file". I don't really understand that (yet).
How do i connect with the DB?
I have set up a simple Homenetwork, nothing fancy...
I run two apps on two different machines. One of the machines functions as db-bearer.
The bearer machine links through the ConnectionString dirtect to it's harddisk, the satellite links, also through the ConnStr, to the bearers harddisk. The disk of the bearer is set to be shared and can be modified by the satellite.
Is that enough info?
ASKER
Axshun:
My connectionString does look like that... Just fails the @ sign in the beginning.
But all functions well when using the unprotected db...
My connectionString does look like that... Just fails the @ sign in the beginning.
But all functions well when using the unprotected db...
ASKER
Ok guys,
I found the problem.
Apparently VS put extra password notation in the connectionString. One i got it out of the way, things went smoothly... until i tried to use one of the integrated Crystal Reports, it asked me for the password.
I guess i have to make a new inquiry for the new problem...
I found the problem.
Apparently VS put extra password notation in the connectionString. One i got it out of the way, things went smoothly... until i tried to use one of the integrated Crystal Reports, it asked me for the password.
I guess i have to make a new inquiry for the new problem...