how do i put my database on another computer?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

seraph - 11 Jul 2005 23:25 GMT

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 :(

Reply to this Message

Jeff Boyce - 11 Jul 2005 23:56 GMT

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>

> OK... I have created my database, but now I am having trouble exporting it
> or
[quoted text clipped - 3 lines]
> do
> this? I am having trouble :(

Reply to this Message

Randy Harris - 12 Jul 2005 00:35 GMT

> 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 :(

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.

Reply to this Message

John Vinson - 12 Jul 2005 00:46 GMT

>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 :(

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]

Reply to this Message

seraph - 12 Jul 2005 01:38 GMT

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.

Reply to this Message

John Vinson - 12 Jul 2005 05:44 GMT

>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.
[quoted text clipped - 5 lines]
>inexperience ;) ) is the filepath? Even if I open it and "save as" in the
>new location I am still having issues lol.

<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]

Reply to this Message

seraph - 13 Jul 2005 20:22 GMT

*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 =(

Reply to this Message

Rick Brandt - 13 Jul 2005 20:37 GMT

> *sigh*
>
[quoted text clipped - 13 lines]
> person in 2 hours and 45 minutes which means I need to leave in 2
> hours and 15 minutes =(

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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

seraph - 13 Jul 2005 21:12 GMT

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.)

> > *sigh*
> >
[quoted text clipped - 19 lines]
> 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.

Reply to this Message

Rick Brandt - 13 Jul 2005 21:24 GMT

> I copied the zipped cd file to my computer and viewed the
> properties... the read-only check box is not checked. But, when I
[quoted text clipped - 4 lines]
> 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.)

Did you unzip it (extract it from the zip file) or did you try to run it
from inside the zip file?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

seraph - 13 Jul 2005 23:55 GMT

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.)

> > I copied the zipped cd file to my computer and viewed the
> > properties... the read-only check box is not checked. But, when I
[quoted text clipped - 7 lines]
> Did you unzip it (extract it from the zip file) or did you try to run it
> from inside the zip file?

Reply to this Message

seraph - 14 Jul 2005 00:28 GMT

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.

Reply to this Message