Table loading?

  • Thread starter Thread starter shaunismms
  • Start date Start date
S

shaunismms

Hi there,

Fairly novice at Access - was a Notes developer in a former life.

Is there any way to see how a table is getting its data loaded into
it? My query's failing because a table does not have any data from
August in it, but I can't tell how it's picked up data from prior
months.

(I just took over this position - the person who developed the DB left
seven weeks ago.)

Cheers,
Shaun
 
Data can be entered into a table many ways. You can type it in directly at
table level, at query level, or through a form. You can also import data from
other programs. Then there's append queries which put data from other tables
into a table. These append queries are often based on linked files like text
or spreadsheets.

If you are talking just a few records, possibly the data was typed in
manually from paperwork or cut and pasted from email or other documents.

If you are talking thousands of records, I'd think that the data would be
imported from another program. It's also possible to link to an external
file, such as an Excel spreadsheet, then append this data to the table.

Were I you, I'd be bothering coworkers and bosses to see if they had a clue.

Next I'd be looking for attached tables. In the database window under
Tables, they will have a little blue arrow pointing at the table name.

While at the database window also check for Append queries. An append query
will have a +! icon next to the query name.

I'd also be looking for files on the hard drive or out on the network named
something like "JulyDate.txt" or something that might be files that were
imported.

On the off chance that the previous worker automated things, I'd look at all
macros and modules to see if there is anything like TransferText or something
which would help figure out how data is imported. WARNING: Do not
double-click or Open macros. This runs them. Instead open the macro in design
view.
 
Back
Top