I have a database (Access 2000) that I access through pivot tables in Excel 2000. When I take the database/Workbook home, I can no longer update the pivot tables. I have tried using a system DSN (which I create on both machines), and a file DSN (again, replicated on both machines). Is there any way other than going to each pivot table and manually editing the SQL statement to the correct address of the database? Why can’t I just change the address of the database using the DSN?
The SQL behind one of the tables, accessed through Microsoft Query is as follows:
SELECT Main.record_id, Main.Authors, Main.Title, Main.Journal_full, Main.Journal_abb, Main.Vol, Main.Iss, Main.Start, Main.End, Main.PubYear, Main.Country_au, Main.Language, PrimaryDrug.PrimaryDrug, Indications.Indication
FROM `F:Projects430001project`.Indications Indications, `F:Projects430001project`.Main Main, `F:Projects430001project`.PrimaryDrug PrimaryDrug
WHERE Indications.record_id = Main.record_id AND Main.record_id = PrimaryDrug.record_id
Kiwi44
