<div>
Thanks very much. Will keep it simple, and save passwrod option is best for now. Thanks again.
</div>


Thanks very much. Will keep it simple, and save passwrod option is best for now. Thanks again.

<div>
<div class="content wysiwyg-content">
Currently we have an Access database that has ODBC linked tables to our software (Greentree). Linked table manager shows as &quot;&nbsp;DSN=Greentree; &quot;<br />
It seems every time I want to run a query using these linked tables a popup window entitled &quot;Jade Connect&quot; pops up requesting username / password, which we provide, and it then takes age's to run.<br />
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. <br />
<br />
Any help / Advice is gratefull.<br />
<br />
Regadrs / Kevbb.
</div>
</div>


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.

ODBC Linked tables / MS Access Linked Tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.