Access problem in linking Excel datafile from network

[Gouri Dutta]

An Access application, linking an excel spreadsheet, for data. The application captures the data through two queries and generates an Access table for the application. The application links a mail merged word document which captures data from the generated Access table and prepares Invoice reports. The word document has been modified recently.

PROBLEM: When I run the application, it brings a path which points to a path in Home drive instead of the referencing a network path.. When I change the reference to the correct location in the network path, everything works fine including mailmerging. I have tried to save the network path to refer to, but again the application brings the reference to Home drive. I have to manually fix the path. No codes in the application shows any reference to Home drive. Where it is getting that reference of Home drive is a mystery. The link to the Excel spreadsheet has been refreshed, relinked, but nothing helped.
Any recommendation would be highly appreciated.

 

[apr pillai]

Try using a UNC type address: \\ServerName\FolderName\SubFolder\FileName for linking the file, rather than a Maped Netwrok Drive address.

You can open an Excel database directly in a Query:Opening Excel Database directly