Setting a Database Password

G

Guest

I have set a password on the backend of my database, now when I try to open a
linked table or a form in the front end of the database it gives me a "Not a
valid Password" message box. Is there a way to keep the password on the
backend of the database but still be able to access the tables and forms in
the front end of the database?

Thanks in advance.
 
6

'69 Camaro

Hi.

You'll need to drop the links to the tables in the back end, then recreate
the links with the correct database password.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
6

'69 Camaro

Hi.
Not sure how I drop the links to the tables in the back end.

First, make a backup of the front end, just in case something goes wrong.
Make a note of the path and file name of the back end. Make a note of any
linked table names in the front end that don't exactly match the names of
the tables in the back end so that you can change the names after the links,
if necessary.

Open the front end database and close all objects, except for the Database
Window. Select the Tables tab of the Database Window. Select the linked
tables and delete each of them. (The linked tables have an icon of a table
with an arrow pointing from left to right.) Select the File menu -> Get
External Data -> Link Tables to open the Link dialog window. Browse to the
directory and select the file name of the back end of the database. Select
the "Link" button.

Type the database password when prompted and select the "OK" button. Select
the "Select All" button in the Link Tables dialog window (or just select the
tables that need to be linked from the front end). Select the "OK" button
to link to those tables.

If there are any linked table names that need to be changed, now is the time
to do it so that any queries or forms depending on these names can find the
correct objects when they open.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
G

Guest

Figured it out...thanks so much for the help

'69 Camaro said:
Hi.

You'll need to drop the links to the tables in the back end, then recreate
the links with the correct database password.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
G

Guest

Gunny

I am looking for something very similar to this, but I wish to supply the
password in VBA at logon time. Any ideas on ow to do this?

TIA
Chris
 
T

TC

Um, google this group for "password link" (without the quotes) and look
at some of the 665 answers provided?

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top