Click to See Complete Forum and Search --> : Accessing a password protected database


pritips
January 13th, 2000, 11:45 PM
I have a VB application with Ms Access as the backend. The database is constantly being updated.
In order to prevent any unauthorised person from changing the database through the backend(Through Access).I have made my database password protected.The Forms through which the data is added to the database are working properly with the password .For the reporting Crystal reports are used.But Crystal reports are not able to connect to the backend if the password condition is used.

I would be highly obliged if somebody could provide a solution to htis problem.Any code would be most welcome.
Thanks

rhermans
January 15th, 2000, 01:23 PM
The password property doesn't work for access passwords, you have to use the connect property.
ex. if your password is test the property becomes
;pwd=test
this should work with version 5 to 7