Using MS Access to read SLX data

[wshpuntoff]

I am working with a company that has an abundance of MS ACCESS 2003 applications and I have created a new SLX customization that they will want to be able to read from. It makes heavy usage of dates, so i really want them to get the data from the OLEDB provider.

I don't see a way to get ACCESS to use SLX via OLEDB - it seems to be limited to ODBC.

So my question is two fold here...

1. Is there a way for MS Access to read SalesLogix data via OLEDB?

2. (if not) Is there a way to set up an ODBC driver to use the SLX provider?

Plan B is to set up a view for them that handles the GMT conversion.

any ideas out there?

thanks

ws

[RJLedger]

You were trying to use the linked server approach?

[wshpuntoff]

This would be Access attaching SalesLogix as an external data source

ws

[RJLedger]

Yep.. I just tested it in Access2007 (Table->Import->ODBC database...) and created a system DSN using the Slx Native Client to a SQL2005 server hosting several SalesLogix db's on my "StarGate" main db server.. from Access in my laptop.

Linked the table(s).. opened them in access..  (did Account/Contact) and did a joined query.

;-)

[wshpuntoff]

When I go to create a system DSN - I don't see SalesLogix as an option.

I can attach via SQL Client, but that is what i am trying to avoid here.

Am I missing something here?

[RJLedger]

You want to "create" a new system DSN as you step thru... and it will let you select SQL server. After it's created, then you can use it.