Stupid Link Question

[dls61721]

I linked an Access 2007 table to an excel spreadsheet and ran into a problem.
I built a form with information from both the Access form and Excel
spreasheet. However, although the Access table has over 700 records, since
linking the two the Access form now only shows 400 records, while the table
still shows 700. Where have I gone wrong?

 

[Jeff Boyce]

We aren't there. We can't see what you're looking at.

When you "link" in Access, you don't actually have a copy in your Access
file... the link is more of a view of the data that lives elsewhere. So you
don't have two tables (one in Access, one in Excel) -- just one in Excel
that you can see from Access.

If this isn't what you've done, please describe your situation in more
detail...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[dls61721]

I do know that I have only one table and that is an access table. It is
linked to a spreadsheet. I have not run a query. It is a simple form that
shows data from the access table (name and date of hire) and a spreadsheet
(phone number). However, although there are 700 employees in the access
table, when viewing from the form there are only 400 employee records. I'm
guessing that the spreadsheet only has 400 employees with phone numbers,
hence the return of 400 records in the form. How can I see all 700 employees
using the access form, regardless of whether there is a phone number or not?