Migrating Access app

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have an Access app which is secured (custom mdw file, database
password.) Kind of sorry I did this, but there it is. Anyway, my
users have a new computer to which I'm trying to migrate the app.
I've copied all of the files, including the mdw file, to the new
computer, and used wrkgadm.exe to join to the proper mdw file.
Problem is that it won't work! I always get "you do not have
necessary permissions" when trying to open the file. In fact, I
don't even get prompted for the database password the way I normally
do.

I tried to remove the security using the steps outlined elsewhere on
this forum (assign permissions to everything for the Users group,
rejoin system.mdw, create a new database, and import everything.) I
can't do that last step -- it will not let me import anything from the
old file unless I am in the custom mdw file. As soon as I rejoin the
custom mdw file, I have no problems.

Anyway, my goal is to get this app working again on the users' new
computer. Any ideas?
 
Tom said:
I have an Access app which is secured (custom mdw file, database
password.) Kind of sorry I did this, but there it is. Anyway, my
users have a new computer to which I'm trying to migrate the app.
I've copied all of the files, including the mdw file, to the new
computer, and used wrkgadm.exe to join to the proper mdw file.
Problem is that it won't work! I always get "you do not have
necessary permissions" when trying to open the file. In fact, I
don't even get prompted for the database password the way I normally
do.
Click to expand...

Try creating a desktop shortcut to open the database instead. The target
would have the following:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
I tried to remove the security using the steps outlined elsewhere on
this forum (assign permissions to everything for the Users group,
rejoin system.mdw, create a new database, and import everything.) I
can't do that last step -- it will not let me import anything from the
old file unless I am in the custom mdw file. As soon as I rejoin the
custom mdw file, I have no problems.
Click to expand...

Then you didn't give full permissions to everything to the Users Group. You
probably missed the database object.
 
When you say "database password", do you mean the password that you enter
together with a username, or the password that you enter on its own (without
a username)?

TC
 
Back
Top