The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
MS Access Connection to the OLEDB Provider
Posted: 20 Feb 08 5:43 PM
|
I have a user who wants to download SalesLogix data to MS Access to maniupulate it to create some management reports. I am trying to set up a user to access the SalesLogix database through the OLEDB provider, because I want them to use their SalesLoix ID to access the data instead of a SQL ID, is this possible and are there any problems with what we're trying to do? MS Access seems to only want to connect to ODBC data sources.
SLX Version 7.0.1
Thank you! |
|
|
|
Re: MS Access Connection to the OLEDB Provider
Posted: 20 Feb 08 6:47 PM
|
I don't think that you can do this using the standard GUI tools in Access. However, writing some code to create the OLEDB connection and bring back the data would be possible.
As you'll (presumably) want this data to be read only, I'd be tempted to set up a SQL-only user with read-only permissions to the SLX data and get them to use that for access in Access, if you know what I mean ... then you could use the Access GUI as normal to add linked tables, queries, reports etc, which is probably what the user is expecting/hoping for.
Phil |
|
|
|
Re: MS Access Connection to the OLEDB Provider
Posted: 20 Feb 08 7:37 PM
|
Thanks Phil! I was actually hoping to avoid creating a SQL user because my security people don't want me to do that, but it sounds like that's what I'm going to have to do, so they'll have to live with it.
Thanks for the help! |
|
|
|
Re: MS Access Connection to the OLEDB Provider
Posted: 20 Feb 08 8:43 PM
|
No probs. 100 posts - congrats!
Being able to give a user controlled read-only access sounds like less of a security issue than giving them access via SLX OLEDB to me. You should consider doing this over a trusted connection for increased ease of use. Sounds to me like they just don't want to do the setup work!
Phil |
|
|
|