Problems with DataBase on CD

[Maria Joao]

I save a Access DB to a CDROM on an MDE version.
In some computers it runs from the CD, but in other
computers it runs only if the file is copied to the hard
disk.
Why does this happen?
How can I make it works always from the CDROM?

Thanks

Maria Joao

 

[TC]

What do you mean, it "does not run" on the other computers?

TC

 

[TC]

Maria, there are approximately 15 gazillion errors that can occur when you
open a database.

Say to yourself: "These people can not see what I am doing. They have no
idea what is happening for me, except what I tell them in my post".

You have to give us more information about what happens when you try to open
the database. This would inmclude the error NUMBER, and the error MESSAGE.

We do not have Extra Sensory Perception, or a magic video link to your PC!

TC

 

[cafe]

So, let me see if I have this right. You have a database on a CD. When you
double-click it directly on the CD, you get the message: "Microsoft Access
has encountered a problem & needs to close" etc.

Is that correct?

Are you definitely not doing anything else *after* you try to open the
database, *before* you get the error you mentioned?

TC
(off right now for 24 hours; sorry!)

 

[maria joao]

TC

I don't know what the problem is, otherwise I wound't be
asking how to solve this.

The message is the folowing:

"Microsoft Access has encooutered a problem and needs to
close. We are sorry for the inconvenience.
The information you are working on might be lost.
Microsoft Access can try to compact and repair your open
database and restart Microsoft Access.
.....
Please tell Microsoft about this problem....."

After I try to compact and repair:

" The repair operation has been canceled because
Microsoft Access could't create a backup file ..."

I think it can't create a backup file, because it is on
the CDROM.


So, this is my problem.

Can you help me now?

Thanks

Maria Joao

 

[Maria Joao]

Sometimes it happens when I open the Database.

On other times it happens when I open one form, but not
always the same form

Maria Joao

 

[Joan Wild]

Maria,

Why are you trying to run the database from a CD? Just copy it to the hard
drive and run it from there - note once you copy it to the HD, you may need
to check the properties of the file (right-click, properties) and ensure the
Read-only property is not checked.

 

[maria joao]

I would like it to work from the CD, because it has some
pdf files ins a folder that are linked to the database
with hyperlinks. The whole CD is 500 MB size, so I need
all this free space in the hard drive.

Maria joao

 

[Peter Russell]

I would like it to work from the CD, because it has some
pdf files ins a folder that are linked to the database
with hyperlinks. The whole CD is 500 MB size, so I need
all this free space in the hard drive.

Are you using DirectCD?
If not how do you imagine Access is going to write to your CD (which it
will need to unless you include other Access/system files on your cd as
well).

But it's not really a sensible way of running Access. Copy the file to
the hard disk and your problems are over.

Regards

Peter Russell

 

[TC]

Try opening it "exclusive, read-only" by creating a shortcut with the
following entry in the Target box:

"path to MSACCESS.EXE" /RO /EXCL "path to your mdb file"

Of course, replace "path to..." with the relevant paths on your PC
(including the quotes).

HTH,
TC

 

[Maria Joao]

I tryed to open it exclusive, read-inly, but the problem
is still the same.

But it would not be the solution, because this is a
database that I need to distribute to several machines.

Another solution that I would like better woul be to link
the files to the CD. How can I di this, since the CDRom
drive has a diferent letter in each computer machine?

Thanks

Maria Joao

 

[TC]

Yes, that's not a bad idea. Copy the database from the CD to the PC's hard
disk, but leave the PDF files on the CD. As for the CDs having different
letters, maybe you could prompt the user for his CD letter, then update the
hyperlink addresses via VBA code? (Don't ask me how; I don't use hyperlinks,
& I don't have Access here to look up the syntax. But it should ne in online
help.)

Alternatively there are ways that you can get the CD letter(s) from Windows,
then iterate through them, looking for the directory & files in question.
Then, you would not have to ask the user.

HTH,
TC

 

[Douglas J. Steele]

You can use the code in http://www.mvps.org/access/api/api0003.htm to
determine the user's CD drive, but remember that some users have more than
one CD, and you'd need to be able to handle those cases.