469,356 Members | 1,989 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

Cannot Open Table within Database

Working at non-profit and entering member names(table).
system software Vista. Microsoft Access 2007.

I am entering data directly into a table (form does not work) and saving the table with a new name (each data entry session I save table with new file name ex. "March A", "March B", etc.).

I can open the appropriate database but the most recent version of the table is either not there or can not be opened(no error message)
1. Opening file from zip drive(where database is stored) yields name of new table file but when I try to open it nothing happens.
2. If I open Access first, then open database - the most recent new table files does not appear

Appreciate some help
Mar 23 '12 #1
2 2664
759 512MB
Try to open the databases using Excel:
Right click the file, choose Open With... then browse for Excel application.
If you can do that I think you must reinstall Access.
Mar 24 '12 #2
32,185 Expert Mod 16PB
There seems little about the question that doesn't seem just wrong. If you cannot manage the data within a form then fix the form. Using a table directly is not a good approach and is so not an appropriate solution to that problem.

Tables are not designed to hold separate sets of the same type of data. They are for hold separate designs of data only.

I'm sure you're very new to this, but I suggest you've taken some wrong turns already and should consider rethinking everything from scratch. Database Normalisation and Table Structures is a very good starting point.
Mar 24 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ryan Liu | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.