local path variable...

Hello,

I'm trying to make a shortcut that will open an mdb in the same folder
as the shortcut - regardless of where the file/shortcut may be. In other
words, I wan to be able to copy and paste the two files anywhere and have
the shortcut always open the mdb that was copied with it without having to
change the shortcut properties. I thought there was an environment variable
like %currentpath% that works like %username% which works in a shortcut.
Something like

"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
%currentpath%MyDB.mdb /user %username%

I can't get the %currentpath% part to work.

Does anyone know how to do this?

Thanks.


--
Matthew.Wells
Matthew.Wells@xxxxxxxxxxxxx


.

Relevant Pages

  • Re: Location of Workgroup administrator in Office 2002
    ... in the same folder. ... You shouldn't have multiple users sharing the same mdb. ... > shortcut to test the databse on my C drive the only difference being ... >> while using the system.mdw workgroup file. ...
    (microsoft.public.access.security)
  • Re: Security wizard
    ... "Joan Wild" wrote: ... you can't make design changes to a mdb file ... Then give each a shortcut ... DB is set up in a folder on a network that the users have been ...
    (microsoft.public.access.security)
  • Re: Pointing to a pointer to an .mdb
    ... shortcut to the batch file. ... Users run the shortcut, the shortcut calls ... the .bat file, the btch file runs the .mdb file, access starts and it ... current database, which is full of valid data, with a new database ...
    (microsoft.public.access.formscoding)
  • Re: Secure shortcut Unsecure File
    ... you have a shortcut with the following in the target: ... What do you mean when you say 'open the main mdb'? ... As for the security, it is impossible for me to know what step you ... opens without security. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... I have an MDB file that I secured a few weeks back which was working fine. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ...
    (microsoft.public.access.security)