linked files

[TODDY]

I have a data base that uses a linked file from excel.
When i run queries from this file everything works fine, but when i try to run a report from the qry's i get the mesage that the link specificarion does not exsist.
I have tried re-righting the db to no avail.
Help
regards

 

[SydneyGeek]

Does the data have to be linked? In general I find it better to import the data into Access. Two main advantages: Everything is much quicker, and you can set referential integrity (better control over data quality).
I'd only use a linked table if it is (1) constantly updated elsewhere or (2) too big to use directly in Access (not an issue with Excel files).

See what happens if you import the data.

Denis

 

[TODDY]

Yes i always do import but in this case the info comes from data colection unit and so is always changing.

 

[bat17]

you may be able to get around it by running an append query to a spare table and attatching the report to that.

Peter