Database spliter

[anna]

Hi
can you please help me
I split my database and set up password for my new end database but now I
can not access a forms or queries in my front database when I removed the
password everything works ok so haw can I apply password to my end
database and still access the front one
Thanks for your help in advance
Anna

 

[Ken Sheridan]

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

 

[anna]

Thank you
it solved my problem
Regards Anna

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

 

[anna]

Thank you for your help
Regards Anna

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