problem with table and adding new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I created a basic access database a couple of years ago. I recently noticed
that as I have been adding new records into the table ( I am not using a
form), when I run a query or report on that table the new records are not
there.
Did I miss something? What is going on?

Thanks
Jane
 
open your query in edit mode and on the view select "SQL" and paste
here what's inside would be easier to see what is missing or extra
that shoudn't be there.
 
Hi, Jane.
( I am not using a
form)
Click to expand...

You really should create a query based upon the table, and then use the
query as the form's record source. You'll have much more control and
flexibility in the data entry.
when I run a query or report on that table the new records are not
there.
Click to expand...

This could be due to a simple flaw in the query, where the WHERE clause
limits the rows displayed. For example, only the records entered before the
end of 2006 would show in the following query, even though you've been
entering new records all year:

SELECT CustomerID, InvoiceAmt
FROM Invoices
WHERE InvoiceDate < #1/1/2007#;

It could also be due to a database design flaw, where you're entering orphan
records because referential integrity isn't being enforced between a parent
table and child table.
Did I miss something? What is going on?
Click to expand...

It's too hard to tell without seeing your database. Are the tables
normalized? Is referential integrity enforced between the related tables?
Did you write buggy queries?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Thank you....but you guys are way above me! Actually...when I opened the
database again today it seems to be working.

The story is....I got a new pc at work. I had to copy all my documents from
one drive to another. When I went to open the database it tells me "this
database may not be safe if it contains code that was intended to harm your
computer....."

I never saw this before.

I did not know that should or could enter the new data in the query. I just
assumed I had to enter it in the parent table.

The database is a membership list and in the list there is a field that says
what kind of member. The table does not sort the data by the membership
type...but now that I know I should enter the data in the query I guess I can
just sort by the membership type field.
 
Hi, Jane.
When I went to open the database it tells me "this
database may not be safe if it contains code that was intended to harm
your
computer....."

I never saw this before.
Click to expand...

It means that you're using either Access 2003 or 2007 and the Macro Security
Level is not set on Low.
I did not know that should or could enter the new data in the query.
Click to expand...

Actually, you should be entering the data in a form that uses the query as
its record source to allow full control and plenty of flexibility when
needed.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top