Set up to run from icon

[TheB]

How do you set up access database to run from an icon on the desktop rahter than allowing user to go in using access?

Thanks in advance...

...TheB

 

[rockman]

Not sure this is what you are looking for but my shortcut target looks something like this:

"C:\Documents and Settings\All Users\Documents\Data Server\EMR.mdb" /runtime /wrkgrp

HTH,
Jeff

 

[ghudson]

Similar to Jeff's but with more detail...

If your db is not secured and you are not using a runtime, then try this...

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Databases\YourDB.mdb"

If your db is secured with a workgroup, then try this...

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp "C:\Databases\YourWorkGroupFile.mdw" "C:\Databases\YourDB.mdb" /user TestUser

If your db is secured with a workgroup and you are opening in runtime, then try this...

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /runtime /wrkgrp "C:\Databases\YourWorkGroupFile.mdw" "C:\Databases\YourDB.mdb" /user TestUser