If you wrote a 1400 kb Access mdb file to a 1.44mb floppy, you probably filled the disk. Floppy disks are notoriously prone to error - most computer manufacturers don't even offer them anymore. If you need a portable copy, get an inexpensive "disk on key" USB device.
Your file is probably toast. Even if you can read some other files from the same floppy, your large Access mdb file probably has an error in it somewhere. You could try running ChkDsk on the problem floppy to see if it can be fixed, but the result will probably be a corrupted Access file. I'm not sure I understand your Part 2. There is no Save or Save As command within Access to make a copy of an entire database file. You can only Export objects to a new file or Save As a copy of an existing object (table, query, form, etc.) within the current database. How did you actually make the copy? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of wall_street24 Sent: Wednesday, August 10, 2005 11:07 AM To: [email protected] Subject: [ms_access] Access file RECOVERY I'm new to Microsoft Access, but decided to open a database and save it to a floppy disk. I then saved an updated version of the database to a second disk. When I attempted to open the file on the first disk, I got a message saying that there was something wrong with the disk-drive. (The error message was erroneous, as I was able to open and remove an Excel and a Word file from the A-drive disk, but the ACCESS file won't budge.) I tried to move the file from the disk to the hard drive, but the damn system won't allow me to do anything with this file now. How can I retrieve the valuable data from the Access file (and what caused this in the first place)? Any help would be appreciated. Part 2: It was a simple SAVE with the SAME file NAME. I realized it wasn't the best manuever, but assumed that since NO INFORMATION was being written to the actual hard drive, that the information on either disk would be used when accessed. Apparently some sort of file was written to in the Access program (don't know if I can alter it somehow). There must have ALSO been something written to 'disk one,' because I simply CANNOT move, copy, or open the file from the disk. I get a message that reads: "Disk or network errror." But nothing is wrong with the disk ITSELF, because other files from different programs were easily accessed and removed from the physical floppy disk. And I was able to "defragment" the actual Access file in question (which is showing to be 1400kb in size on a normal 1.44Mb floppy). Any other insight towards a solution, or a deeper definition as to WHY this happened? (I've used IDENTICAL file NAMES items from other Microsoft programs (ie.: Word, Excel, etc.) with seperate floppies, and never had a problem. The program just searches for the file name on the A drive, and doesn't REALLY 'know' it's not the same data it had opened moments earlier.) PLEASE HELP ME. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hrpghme/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123698398/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
