ODBC Linked tables / MS Access Linked Tables
Posted on 2009-02-10
Currently we have an Access database that has ODBC linked tables to our software (Greentree). Linked table manager shows as " DSN=Greentree; "
It seems every time I want to run a query using these linked tables a popup window entitled "Jade Connect" pops up requesting username / password, which we provide, and it then takes age's to run.
I would like to find a way to set up another Database, with Tables that are refreshed either manually in the morning, or overnight via a script, and not linked in this manner, so we can run a query without continously loggin in, and taking so long to run.
Any help / Advice is gratefull.
Regadrs / Kevbb.