473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Cannot Open Table within Database

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
2 2995
Mihail
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
NeoPa
32,556 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

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

Similar topics

10
by: vvenk | last post by:
Hello: When I tried to use an Access database, I get the following exception: Server Error in '/WebGrid' Application....
4
by: MLH | last post by:
If both a form and a table are open in an A97 database, are there VBA commands that will refresh records shown in the open table so that records appended since the table was first opened will...
0
by: micky | last post by:
=========================================================== Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\SYSTEM'....
9
by: Matt | last post by:
How would I do this ... I want to set the Windows Scheduler to run the ..bat file which will open an access database at like 2 in the AM. What code do I need in the .bat file.
1
by: bb nicole | last post by:
Below is my interface for resume which need to post into database... I have did it all in one page and it already can send into database which the table name resume... But my letturer now want me...
2
by: Ryan Liu | last post by:
Hi, I have few db write and read to execute, so I use transaction. Is that a problem or is that a regular way that I only use transaction on some cmds only, and other cmds I do not use...
3
by: ConfusedMay | last post by:
Hi, I've created an access 2003 database that has a form with button called "open complaint database." This complaint database is also in access 2003. Here is my code to open the complaint...
0
by: dreamer247 | last post by:
hii all i am working with mssql 2000 and after restoring a databas from device the warning is .. Warning: mssql_connect() : message: Cannot open user default database. Using master database...
0
by: steve | last post by:
I have an InfoPath form that needs to update an Access database. I'm using VB, in Visual Studio. So far i can't even open it: the database is on my hard drive, and no password is set. The...
12
by: godiva | last post by:
Hi, Last week one client had errors caused by another program which led the IT guys to wipe out and rebuild the hard drive on one particular computer. Prior to this happening, the people in this...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.