How can I write a VB test to see if the database is Read-Only?

C

Chrisso

Hi All

I have a simple Access database that sometimes will be used by
external users off a DVD. In this case (of course) the database is
Read-Only.

How can I write a VB test to see if the database is Read-Only? and
therefore on a DVD?

If I can find a test then I can collect statistics when the database
is on our network and skip this when the database is on DVD.

I can do this in Excel with ThisWorkbook.ReadOnly but I cannot see
something similar in Access VB.

Thanks in advance for any ideas,

Chrisso
 
D

Douglas J. Steele

You can try writing, and trap the error that will occur since updates can't
be made.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read Only now different 1
How can I write a test to see if a database is Read-Only? 0
sqlite-odbc write conflict 2
I figured out the issue thank you. 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Is it possible to suppress the message "The database '<databasename>' is read-only"? 5
Creating a Search using a combo box and then creating a report. 4
Can I use the office activation code on a different machine if I uninstall? 1

Top