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

[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

 

[Douglas J. Steele]

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

 

[Chrisso]

OK thanks Doug.

I have implemented this and it works fine.

Cheers
Chrisso