Splitting a Database that has security

D

DMH

Can someone walk me through splitting a database that I have implemented user
level security on? I've never done a split before and the security is
finally working properly I don't want to ruin what I've done so far!
 
J

Joan Wild

Whatever you do, don't use the Database Splitter Wizard. Split it manually. It's quite easy - see the step-by-step at
www.jmwild.com/SplitSecure.htm

--
Joan Wild
Microsoft Access MVP
: Can someone walk me through splitting a database that I have implemented user
: level security on? I've never done a split before and the security is
: finally working properly I don't want to ruin what I've done so far!
 
D

DMH

HELP! I lost all my queries and forms! I made a copy of the shortcut and
even backed it up but the items I deleted are gone from it now even my backup!
 
D

DMH

Ok had a backup that was not linked to the shortcut so I got most of my work
back. Can you provide more detail as to how to do the spit? Do I copy the
shortcut or the actual mdb? I can't get into my mdb without a shortcut
because of the security?
 
J

Joan Wild

The shortcut is just a pointer to your mdb. You might use it to start the mdb, but that's all. You want to copy your mdb file, not the shortcut!

First step is make a backup, as you know.
Put the copy on the server, and change the name of the file.
Use your shortcut to open your original mdb. Delete all the tables in it. Then use File, Get External Data, Link and locate the file you put on the server. Choose all the tables, and click OK.
Hit Ctrl-O and open the copy you put on the server. Delete all the queries/forms/reports/macros/modules in this mdb.

Now you have a 'backend' mdb on the server, and your original mdb - 'frontend' mdb (which should be on your computer), which has links to the backend on the server.

Your original shortcut will work as is; opens Access, uses your secure mdw, and opens the frontend.

--
Joan Wild
Microsoft Access MVP
: Ok had a backup that was not linked to the shortcut so I got most of my work
: back. Can you provide more detail as to how to do the spit? Do I copy the
: shortcut or the actual mdb? I can't get into my mdb without a shortcut
: because of the security?
:
: "Joan Wild" wrote:
:
: > Whatever you do, don't use the Database Splitter Wizard. Split it manually. It's quite easy - see the step-by-step at
: > www.jmwild.com/SplitSecure.htm
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : Can someone walk me through splitting a database that I have implemented user
: > : level security on? I've never done a split before and the security is
: > : finally working properly I don't want to ruin what I've done so far!
: >
 
D

DMH

Hi Joan,

Looks like everything is going ok except when I try to open my backend mdb
to delete the queries, forms etc using CTRL O doesn't work. Do I need to
create a shortcut to the backend mdb to access it as well?

Thanks
 
J

Joan Wild

You shouldn't need a separate shortcut (but if push comes to shove, you can create one).

That's Ctrl-O as in 'oh' not zero.

If you want you can create a shortcut to the backend?
"path to msaccess.exe" "path to backend" /wrkgrp "path to secure mdw"

--
Joan Wild
Microsoft Access MVP
: Hi Joan,
:
: Looks like everything is going ok except when I try to open my backend mdb
: to delete the queries, forms etc using CTRL O doesn't work. Do I need to
: create a shortcut to the backend mdb to access it as well?
:
: Thanks
:
: "Joan Wild" wrote:
:
: > The shortcut is just a pointer to your mdb. You might use it to start the mdb, but that's all. You want to copy your mdb file, not the shortcut!
: >
: > First step is make a backup, as you know.
: > Put the copy on the server, and change the name of the file.
: > Use your shortcut to open your original mdb. Delete all the tables in it. Then use File, Get External Data, Link and locate the file you put on the server. Choose all the tables, and click OK.
: > Hit Ctrl-O and open the copy you put on the server. Delete all the queries/forms/reports/macros/modules in this mdb.
: >
: > Now you have a 'backend' mdb on the server, and your original mdb - 'frontend' mdb (which should be on your computer), which has links to the backend on the server.
: >
: > Your original shortcut will work as is; opens Access, uses your secure mdw, and opens the frontend.
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : Ok had a backup that was not linked to the shortcut so I got most of my work
: > : back. Can you provide more detail as to how to do the spit? Do I copy the
: > : shortcut or the actual mdb? I can't get into my mdb without a shortcut
: > : because of the security?
: > :
: > : "Joan Wild" wrote:
: > :
: > : > Whatever you do, don't use the Database Splitter Wizard. Split it manually. It's quite easy - see the step-by-step at
: > : > www.jmwild.com/SplitSecure.htm
: > : >
: > : > --
: > : > Joan Wild
: > : > Microsoft Access MVP
: > : > : Can someone walk me through splitting a database that I have implemented user
: > : > : level security on? I've never done a split before and the security is
: > : > : finally working properly I don't want to ruin what I've done so far!
: > : >
: >
 

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

Similar Threads

Need Help with Macro Security 1
user-level security and splitting database 3
Microsoft 365 Activations, Users or Devices? 0
Merging from an Excel file with graphics 1
Ready to secure my database 1
splitting a database with user level security 1
Security and .mdE 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top