does windows xp require a different command line for a shortcut. i have a shortcut to a db that uses the wrkgrp switch. it works fine on 98 and 2k, but xp doesn't seem to recognize the wrkgrp switch. i get that message about not having permission to open the db.
As far as I know there is no difference.
Make sure the path in the target line of the properties is right. Are you trying to access the secured database through the shortcut, and do the username have access to the database.
My shortcut works fine on my XP Machine (as well as 3 others). Where is the database located. I think this is a location issue. XP uses a folder called Documents and Settings that isnt on 98. If you have the database in your my documents folder then you need to make it look there...
C:\Documents and Settings\Your Username\My Documents\your.mdb
The mdb and mdw file are both on a network drive. The drive is properly mapped and the target line definately points to the correct paths. The shortcut finds the mdb file. The problem is that the /wrkgrp switch is being ignored.
JS...does your shortcut use the wrkgrp switch in the command line? If so I would be interested in seeing the target line from it.
I have a windows XP and uses the shortcut to access the secured database. The target line is
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "G:\..\..\abc.mdb" /wrkgrp "G:\..\..\abc.MDW"
Try joining your workgroup file, and try to access the database directly on the network drive, instead of accessing it through the shortcut, and see if it works. If it worked, then the access is fine, it is something with the shortcut. If not, then it is related to the access of the user who is logging into the database.