Read-Only

[Jeremy]

Does anybody know how to create an auto exec procdure that
will change a database from read-only status so that you
can write to it? I need to burn multiple copies of a
database to cds, but the copies keep reverting to Read-
Only status. I don't want users to have to Right Click >
Properties...etc.

Any help is appreciated. Thanks.

Jeremy

 

[Douglas J. Steele]

You can't change the attribute of the currently-opened MDB file, but you can
change it for other files using the SetAttr statement:

SetAttr pathtofile, vbNormal

You can also create a Batch file that uses the DOS Attr command:

ATTRIB -R pathtofile