Can't open secured database after moving

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I built a secured Access 2000 database on my PC and am
ready to move it onto users machines; however, I cannot
get the secured database to open on their PC's.
I created the same folders, copied both the mdb and mdw
files to the correct folders, and put the following path
in their shortcut:

"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "C:\Database\Security\SIR.mdb"
/WRKGRP "C:\Database\Security\Secured.mdw"

This is a split database but it works fine the way it is
organized on my PC with the same paths on the users PCs.

The error message I get is: "The command line you used to
start Microsoft Access contains an option that Microsoft
Access doesn't recognize. Exit and restart Microsoft
Access using valid command-line options."

MSACCESS.EXE is loaded in the same location as the path is
pointing to also.
What am I missing?

Thank you in advance for your help,
Al
 
Hi Al,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
"....put the following path in their shortcut:
"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "C:\Database\Security\SIR.mdb"
/WRKGRP "C:\Database\Security\Secured.mdw"

"...The error message I get is: "The command line you used to start
Microsoft Access contains an option that Microsoft Access doesn't
recognize. Exit and restart Microsoft Access using valid command-line
options."


Try this as a shortcut:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /WRKGRP
"C:\Database\Security\Secured.mdw"

Do Microsoft Access open? If not, create an *.MDW file with a short name,
example

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /WRKGRP
"C:\Test\Test.mdw"

If that one does work and you've ensured there are no syntax errors in
yours then you might be running into issue of long file name (related to
WinMe misinterpreting spaces in long file name)

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
I tried your first suggestion of removing the reference to
the path, "C:\Database\Security\SIR.mdb" from the target
string. Access opened fine but still will not open the
SIR.mdb file on the user's machine.
Any suggestions? Thanks...Al
-----Original Message-----
Hi Al,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
"....put the following path in their shortcut:
"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "C:\Database\Security\SIR.mdb"
Click to expand...
/WRKGRP "C:\Database\Security\Secured.mdw"

"...The error message I get is: "The command line you used to start
Microsoft Access contains an option that Microsoft Access doesn't
recognize. Exit and restart Microsoft Access using valid command-line
options."


Try this as a shortcut:
"C:\Program Files\Microsoft
Click to expand...
Office\Office\MSACCESS.EXE" /WRKGRP
"C:\Database\Security\Secured.mdw"

Do Microsoft Access open? If not, create an *.MDW file with a short name,
example

"C:\Program Files\Microsoft
Click to expand...
Office\Office\MSACCESS.EXE" /WRKGRP
 
Al said:
I tried your first suggestion of removing the reference to
the path, "C:\Database\Security\SIR.mdb" from the target
string. Access opened fine but still will not open the
SIR.mdb file on the user's machine.
Any suggestions? Thanks...Al
Click to expand...


What happens when you attempt to open the sir.mdb? What error message do
you get?
 
Should the /WRKGRP be in lower case? (I don't have Access here to check)

Do you have the same drive letter (C:) on each PC?

HTH,
TC
 
Try this:
Load both databases where you want them.

Open the data-database and see if it runs OK. If not, then
there's the/a problem.

Then, go to your Forms Database and open it, holding down
the [Shift] key while launching it. You MAY get some
error message about it not finding table, attachments, or
whatever, just see if you can ever get into the design of
any of the forms. If not, there's the/a problem.

With the Forms database open, reattach the tables using
the linking wizard and then try opening it in view mode.
 
When I try to open the SIR.mdb file alone, I get the
message: "You do not have the necessary permissions to use
the C:\Database\Security\SIR.mdb object..."
 
Actually, I copied the path from my test PC, where it is
working, into a readme.txt file with instructions on how
to install the program (in case I'm hit by a bus tomorrow)
and then copied the path from that file directly into the
Target line of the shortcut on the users desktop. That
way the syntax would be exactly the same too.

The drive letters/paths are exactly the same on both PCs.
 
That message indicates that you are not using the correct mdw file. Or you
are logging in as a user that doesn't have open permission on the database
object.
 
That only happens if I try to open the SIR.mdb file from
Windows Explorer. If I use the desktop icon with
the .../WRKGRP... in the Target line it opens fine on my
PC.

However, setting it up on another PC with the same paths,
I get the following error message: "The command line you
used to start Microsoft Access contains an option that
Microsoft Access doesn't recognize. Exit and restart
Microsoft Access using valid command-line options."

I'm having a hard time testing some of the suggestions
above because the problem installation is at another
location.

Thank you for helping me with this.
 
OK, then there *is* something different between your setup (where it works)
and theirs.

Are you absolutely certain that the paths are the same for msaccess.exe, the
mdw and the mdb on their computer?

How are they setting up the shortcut on the desktop?

It sounds as though they have mistyped something.
 
(snip)
However, setting it up on another PC with the same paths,
I get the following error message: "The command line you
used to start Microsoft Access contains an option that
Microsoft Access doesn't recognize. Exit and restart
Microsoft Access using valid command-line options."
Click to expand...


If MS Access is objecting to a command-line option, then surely:
(a) the command line is wrong (eg. mistyped), or
(b) you are using a version of Access that does not recognize that option!

I can't see any other logical explanation, apart from Access codefile
corruption - a 0.00001% chance IMO.

HTH,
TC
 
Back
Top