By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

Cannot Open Table within Database

P: 1
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
thanks
cdavis
Mar 23 '12 #1
Share this Question
Share on Google+
2 Replies


100+
P: 759
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

NeoPa
Expert Mod 15k+
P: 31,494
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.