Try compacting the database (Tools ... Database Utilities ... Compact and
Repair) Since this is likely to happen often, it is a better idea to copy
the file to your hard drive to work on it, then zip it and copy it back to
the diskette to transport it. You might also consider using a USB flash
drive.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
Try compacting the database (Tools ... Database Utilities ... Compact and
Repair) Since this is likely to happen often, it is a better idea to copy
the file to your hard drive to work on it, then zip it and copy it back to
the diskette to transport it. You might also consider using a USB flash
drive.
I know that with other Office products such as Word and Excel you should
never work off a diskette. I remember reading the technical details of why,
but they've slipped my mind. I would think the same would apply even more so
to Access, so I'd word Arvin's advice a little strong: DON'T DO THAT! Always
copy your file to your hard drive to work with it.
I remember something about "persistent links". I used to have a Word
document (on hard-disk) but whenever I opened it the PC started searching
for the floppy drive. When we looked at the biaries of the file, we found
that there was a reference to some Word doc on the A: drive.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.