how do i put my database on another computer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK... I have created my database, but now I am having trouble exporting it or
saving to another location. I need to put my database on a cd and then onto
the computer that is going to be using the database I created--- how do I do
this? I am having trouble :(
 
It isn't clear what kind of trouble you are having.

Are you saying you are not able to use Windows Explorer (or My Computer) to
copy from your computer and write to a CD?

Jeff Boyce
<Access MVP>
 
seraph said:
OK... I have created my database, but now I am having trouble exporting it or
saving to another location. I need to put my database on a cd and then onto
the computer that is going to be using the database I created--- how do I do
this? I am having trouble :(
Click to expand...

I personally like to zip files that I put on CD. Window has this peculiar
propensity for making everything that comes off a CD read only. You won't
have to deal with it if you unzip from the CD.
 
OK... I have created my database, but now I am having trouble exporting it or
saving to another location. I need to put my database on a cd and then onto
the computer that is going to be using the database I created--- how do I do
this? I am having trouble :(
Click to expand...

You do need to copy it from the CD onto the recipient's hard disk
(CD's are not rewriteable, as far as Access is concerned, so you
cannot run a database directly from a CD except by opening it
read-only).

When you do copy it, Windows will mark the file read-only. Right
mouseclick it in Windows Explorer/My Computer, and view its
Properties; uncheck the "Read Only" checkbox.

Of course (well, maybe not totally obvious) the recipient must have a
compatible version of Access installed in order to run the database; a
..mdb file is not an executable program.

John W. Vinson[MVP]
 
Thank you--- the first problem I had when burning it on a CD was that the
file was read-only so John's post helped with that.

The problem I am having now is that I created a folder that just has the
access file and a word file that is going onto the CD--- I moved the access
file into this folder--- but now the filepath can't be found- so I moved it
back.... and it still can't be found. So I guess my problem (besides
inexperience ;) ) is the filepath? Even if I open it and "save as" in the
new location I am still having issues lol.
 
Thank you--- the first problem I had when burning it on a CD was that the
file was read-only so John's post helped with that.

The problem I am having now is that I created a folder that just has the
access file and a word file that is going onto the CD--- I moved the access
file into this folder--- but now the filepath can't be found- so I moved it
back.... and it still can't be found. So I guess my problem (besides
inexperience ;) ) is the filepath? Even if I open it and "save as" in the
new location I am still having issues lol.
Click to expand...

<shrug>

You can see your error messages. You know where on the disk you put
your files.

I don't.

I have no idea what "filepath" it's looking for, nor of course what
the correct filepath might be; nor what the Word doc has to do with
the Access database.

If you'll give us a little help here we might be able to advise; given
the message you posted above, there's clearly SOME file that's not at
the right place, and there are SOME issues that you haven't described.
But there's nothing there which would let anyone not looking over your
shoulder give any useful advice.

John W. Vinson[MVP]
 
*sigh*

I opened explorer and right-clicked the access file- it was not marked as
read-only. I burned it to the cd, opened it, and it was read-only.

I zipped the file, burned it to the cd, opened it, and it was read-only.

I am really frustrated =(

Should I or can I just open a new table on the other computer and import all
the data in?

I don't know what to do =( I am supposed to bring this cd to the person in 2
hours and 45 minutes which means I need to leave in 2 hours and 15 minutes =(
 
seraph said:
*sigh*

I opened explorer and right-clicked the access file- it was not
marked as read-only. I burned it to the cd, opened it, and it was
read-only.

I zipped the file, burned it to the cd, opened it, and it was
read-only.

I am really frustrated =(

Should I or can I just open a new table on the other computer and
import all the data in?

I don't know what to do =( I am supposed to bring this cd to the
person in 2 hours and 45 minutes which means I need to leave in 2
hours and 15 minutes =(
Click to expand...

All files burned to a CD are marked as read only. You need to change the
property back after copying the file back to a writable disk. However; in
my experience the files inside a ZIP archive are not marked as read only.
The ZIP file itself is, but when you unzip from the CD to a writable disk
the resulting files should not have the read only flag set.
 
I copied the zipped cd file to my computer and viewed the properties... the
read-only check box is not checked. But, when I open the file in Access, it
says that it is read-only. I tried importing the data into a blank table and
I clicked to link the tables... nothing happened.

I have to leave in 20 minutes, so I guess I am outta luck. (At least I have
the report printed which is what they really need.)
 
seraph said:
I copied the zipped cd file to my computer and viewed the
properties... the read-only check box is not checked. But, when I
open the file in Access, it says that it is read-only. I tried
importing the data into a blank table and I clicked to link the
tables... nothing happened.

I have to leave in 20 minutes, so I guess I am outta luck. (At least
I have the report printed which is what they really need.)
Click to expand...

Did you unzip it (extract it from the zip file) or did you try to run it
from inside the zip file?
 
From My Documents, I right-clicked my Access file. I selected "Send To..."
then I selected "Compressed Zip Folder." I then double-clicked the zip folder
and it opened and I double-clicked my access file... it opened in Access with
the message that it was a read-only file and no changes could be made (this
file was in My Documents and not on a cd-r.)
 
YAY finally... I went to the store and got some cd-rw's. I burned it, put it
on the desktop, and it opened properly... I have no idea why on the other
file if the properties say it is NOT read-only why Access would say it
is...whether on the cd or desktop.

Thanks for all your help, everyone... it is so frustrating to know what you
need done and not know how to do it... so thank you for helping me. I spent
hours upon hours building a database of hundreds of recipes for an adult home
for the aged deaf... the administrator was very appreciative for the help I
gave them, so in spite of all the frustration, I am glad to have been able to
do it- so thanks to all who have answered all my questions and making it
possible for me to help them. Now I need to learn how to do a query, lol.
 
Back
Top