ACCESS - Table data disappearing after saving

[Guest]

Does anyone know why this is happening. It's driving me crazy. I input and
save. When reopening, the table is absolutely empty.

 

[Jeff Boyce]

Eve

Can you use an Append query to successfully add records?

Are you working directly in the table, or (recommended) from a Form? If
from a Form, is the form bound to the underlying table?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff, thank you.

I'm just starting off - this just happened today. The records were there
before. I'm working directly in the table as I always do.

I haven't designed a form. I have several teams providing me with excel
spreadsheets full of information that I need to insert into a master
database. The spreadsheets were templated from the Access Database field
names.

I thought I could "get external data" from Excel but it's not working and I
don't have an export data option in the excel sheet to go to Access. I've
tried copying and pasting - some work some don't.

I'm at the point of inputting directly myself. However, when I save the
table the data has disappeared when I reopen it.

 

[Jeff Boyce]

Right off the top, I don't have an idea why you wouldn't be able to enter
data directly in the table.

You should be able, however, to use File | Get External Data | Import...
from within the Access database window to import your Excel data.


Regards



Jeff Boyce

Microsoft Office/Access MVP

 

[Guest]

Thanks for trying Jeff. I guess my big problem right now is figuring out why
the date doesn't save when I close the file.

 

[Rick Brandt]

Thanks for trying Jeff. I guess my big problem right now is figuring
out why the date doesn't save when I close the file.

If you enter data and simply move to a different row the data is already saved
(to disk). If you are not seeing it disappear immediately upon changing rows
then you don't have a problem with data not being saved. You have a problem
with data being deleted after it is saved.

Are you sure your table doesn't have a saved filter applied that is hiding some
rows from you?

 

[David W. Fenton]

Are you sure your table doesn't have a saved filter applied that
is hiding some rows from you?

Or is set for Data Entry, so that when you close it and then open it
again, you won't see the existing records?