Web application development using MS Access

Question

I have a problem with access database. I am developing a web application in visual studio 2010 using C#. I was using sql server 2005 as my database. Recently it is changed into Access. When I am trying to save some data to the Access database from my application it won't work. But when I am trying to do the same from Access itself it works correctly. What is the problem and what will I do for rectifying this problem.

The first thing you should do is post your connection/insertion code. — Jacob
– Jacob, Commented Jul 19, 2011 at 5:12
Access/Jet/ACE is really an inapropriate data store for a web-based application. You can get by with it for small apps with few users and few writes, but it's not designed for that purpose and comes with a number of serious problems. — David-W-Fenton
– David-W-Fenton, Commented Jul 20, 2011 at 23:36
@David-W-Fenton : I know that, but what can I do? Client decides such things and our duty is to develop applications which client asks.Actually I don't know access because I never used it before. I used only MSSQL. — Nelson T Joseph
– Nelson T Joseph, Commented Jul 22, 2011 at 5:19

Rasel · Accepted Answer · 2011-07-19 05:12:46Z

1

There is some difference with query in ms-access.Like if you have to query with date column then you have to use #+date+# instead of '+date+'

answered Jul 19, 2011 at 5:12

Rasel

15.5k6 gold badges42 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Web application development using MS Access

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related