<div>
Is there some reason that you don't want to use linked tables? &nbsp;They would always be up to date.
</div>


Is there some reason that you don't want to use linked tables?  They would always be up to date.

<div>
<div class="content wysiwyg-content">
I am building a report that is tied to a direct ODBC feed, so there are no actual tables in my database.<br />
When I run this report through the runtime version at other stations, I receive a No ODBC alert.<br />
<br />
1. Is there a way to run such a report through runtime? If so, what needs to be set up to allow this to work?<br />
This is the desired state so the data in the report is always up to date.<br />
2. If not, how do I capture this data at a point in time and have it available for the users?<br />
<br />
Thanks!<br />
Dennis
</div>
</div>


I am building a report that is tied to a direct ODBC feed, so there are no actual tables in my database.
When I run this report through the runtime version at other stations, I receive a No ODBC alert.

1. Is there a way to run such a report through runtime? If so, what needs to be set up to allow this to work?
This is the desired state so the data in the report is always up to date.
2. If not, how do I capture this data at a point in time and have it available for the users?

Thanks!
Dennis

Managing a DB solution that is tied to an ODBC link

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.