Secured Access DB on Web

[clapag22]

I have an Access DB that if I simply double-click on to open it gives me this message:

You don't have the necessary permissions to use the 'S:\EAP\EAPExpert\EAP.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

However, if I open MS Access through a special shortcut and then open the DB, it works fine. The target of the shortcut is:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
/wrkgrp "s:\eap\eapexpert\eap.mdw" /user USERNAME /pwd PASSWORD

My question is we need some of the data in this DB for a web app using Cold Fusion. I need to set up an ODBC DSN to the DB but obviously I can't set up directly to the DB because it won't access the DB. How should I set up the DSN? Or should I be asking this on a CF forum?

Thanks!
Craig

 

[Autoeng]

This database has had the Access Security Wizard run on it and is now secured. Your shortcut starts the database, joins the correct security workgroup file and then logs in with a generic password. You could:

Hyperlink to the shortcut

or

Strip off the security

Autoeng

 

[JeremyNYC]

If you make another shortcut and paste in the full path and name of the mdb file between ...exe" and "/wrkgrp... you will have a shortcut that opens the database directly.

If you use some sort of shell function in CF to call this line (anything that will send a string to a command prompt), this new string should fire up the database for you.

You get to decide if you want to have your username and password hard-coded into the CF application.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing and building Access databases since 1995.