• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

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

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.
  • 2
1 Solution
ste5anSenior DeveloperCommented:
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".
Rey Obrero (Capricorn1)Commented:
are you joining tables in your query?

check the values of the fields used in the join..
softsupportAuthor Commented:
Thank you, I was able to resolve the issue myself.
softsupportAuthor Commented:
I was able to resolve issue myself... the criteria was not allowing for the query to work.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now