Access on CD Read Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sanj - 28 Jun 2005 16:10 GMT

I have an access database that was burned to a CD. I would like to copy it
over to my system or upsize/import to SQL.

The error I keep getting is "Cannot start your application. The workgroup
information file is missing or opened exclusively by another user"

I have admin rights to the database. Is there anyway to copy the database
or suck it into SQL or another Access database

Reply to this Message

Don - 28 Jun 2005 18:16 GMT

Have you tried copying the DB from the CD to a hard drive and removing the
read-only attribute? Whenever I burn a DB to CD and copy it back I usually
forget to unset the RO attribute.

HTH.

Don

> I have an access database that was burned to a CD. I would like to copy it
> over to my system or upsize/import to SQL.
[quoted text clipped - 4 lines]
> I have admin rights to the database. Is there anyway to copy the database
> or suck it into SQL or another Access database

Reply to this Message

Sanj - 28 Jun 2005 18:33 GMT

I am not able to copy it across. I think that the database was locked when
it was copied to the CD, because I keep getting locked by user warning.

I ended up pulling it into SQL Server using the Import Wizard. Curiously I
had to use the driver do Microsoft Access. I thought that I could set the
source as the database itself, but that would not work.

> Have you tried copying the DB from the CD to a hard drive and removing the
> read-only attribute? Whenever I burn a DB to CD and copy it back I usually
[quoted text clipped - 13 lines]
> > I have admin rights to the database. Is there anyway to copy the database
> > or suck it into SQL or another Access database

Reply to this Message

Pete - 28 Jun 2005 23:01 GMT

Sounds like you may have burned the DB to CD while it was in use. Is that
possible? If it was on the network, it's possible someone else had it open.

> I am not able to copy it across. I think that the database was locked when
> it was copied to the CD, because I keep getting locked by user warning.
[quoted text clipped - 20 lines]
> > > I have admin rights to the database. Is there anyway to copy the database
> > > or suck it into SQL or another Access database

Reply to this Message