Hi Everyone, I am very new to access was hoping for some help. At my place of business, we have upgraded our computer systems and I need to recreate a access report which pulls data from an SQL server.
The access file Queries all data on the server from the previous day. Problem is that the report was set up by a third party company and I cannot recreate the report since I cannot locate the ODBC driver with the link table manager on the server and the third party is no longer in business.
I have my old computer and can run the report on it, but without the path I cannot run report on new computer. Is there a way to somehow view the path to the ODBC driver on my old computer? Is the info hidden somewhere in the file whereas I can retrive it.
On my old computer this data source was specified so the program runs, can I somehow view this location within the file?
Thanks in advance.