How do I establish a connection to a Access 2007 db.

[jazzz]

I am currently using a MS Access 2000 db on my site and this is the connection string I am using to connect to it.

objConn_swaptrade = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("/database/swaptrade.mdb")

How do I change the line above to work with an Access 2007 database. Also does my web provider need to install anything on their server to make my database to work too.

Thanks in advance!

Life's a journey enjoy the ride...

jazzz

 

[damber]

http://www.connectionstrings.com/?carrier=access2007

A smile is worth a thousand kind words. So smile, it's easy!

 

[jazzz]

Thank you! I found this one too and it won't connect. I believe my service provider needs to add an extension to their server for an accdb database. I checked my control panel on the web site and Access 2007 is not listed as one of the databases I can use.

Life's a journey enjoy the ride...

jazzz

 

[damber]

you'll need to ensure they support that specific provider: "Microsoft.ACE.OLEDB.12.0"

Do they allow you to setup an ODBC connection? if they do, look at what providers they allow you to use in there.

As I've not used Access for a long time, I've no idea whether access 2007 supports the older connection provider or not - I assume you've tried ?

Also, I think you may be able to use a proper ADO provider in access 2007, which is not dissimilar to sqlserver:

http://msdn2.microsoft.com/en-us/library/bb243781.aspx

try it out and see if it works.



A smile is worth a thousand kind words. So smile, it's easy!

 

[jazzz]

Damber thanks again I will check out the link. Access 2007 does not support the older connection provider I tried. And since they list specific versions of the connections I can enable and Access 2007 is not one of them I assume I am out of luck for now.

Life's a journey enjoy the ride...

jazzz

 

[damber]

did you try the ado provider I mentioned above ?

A smile is worth a thousand kind words. So smile, it's easy!

 

[jazzz]

No I didn't but I will tomorrow. Our server backs up today so I really don't like to do to much when that is going on.

Life's a journey enjoy the ride...

jazzz

 

[jazzz]

Conclusion, the web site that is used to host this database is Web.com and they do NOT support Access 2007 databases or so my ticket tells me.

Thank you for your help anyway.

Life's a journey enjoy the ride...

jazzz