Reply to thread

Message: [QUOTE="Ken Sheridan, post: 11791623"] Anna: The password to the back end file needs to be included in the Connect property of each linked table in the front end. You could amend this property and refresh the link for every linked table using code, but it would be simpler to delete all the linked tables from the front end (this doesn't delete the actual tables, only the links), and recreate the links from the File | Get External Data | Link menu item on the main database menu bar. You'll be prompted for the password when creating the links, and this will then be incorporated in the Connect property for each linked table in the front end. Its essential that you also password the front end file as otherwise all that any unauthorised user has to do to find the password of the back end file is to open the front end and enter the following in the debug window: ? CurrentDB.TableDefs("TableName").Connect where TableName is any linked table. This would give them something like this: MS Access;PWD=ABCD;DATABASE=F:\Databases\Anna\MyFile_be.mdb You'll see that it shows that the password for MyFile_be.mdb is ABCD. Ken Sheridan Stafford, England [/QUOTE]