Splitting a Secure Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt W. - 15 May 2007 14:13 GMT

My database is secure and I am using the shortcut.
To split my database manually do i need to copy the shortcut or the secure
.mdb that the shortcut is pointing to? I would assume the secure .mdb the
shortcut is pointing to however I get a message saying I don't have the
necessary permissions to access it. The instructions that I followed for
securing my database state that this is correct that I should not be able to
open the secure .mdb.

Any help is appreciated.

Thanks,
Matt

Reply to this Message

Joan Wild - 15 May 2007 15:20 GMT

Hi Matt, You want to split the .mdb file not the shortcut. Since it is secure, don't split it using the wizard, as that will result in an unsecure backend. See
www.jmwild.com/SplitSecure.htm

If you are able to open the database via a double click on the shortcut and successfully login, then you should have no problem opening Windows Explorer and selecting the file to copy it. You don't want to actually open the secure mdb file to do this.

Signature

Joan Wild
Microsoft Access MVP

> My database is secure and I am using the shortcut.
> To split my database manually do i need to copy the shortcut or the secure
[quoted text clipped - 8 lines]
> Thanks,
> Matt

Reply to this Message

Matt W. - 15 May 2007 17:32 GMT

Joan,
My question is if I copy my database and the copy will be my backend, how do
I open it to delete all the objects except the tables if the original
database can only be opened by the shortcut. When I try to open the copy I
get the message that I do not have permissions. I know I am just missing
something very simple. Thanks for you patience.

Matt

> Hi Matt, You want to split the .mdb file not the shortcut. Since it is secure, don't split it using the wizard, as that will result in an unsecure backend. See
> www.jmwild.com/SplitSecure.htm
[quoted text clipped - 13 lines]
> > Thanks,
> > Matt

Reply to this Message

Rick Brandt - 15 May 2007 17:38 GMT

> Joan,
> My question is if I copy my database and the copy will be my backend,
[quoted text clipped - 3 lines]
> know I am just missing something very simple. Thanks for you
> patience.

Use the same shortcut or copy it and change the copy to point at your BE
file.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Joan Wild - 15 May 2007 21:38 GMT

Just open your frontend via your desktop shortcut. When you login, you'll have an Access session running, using your secure mdw. Now hit Ctrl-O and open the backend.

Signature

Joan Wild
Microsoft Access MVP

> Joan,
> My question is if I copy my database and the copy will be my backend, how do
[quoted text clipped - 22 lines]
>> > Thanks,
>> > Matt

Reply to this Message

Keith Wilby - 15 May 2007 15:42 GMT

> My database is secure and I am using the shortcut.
> To split my database manually do i need to copy the shortcut or the secure
[quoted text clipped - 9 lines]
> Thanks,
> Matt

If your mdb is secure then you can only open it using your custom workgroup,
either using a shortcut to join it or by joining it from within Access. It
sounds like yours is properly secured.

To split, copy the secure mdb in an explorer window and give it a meaningful
name. Locate it in a folder that all users have access to (usually on a
server). Open the copy and delete everything except the tables. Compact.
Open the original and replace all native tables with links to the tables in
the copy. Compact. Job done.

HTH - Keith.
www.keithwilby.com

Reply to this Message