Re: Split DB BE question

You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.

The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.

Re: Split DB BE question

Mary M

26 Apr 2006 12:51

> You could set an autoexec macro in the backend that pops up a message
> saying "Access the data via the frontend", and follow that with the Quit
> Action.
>
> You can then disable the shiftkey bypass on the backend.

Thanks, I thought of that but I couldn't figure out how to get into the
backend for modifications if the shift bypass was disabled. Any suggestions?
The FE already has the shift bypass disabled, so I keep a copy of the FE w/o
the bypass code so I can make edits.

Joan Wild

25 Apr 2006 21:32

Yes you can. Once you've done that open the frontend, and delete the links.
Re-create them using File, Get External Data, Link and when you locate the
backend, it'll prompt you for the password (which will get stored with the
links).

However, you should know that the database password is easily cracked.

You could set an autoexec macro in the backend that pops up a message saying
"Access the data via the frontend", and follow that with the Quit Action.

You can then disable the shiftkey bypass on the backend.

Signature

Joan Wild
Microsoft Access MVP

> If you have a DB split using a FE and a BE can you put a password on
> the BE db? Or will that cause the FE /BE not to work? Basically I
[quoted text clipped - 3 lines]
> Thanks in advance.
> .

Mary M	25 Apr 2006 18:07
If you have a DB split using a FE and a BE can you put a password on the BE db? Or will that cause the FE /BE not to work? Basically I don't want a user to be able to open the BE db and see the tables, values ect. The FE is already an mde application. Thanks in advance. .

Quick links: