Putting DB on new computer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have setup a DB and implemented security. My question is, I am going to be
putting this DB on another computer to be used, will the security settings
have to be redone or setup on the other computer? Thanks!
 
The workgroup file where you built those settings will need to be copied
along with the database.

If you copy the database and you are able to open it on the other computer
(which is a pretty common issue) then it means your database file is not
really secured. Good time to test this!
 
So will I need to completely go through the security process on the other
computer or is there a simpler way to do it. By the way, I'm not very
computer literate (I'm an accountant!) Thanks.
 
burr_accountant said:
So will I need to completely go through the security process on the
other computer or is there a simpler way to do it. By the way, I'm
not very computer literate (I'm an accountant!) Thanks.
Click to expand...

No it means you go back to the original computer and try again to apply
security properly. What you have now is incorrect.
 
burr_accountant said:
So will I need to completely go through the security process on the other
computer or is there a simpler way to do it. By the way, I'm not very
computer literate (I'm an accountant!) Thanks.
Click to expand...
Once you have set up security correctly you need to copy the mdb file and
the associated mdw file to the host computer. You would then open the db
using a shortcut with a command line in the format:

"Full path to MSACCESS.exe" "Full path to your mdb" /wrkgrp "Full path to
your mdw"

including the quotation marks. If you're unsure about whether or not you've
implemented security correctly then one test is to try and open it from the
"other" PC from a browser. You shouldn't be able to. Also, if you haven't
done so already then have a look at the MS FAQ and my security example
(links to both on my web site) - the FAQ is required reading and my example
may help you to understand it. *Always* work on copies of your files!

Regards,
Keith.
www.keithwilby.com
 
When I tried to open the DB on another computer, it told me I didn't have
permission, so does that mean the security actually is set correctly?
 
burr_accountant said:
When I tried to open the DB on another computer, it told me I didn't
have permission, so does that mean the security actually is set
correctly?
Click to expand...

It's a good sign, yes. Then you need to copy the workgroup file that you
used to secure the file to that computer as well and then create a shortcut
that opens the file while simultaneoulsy specifying that workgroup. The
syntax is roughly...

"Full path to MSAccess.exe" /wrkgrp "Full path to MDW" "Full path to MDB"
 
burr_accountant said:
So will I need to completely go through the security process on the other
computer or is there a simpler way to do it.
Click to expand...

Depends what you mean by the "security process".

You'll need to copy the database (mdb) file, and the appropriate
workgroup (mdw) file, and a suitable shortcut (using the /wrkgrp
switch), to each PC. And each PC must, of course, have a working copy
of a suitable version of Microsoft Access.

There are other products that let you write an installation program to
wrap up all those activities & perform them automagically. You might
use those products if, for example, you had to install the database on
more PCs than you could handle manually.

HTH,
TC
 
Back
Top