Skip to Content
0
Former Member
Aug 05, 2005 at 11:18 AM

MS Access via linked server

22 Views

Hi Everybody,

I have a requirement to do transactional reads on a MS Access database. I could not find any standard way to link SAP to Access (please let me know if someone else has done this)

As a workaround we created a linked server (Access) to the MS SQL Server on which SAP runs here. The idea was to then use native SQL to query this linked database (since SQL Server links with Access with no problem) to get the data from Access.

So far so good, but when running the query with OPENQUERY I get a short dump with the message 'Remote access not allowed for Windows NT user activated by SETUSER'. Bugger!

Any of you brainy guys out there have any ideas?

Thanks in advance,

Gerald