>Hi ,
>
>I can't use a Access database when it is stored on a CDROM, it says it is Read-Only (which is normal), I only want to READ data, not WRITE records.
>
>Is their a prop to set, or a workaround to avoid this error message ?
>
>Thanx in advance.
>
>Sincerely,
>
>QUICK Peter
>Software Dev CompuGuide
>info@compuguide.be
>
www.compuguide.beA database can be opened read-only, only i'm not sure if on the CD u got to have the .ldb file before.
Look in help under OpenDatabase Method (DAO Reference).
Cut from the help:
Set database = workspace.OpenDatabase (dbname, options, read-only, connect)
read-only Optional. A Variant (Boolean subtype) value that is True if you want to open the database with read-only access, or False (default) if you want to open the database with read/write access.
Recommended is also that u open the db exclusively.
Hope this helps!