Moving Access application to another computer.

Q

Question Mark

I am developing an Access application at work. I'd like to also work on it
at home. I save (brurn) my current application to a CD and when I pull it up
at home, Access will not let me save it to my home PC or even edit the
application in RAM. The same thing happens when I try to email it as an
attachment. How can I easily work on my application at home and at work?
 
J

John Marshall, MVP

You should be able to drag the Access file (*.mdb) to your local drive and
run it.

Do you have access installed on your home PC? Is it a similar version of
Access as you use at work?

Can your PC at home write to CDs?

Thanks to the trade shows I have attended, I use a USB memory drive to
transfer some of my Access databases. It's easier than burning CDs.

John... Visio MVP
 
Q

Question Mark

--
Question Mark


:

You should be able to drag the Access file (*.mdb) to your local drive and
run it.

Do you have access installed on your home PC? Is it a similar version of
Access as you use at work?

- - - - I agree.

Can your PC at home write to CDs?

- - - - Yes.

Thanks to the trade shows I have attended, I use a USB memory drive to
transfer some of my Access databases. It's easier than burning CDs.

- - - - Great idea. I will try that instead.

- - - - Thanks
- - - - Mark
 
L

Larry Linson

Question Mark said:
I am developing an Access application at work. I'd like to also work on it
at home. I save (brurn) my current application to a CD and when I pull it
up
at home, Access will not let me save it to my home PC or even edit the
application in RAM. The same thing happens when I try to email it as an
attachment. How can I easily work on my application at home and at work?
Click to expand...

And "Pull it up" is technical for what? If you mean you are double-clicking
the MDB file on the CD, it will try to write a LDB (lock database) file,
which will fail, so...

When you burn a file to a CD, and copy that file to your hard drive, it will
still be marked "Read Only", but you should be able to right-click it,
uncheck the Read Only checkbox, and work with it as any other file.

I believe this is also the case even with a CD-RW, but it is not the case
with a flash memory drive.

Larry Linson
Microsoft Access MVP
 
J

John Marshall, MVP

So the confusion continues.

You have a copy of Access.
It is similar to your Office version.
You are not running the database from the CD

and you are still having a problem?

So can you drag the database to your hard drive?
What is the error you get when you run the database from your hard drive?

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
Visio Wishlist http://www.mvps.org/visio/wish_list.htm
 
Q

Question Mark

Thanks, Larry,

Pardon me. By "Pull it up" I meant "to open it from a CD-R". I makes no
difference whether I do it from inside Access or whether I just double-click
it. All the edit funtions are disabled - thus I am unable to save it to the
C drive. It will allow me to un-check the Read Only property, but nothing
changes. I get a warning that what I am trying to download is a potentially
harmful virus so I tried lowering my PC's security setting but to no avail.

Any further thoughts?

Mark

- - - - - - -

And "Pull it up" is technical for what? If you mean you are double-clicking
the MDB file on the CD, it will try to write a LDB (lock database) file,
which will fail, so...

When you burn a file to a CD, and copy that file to your hard drive, it will
still be marked "Read Only", but you should be able to right-click it,
uncheck the Read Only checkbox, and work with it as any other file.

I believe this is also the case even with a CD-RW, but it is not the case
with a flash memory drive.

Larry Linson
Microsoft Access MVP
 
D

Douglas J. Steele

Have you tried copying the MDB file from the CD-R to your hard drive, as was
suggested elsewhere?

Access wasn't designed to work from CD-Rs: it expects that the folder where
the MDB file exists to be updatable.
 
J

John Vinson

Thanks, Larry,

Pardon me. By "Pull it up" I meant "to open it from a CD-R". I makes no
difference whether I do it from inside Access or whether I just double-click
it. All the edit funtions are disabled - thus I am unable to save it to the
C drive. It will allow me to un-check the Read Only property, but nothing
changes. I get a warning that what I am trying to download is a potentially
harmful virus so I tried lowering my PC's security setting but to no avail.

Any further thoughts?
Click to expand...

Just use Windows Explorer or My Computer to copy the .mdb file from
the CD-R onto your hard disk; view its Properties and clear the Read
Only checkbox (again, in Explorer).

THEN use Access to open it. You won't be able to from the CD.

John W. Vinson[MVP]
 
Top