J
jaygwop
How do I save data from Access to be used on another computer, do I need to
put it on a cd or can I use a disk.
put it on a cd or can I use a disk.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Depends how much data there is.
W
Wayne Morgan
If all you are wanting to do is copy the file, any media that is large
enough to hold the file will work.
enough to hold the file will work.
J
jaygwop
It says export to html and something else im not sure what I would choose
and there is a good amount of data.
and there is a good amount of data.
T
Todd Shillam
If you just want to copy of whole Microsoft Access file itself, just copy the file (it ends with a '.mdb' file extension).
You can do this simply by using Windows Explorer (just press {Windows} + {E} keys). NOTE: The {Windows} key (if present) can be found two keys to the left of the spacebar--pressing both the keys together simulaneous will open Windows Explorer, the application you can use to browse for files on your computer.
You need to only locate your database file. When you find it, just copy the file and save it to a floppy or 'burn' the file onto a CD like you would with any other file(s).
However, a more important question is...why are you trying to copy the file? Do you want to share the database with another user on a LAN (Local Area Network), such as a computer network at work? If so, there is a much better approach to this situation.
Best regards,
Todd
It says export to html and something else im not sure what I would choose
and there is a good amount of data.
You can do this simply by using Windows Explorer (just press {Windows} + {E} keys). NOTE: The {Windows} key (if present) can be found two keys to the left of the spacebar--pressing both the keys together simulaneous will open Windows Explorer, the application you can use to browse for files on your computer.
You need to only locate your database file. When you find it, just copy the file and save it to a floppy or 'burn' the file onto a CD like you would with any other file(s).
However, a more important question is...why are you trying to copy the file? Do you want to share the database with another user on a LAN (Local Area Network), such as a computer network at work? If so, there is a much better approach to this situation.
Best regards,
Todd
It says export to html and something else im not sure what I would choose
and there is a good amount of data.
J
jaygwop
Sorry, I am going to use the info on another computer. The access files are
now at my home computer and I need to bring them to my friend.
now at my home computer and I need to bring them to my friend.
W
Wayne Morgan
Access doesn't have the "Save As" option as Word does. Just use Windows
Explorer to copy the file.
Explorer to copy the file.
J
jaygwop
Do I copy the .mdb file as someone said above or is it something else and is
it found in the file folder for access
it found in the file folder for access
T
Todd Shillam
Try copying the file by using Windows Explorer, like the person stated in
the thread just above. After you copy the file, you will want to test the
copy--just to make sure your copy works like you intend it to..
Best regards,
Todd
the thread just above. After you copy the file, you will want to test the
copy--just to make sure your copy works like you intend it to..
Best regards,
Todd
M
Mindi
I am having trouble saving db to a disk...it tells me not enough space on
disk, then I lose it all before it is over. I can't get back to compact it.
My students are working on a lesson out of a book, not a large database, and
some are having this problem and some aren't. Suggestions, PLEASE!?!? I
have no experience with Access at all...they know I am struggling with it!
disk, then I lose it all before it is over. I can't get back to compact it.
My students are working on a lesson out of a book, not a large database, and
some are having this problem and some aren't. Suggestions, PLEASE!?!? I
have no experience with Access at all...they know I am struggling with it!
T
Todd Shillam
If the database file is too large for a 3.5 floppy, you may be able to
'burn' the file onto a CD-R disk; provided you have a CD writer (and
provided your file is not larger than 700MB). Otherwise, you could upload to
an FTP server (provided you have account with a FTP service), or share your
file over the internet using a file-sharing application.
Another option might be to compress the file using a compression utility
program, such as WinZip (you can use a trial version). After compressing the
file, it may fit on a floppy; however, receipients would also need a
compression utility program to unzip the file.
Best regards,
Todd Shillam
'burn' the file onto a CD-R disk; provided you have a CD writer (and
provided your file is not larger than 700MB). Otherwise, you could upload to
an FTP server (provided you have account with a FTP service), or share your
file over the internet using a file-sharing application.
Another option might be to compress the file using a compression utility
program, such as WinZip (you can use a trial version). After compressing the
file, it may fit on a floppy; however, receipients would also need a
compression utility program to unzip the file.
Best regards,
Todd Shillam
W
Wayne Morgan
Yes, the mdb file is the one you want unless you've deliberately done
something to it, such as create and mde or adp file. By default, it is
probably in your My Documents folder.
something to it, such as create and mde or adp file. By default, it is
probably in your My Documents folder.
W
Wayne Morgan
How are you trying to save the mdb to disk? Are you telling Access to create
a new file or are you using Windows Explorer to copy a file? Is it a file
that already exists and you're trying to save changes to the structure of
the file? Are you just trying to add new records?
a new file or are you using Windows Explorer to copy a file? Is it a file
that already exists and you're trying to save changes to the structure of
the file? Are you just trying to add new records?
M
Mindi
They are newly created db. After they open Access and tell it to create a
blank database, they are saving it to A: Then, once they get going creating
the tables, when they exit the tables, it will tell them not enough space on
disk.
blank database, they are saving it to A: Then, once they get going creating
the tables, when they exit the tables, it will tell them not enough space on
disk.
W
Wayne Morgan
There is a good chance that if the A: drive is just a 1.44 MB floppy, that
there isn't enough room on the disk. Create the file on the hard drive.
Check the size before you try copying it to the disk. If it is too big, do a
Compact and Repair on the file to shrink it as much as possible before
copying it to the floppy. If that isn't sufficient, try zipping the file.
Database files usually compress a lot when you zip them. If it still won't
fit, then it won't fit. You'll have to use something other than a floppy or
span the file across floppies.
there isn't enough room on the disk. Create the file on the hard drive.
Check the size before you try copying it to the disk. If it is too big, do a
Compact and Repair on the file to shrink it as much as possible before
copying it to the floppy. If that isn't sufficient, try zipping the file.
Database files usually compress a lot when you zip them. If it still won't
fit, then it won't fit. You'll have to use something other than a floppy or
span the file across floppies.
B
Brendan Reynolds
On my system, a new MDB in which I have not yet created any tables or other
objects is 96 KB. That's one fifteenth of the capacity of a diskette
already. If I add a very simple table with an AutoNumber primary key field
and a text field, and enter just three records, that rises to 140 KB - I've
used up more than one tenth of the capacity of a diskette, in about three
minutes. And that's not counting the space Access needs for the locking file
that it creates in the same folder as the MDB while you have the MDB open.
In short, a diskette is just not a suitable medium on which to store an MDB
while it is in use.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
objects is 96 KB. That's one fifteenth of the capacity of a diskette
already. If I add a very simple table with an AutoNumber primary key field
and a text field, and enter just three records, that rises to 140 KB - I've
used up more than one tenth of the capacity of a diskette, in about three
minutes. And that's not counting the space Access needs for the locking file
that it creates in the same folder as the MDB while you have the MDB open.
In short, a diskette is just not a suitable medium on which to store an MDB
while it is in use.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
D
Douglas J. Steele
Never work on a database from a floppy. Create the database on the
harddrive, and copy it to the floppy at the end of the day.
There are far too many ways in which a database can be corrupted in this
way. BTW, this is true for all Office documents: you should never edit any
Office documents on floppy drives.
harddrive, and copy it to the floppy at the end of the day.
There are far too many ways in which a database can be corrupted in this
way. BTW, this is true for all Office documents: you should never edit any
Office documents on floppy drives.