Read Only database

[Mikey]

I've got a database that is being recorded on to a CD. The Cd automatically comes out as a read only version of the Database. Don't have a problem with this as such. However this disables a query in the database.

Basically I have a form with a combo box. The combo looks at a table for a list of counties. The user selects a county and presses a button to activate a report. The report is based upon a query which is looking at the value in the combo box.

This works no problems until the database is read only. When the database is read only, the form the combo box is on displays only the header and not the detail section of the form. Thus users can't access the combo box and enter the criteria and run the report.

Help.

Mike

 

[samehkh]

Why do you need to run the database from the CD?
I mean why cant you copy it to any Hard Disk and remove the read only flag?

 

[Mikey]

The Cd is being sent out to novice PC users. It's doubtful they could change the properties once its on there hard drive. Already suggested that.

Life aint that simple

 

[ghudson]

You should not run a db from a CD because the db must create the record locking file *.ldb and that can not happen on a CD. No data/design changes can be made to a db when run from a CD.

You should create a self extracting zip file [*.exe] to install the db to their hard drive. That will avoid the read only attribute problem. Tim K. has posted a solution on how to automate the removal of the read only attribute. Search the forumn if that might help you.

HTH

 

[Mikey]

Could I be a pain and ask for that thread. Can't seem to find it.

hanks for the help.

Mike

 

[Autoeng]

All you had to do was enter Tim K. under username in the search utility. Was on the second page.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43512

 

[Mikey]

Thanks and apologies, asked the search to do an exact match. Me being dumb found it.

Also sorted the issue out. The form I'd placed the combo box on had the underlying query as its control source. This wasn't necessaary and allows the query to function properly while in read only form.

Thanks

Mike.