Setting password on database

T

Treebeard

When you set a password on a database, what must you do in your code so that
you can open the database.

I'm using access 2000, VBA , DAO.

In other words , I normally open the table like this:

Dim dbs As Database, rst As Recordset, StrCriteria As String

' Return reference to current database.
Set dbs = CurrentDb

' open the Shipping table
Set rst = dbs.OpenRecordset(OEShip1EntryTableName, dbOpenDynaset)


But when I do this I get a password error.

Do I have to insert the password everytime I open a table, or can I do it
once when the program starts? How is this accomplished?

Thanks,

Jack
 
Top