Windows Explorer won't recognize MDB

[Guest]

I am just rolling out my first Access 2000 app on an all-Windows 2000 network. I would like to place a shortcut on the user's desktop so it loads Access and runs the app for them. Such a shortcut works for me as administrator, but it won't work for the user. Windows Explorer shows the MDB file as an Access App but it doesn't recognize it as such if the user double-clicks on it. Instead it runs Windows Installer, then ends up saying "This file does not have a program associated with it"

Does anyone have a clue as to what's going on here? Does it have something to do with ownership of the MDB file? (I created the MDB as administrator and the administrator is the only one listed as owner.

ctdak

 

[Arvin Meyer]

The user may need local admin priviledges on the machine (not the database)
in order to install or recognize the associated program.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I am just rolling out my first Access 2000 app on an all-Windows 2000

network. I would like to place a shortcut on the user's desktop so it loads
Access and runs the app for them. Such a shortcut works for me as
administrator, but it won't work for the user. Windows Explorer shows the
MDB file as an Access App but it doesn't recognize it as such if the user
double-clicks on it. Instead it runs Windows Installer, then ends up saying
"This file does not have a program associated with it".

Does anyone have a clue as to what's going on here? Does it have

something to do with ownership of the MDB file? (I created the MDB as
administrator and the administrator is the only one listed as owner.)

 

[Guest]

I discovered the answer to my own question here. No local user admin privileges are necessary, which is good because that compromises network security. The shortcut just has to be created with a target that runs msaccess.exe first then specifies the full path to the mdb file (in quotes afterwards). This works. It loads access first and then runs the database app (just as if the user did it manually), without any user security considerations

ctda

----- Arvin Meyer wrote: ----

The user may need local admin priviledges on the machine (not the database
in order to install or recognize the associated program
--
Arvin Meyer, MCP, MV
Microsoft Acces
Free Access downloads
http://www.datastrat.co
http://www.mvps.org/acces

I am just rolling out my first Access 2000 app on an all-Windows 200

network. I would like to place a shortcut on the user's desktop so it load
Access and runs the app for them. Such a shortcut works for me a
administrator, but it won't work for the user. Windows Explorer shows th
MDB file as an Access App but it doesn't recognize it as such if the use
double-clicks on it. Instead it runs Windows Installer, then ends up sayin
"This file does not have a program associated with it"something to do with ownership of the MDB file? (I created the MDB a
administrator and the administrator is the only one listed as owner.