Database doesn't work from CD

[Fiora]

I designed a database which contains products, descriptions and prices. It seems like it works fine on the hard drive. I burned it onto a cd and when I click on the forms that search the database, they are blank. No data or buttons or anything.

Has anyone ever tried to run a database from a CD? Is this possible?

 

[mikey69]

One possible problem is that the CD version is read only. Not quite sure of the implication, but it might be relevant.

 

[suzy9680]

It is not possible to use an access application directly from a CD. This is because when you open an Access file, it creates a lock file (.ldb). If it cannot create this file, which is the case when using it from a CD, the database will be read only. You won't be able to enter any data or make changes to an application that you are running from a CD. The only option is to copy the Access file to your hard drive and run it from there.

 

[LetsGiveItAShot]

I feel your pain .. I was just there a short time ago. Here's what I can suggest from what I've learned.
1. Any of your queries should be based on a form that is not based on a table (i.e. if you're looking to search by product #, then create a from with a text field called "product" and base your query on the form forms!productsearch!product
2. Create an autorun.inf file that will open the database and the form that is set to run on open (in this example "ProductSearch&quot

Hope this helps .. let me know if you have any questions

John

 

[mikey69]

Suzy9680 is absolutely right. Can't think how I forgot that.