Demo DB on CD (1 Viewer)

[Ray Stantz]

hello all,

I've designed a database and i want the capability to provide demos via CD but i want to maintain the security setup so that the veiwer would need to know the password to view the demo. Is there a way to dynamically point the DB to a security file that is located on the demo CD regardless of the drive letter? My concern is that there might be a small group of computers out there who's CD rom drive's letter is not "D".

Any help is appreciated.

Ray

 

[HiTechCoach]

Ray,

I rarely see a CD drive as D:

I would recommend that you look for all the available drives and test to see if one is your CD. See: http://www.mvps.org/access/api/api0003.htm

 

[DCrake]

What is contained in the security file that cannot be contained in the demo itself by means of DBProperties.

 

[Dennisk]

One thing to be aware of is that you will not be able to run the db directly off a CD as Access will try to create a locking file in the directory where the db is located (on a readonly CD). Also if a db is only opened then immediately closed Access will deem this db as updated so will try to update the date modified for the mdb file.

Unless of course Access has an option to place the locking file in a designated folder.