password protected Access data base with Data Control 
Author Message
 password protected Access data base with Data Control

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.


Fri, 21 Dec 2001 03:00:00 GMT  
 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.



Fri, 21 Dec 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB4: How to let a Data control access a password protected ACCESS database

2. Using MS Data Control DAO to access a password protected database

3. using data control on password protected access db

4. Connect VB data control to a password protected MS Access database

5. (Urgent) Use Data Control (DAO) to open a password protected Access Database

6. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)

7. using data link with password protected access database

8. Connect password protected Acess database to a data control

9. Problems with ADO Data Control connecting to a Password Protected MDB

10. data control for password-protected database

11. Connecting to a Password Protected MDB using the ADO Data Control

12. Data Control with Password protected database

 

 
Powered by phpBB® Forum Software