Splitting a Secure Database

[Matt W.]

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

 

[Joan Wild]

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.

 

[Keith Wilby]

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

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

 

[Matt W.]

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

 

[Joan Wild]

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.