Is there any way to link access queries to migrated sql server views in order to access them from MS Access? Any help will be really appreciated.
Is there any way to link access queries to migrated sql server views in order to access them from MS Access? Any help will be really appreciated.
The views are migrated to where? I don't have much experience with SQL Server data but shouldn't you just be able to have Access link to the views and build queries that join the two data sources?
http://office.microsoft.com/en-us/ac...010200494.aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks for the reply June7.I have read exactly the same link that you have posted above but I don't see anything about using access queries from MS access which are migrated as views in sql server. The thing is, I have queries in Microsoft Access and when I migrated my access database to SQL server those queries are migrated as views in sql server. Now I want to run those views from Microsoft access.
You migrated Access queries to SQL which made them views? Now want to run those views from Access? Are the views action SQL - UPDATE, INSERT, DELETE - and not SELECT?
This is the only thing I can find that comes close:
http://accessexperts.net/blog/2011/0...access-part-1/
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks. The queries that I have are all SELECT queries.
Then have you tried linking as suggested by the article?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I will try doing that way tomorrow at work. Thanks.