Hello,

I have an Access XP database that has attachments to a BE database that has
a password.  The attachments work fine, until I run some code that modifies
a BE table (adding a field).  I do this by running code similar the
following;

Public varDb as DAO.database
sub ConnectBEDatabase(strLocation as string)
   Set varDb = OpenDatabase(strLocation, False, False, ";pwd=" &
GetPassword())
end sub

sub DisconnectBEDatabase()
   set varDB=nothing
end sub

function GetPassword()
   getpassword="MyPassword"
end function

public Sub UpdateBE()
   ConnectBEDatabase("C:\MyDatabase.mdb")
-----code to add a field to a table-----

-----end code to add a field-----
DisconnectBEDatabase
end sub

The problem is, once I run the disconnect, my table attachments all of a
sudden say "Not a valid password" or something of the like.  I'm not
modifying the connectd strings or anything, just modifying the back end
tabledef.

Any ideas?

Thanks!