
password protected Access data base with Data Control
dim db as database
dim dbpass as string
dbpass=";pwd=abc" 'assuming your pwd is abc
set db=opendatabase("xyz.mdb",false,false,dbpass)
this will open a password protected access database in vb
bernd
Quote:
> Can I supply a password through my vb code (using a data control) that
will
> open up a password protected access database. Can I supply this as an
> argument or do I have to go through Data Access Objects?
> I don't want users to access this database through excel or access, but I
> want then to be able to write/read to the table through my application.