[mso] Re: Access 2000: Data not saved, please help
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 5 May 2005 13:37:15 +0200
Dunno about curing it Robert... was just thinking about saving the
typed in data. By importing to another format... I'm assuming that you
mean Excel or something. If you do that then maybe there's something
in the data that shows up as being bogus that's causing the problem.
I've never seen this problem before. My experience is that if I just
close the access database then the data is saved in the table.
After Exporting... I'd start deleting records one by one.. 50 isn't
going to take too long.. and see if I hit a spot where the table is
saved well.
Open the db, import your data, delete rec 1, Close and see what
happens. Then rec 2 etc.
Next I'd start deleting records from the end... Open the db, import,
delete last rec, close etc.. Open the db, import, delete last 2 recs,
etc. DO keep a record of what happens though. Don't trust your memory!
I'm sure you will get to a point where you are able to open to a good
saved db.
Another thing... if you create another table with a couple of fields
in the db and stick a few records in it.. just small dummy ones.. does
that table come up empty as well?
Lisa
> Yes. I mean when I close the application, reboot, it starts
> over with an
> empty table.
>
> Question: If I export, and then import to another type,
> have I corrected
> this malady? Or should save in another format, delete this database
> (empty!), and make the database again? I have the field
> names in an Excel
> file, which was my original "import." Frustrating when
> books don't address
> issues like this!
>
> Thank you.
>
> Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
