VB.NET with MS Access 2007

Question

User-760280719 posted

I'm able to connect to MS Access thru my code (VB.NET) on my local computer

But when i'm posting my web page to IIS server, it takes forever to browse that page. It keeps saying loading, but it never loads?? i'm not seeing any error msg, as page never gets loaded

I've IIS 6.0.. .NET 2.0; MS Access 2007 is available on the box...not sure what i'm doing wrong.

Following is the connection string which works perfectly when i'm running this on my desktop

 

OleDbConnection(

 

"Provider=Microsoft.ACE.OLEDB.12.0;" & _"Data Source=D:\Ideation.accdb; " & _"Persist Security Info=False;")

 

 

Any thoughts would be helpful

 

thank you

 

Answer 1

User-1199946673 posted

 everything is explained in:

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

and

http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error

Answer 2

User-760280719 posted

Thank you for your reply.

things work fine for Access 2003, (which i save my .mdb in App_Data folder).

but, when i used Access 2007 and posted my file on IIS server, it is taking very long to open web page and actually it never opens.

When I tried connecting to Access 2007 database from Visual Studio on the server, it works fine. is there any special setting on IIS to enable .accdb?

 

 

 

Answer 3

User-1199946673 posted

is there any special setting on IIS to enable .accdb?

 

Like I said, everything is explained in the article's!

"If you are deploying a .accdb file, you are using Access 2007, and this has its own provider - the ACE 12.0 OleDb provider. At the time of writing, the ACE provider is only available as part of Microsoft Office Professional or higher, or as a separate download from Microsoft Downloads. It is not installed on any machine by default."

And:

"From a web application perspective, the differences between a .mdb file and a .accdb file are so insignificant that I would always recommend that the .mdb format is used."

 

Answer 4

User-760280719 posted

yes, we've installed ace 12.0 oledb provider on the server. it works only if we use visual studio environment to run the app.

but it fails when i deployed on IIS.

this accdb is linked to sharepoint 2007 and, there are certain functionalities which are not available on access 2003. so cannot use access 2003