I have an application with which the users generate reports from a CD containing an Access database. Is there a way (method) to detect whether an Access database is installed on a read-only device. That way I can disable certain operations (such as updating the data) which are inappropriate on a read-only device.

Rand

__________________
Rand

Data ca not be updated to a read only device, specially a cd.
Now the question.
Is that database on the cd pointing to a live database by some sort of link?




Sal

If the database is run from the CD (read-only) I want to disable (or hide) the buttons that update the data. On the other hand, if the database is moved onto a readable device (such as a hard disk or CD-RW) I would like the update buttons enabled.

Rand

Have you tried to update data on a CD?
It will not work. Try it.



Sal

I know it won't work. I want to make certain that the users can't even try (proactive error avoidance).

Rand

A bit too proactive. If they can't break it, why bother?
If the CD database does not point to a database, DSN or by code to an actual database, or if the database on the cd only points to its own data, leave it as is.

In fact, even if you copy the database to a C:/ drive with full rights, the dataabse will still be marked as read-only.



Sal

The code here http://www.mvps.org/access/api/api0003.htm can used to check if a particular drive is a cd-rom.



Brian Skelton
Braxis Computer Services Ltd.