Splitting a Database that has security

  • Thread starter Thread starter DMH
  • Start date Start date
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!
 
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!
 
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!
 
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?
 
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!
: >
 
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
 
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!
: > : >
: >
 
Back
Top