Problem with Access 2007

[HatterasSolutions]

I am converting databases from Access 2003 to Access 2007. I have two databases, one with code, reports, etc. the other with data. The one with data has been password protected. How do you send the password to the data database from the code in a form in the program database so that you can access linked data tables in the data database. Thanks for any help. I feel pretty silly but I have wasted several hours looking and cannot find any help. I miss the user level security.

[NTC]

User Level Security continues in A07 if you remain in the .mdb format.

If you are going to .accdb; what you might consider doing is opening a new .accdb db and then importing the tables. Not 100% sure, but I would give it a try.

Hope this helps.

[DaveT]

You can link to a backend, data file from code in the front-end using the connect (string) property such as:

tdf.Connect = "MS Access;DATABASE=C:\aProjects\aDEV\DevDemoDat.accdb ;TABLE=DemoTable;Pwd=daLLas"

If the table was linked before, you use tdf.RefreshLink; if you need to add the table to the front end entirely, use dbs.TableDefs.Append tdf.

I've left out most of the code. If you're familiar with linking through VBA, you can fill in the blanks, otherwise I can provide more detail.

The objects used in the snippet above are:

Dim dbs As DAO.Database
Dim tdf As DAO.TableDef

I use this to link/re-link tables in an Access 2007 accdb data file that is password protected.