Thanks for your help but sorry - I'm not getting this !
When I open my access database and "get external data" and then choose link tables the only information that is displayed is a Link Tables box with only one tab (Tables) with all the tables in the SQL database listed.
Am I seeing only tables because I haven't created any views in the SQL database yet ? I would have created an SQL view and found out rather...
dipperdave
Last Activity: Apr 1 '07, 12:19 PM
Joined: Mar 21 '07
Location:
-
I want to link to a view of data in the SQL database. So I can't use Access on the client machines and will have to use SQL ?...Leave a comment:
-
running remote queries
I have an Access database on a server which utilises data from an SQL server on the same machine (it's set up like this because I have some limited access skills but no sql skills and because the sql database is an erp system which I prefer to keep discrete).
I want to provide limited reporting and (non-updating) query capabilities to authorised users on the lan/wan. I'm hoping I can install access on each user's machine and link to...
No activity results to display
Leave a comment: