Running SQL Server Dataviews in MS Access (1 Viewer)

psimpson

Registered User.
Local time
Yesterday, 16:03
Joined
Aug 1, 2007
Messages
40
A specific dataview has been set-up on a partner server for company to access. Can someone provide specific directions on how to retrieve the data? The database is looking for the data on my home drive, not the server to which I am connecting.

I import the data into a blank database and write a query--that I am not able to save--and select run. I either get too much data or it points to the incorrect server.

Can anyone help?
 

Users who are viewing this thread

Top Bottom