Linking tables from a password secured database

[DavidMurray]

I have a database application named interco with 2 tables named a and b. This database is secured with a password. In another database application, I link to tables a and b. I have been noticing that when using a macro to delete and relink the tables the application will ask for a password and then not link the tables. When I take off the password on the first database application the tables link in. Does any one have any ideas why this is happening and how I can get around this issue? The first database must be secured.

Thanks in advance to everyone.

 

[smedvid]

Here is a method I've used in the past... to update a table within a password protected database.

Dim db1 As DAO.Database
lcSQL = "Update RunDate Set RunDate = #" & Me.RunDate.Value & "#"
Set db1 = DBEngine.OpenDatabase(Me.DBNameLoc, False, False, "MS Access;PWD=passwordhere&quot 'Note Password Hard-Coded!
db1.Execute lcSQL, dbFailOnError
db1.Close



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...