Solved

Queries not showing data after deleting all data in table and insert new records in a split Access database

Posted on 2014-10-27
4
148 Views
Last Modified: 2014-11-01
I have a front-end and back-end split database.   I want to delete all the old data out of the tables and import corrected data in.  Is there a process to accomplish this?  With old data.... all queries work properly. When I delete all old data out and import new data in, queries do not show any data, even though data is in tables.  I have re-linked tables to refresh data and used compact and repair but queries still will not work.
0
Comment
Question by:softsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 34

Expert Comment

by:ste5an
ID: 40406273
Well. sounds like your new data is either not complete or you deleted also data from lookup tables which are not imported.

This problem depends completly on your data. Thus you need to take the database with the new imported data and review all your queries for INNER JOINS. This is the point where data is normally "hidden".
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40406275
are you joining tables in your query?

check the values of the fields used in the join..
0
 

Accepted Solution

by:
softsupport earned 0 total points
ID: 40407680
Thank you, I was able to resolve the issue myself.
0
 

Author Closing Comment

by:softsupport
ID: 40416998
I was able to resolve issue myself... the criteria was not allowing for the query to work.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question