By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,407 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,407 IT Pros & Developers. It's quick & easy.

Access A Problem?

P: n/a
I've tried every possible combination of commands to insert a new record
into an Access table, and it just won't happen. Does anyone know if Access
has problems working with .NET?

Check out this link:

http://www.dotnetextreme.com/code/BasicAdo.asp

This is the simplest code sample I've seen anywhere (book or Internet) to
demonstrate how to insert a new record into an Access table (why finding
such an example was like pulling a rhino's teeth is another issue). I
copied the code almost verbatim (mine was VB instead of C#). No dice.

I've made sure my security settings in the folder containing the Access
database are not "read only", etc. Any other ideas, or is ADO.NET a red
herring? I've noticed that a good many other experienced developers are
having difficulty pulling off something this absurdly simple.
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jm

"Curt Emich" <ce****@comcast.net> wrote in message
news:YO********************@comcast.com...
I've tried every possible combination of commands to insert a new record
into an Access table, and it just won't happen. Does anyone know if Access has problems working with .NET?

Check out this link:

http://www.dotnetextreme.com/code/BasicAdo.asp

This is the simplest code sample I've seen anywhere (book or Internet) to
demonstrate how to insert a new record into an Access table (why finding
such an example was like pulling a rhino's teeth is another issue). I
copied the code almost verbatim (mine was VB instead of C#). No dice.

I've made sure my security settings in the folder containing the Access
database are not "read only", etc. Any other ideas, or is ADO.NET a red
herring? I've noticed that a good many other experienced developers are
having difficulty pulling off something this absurdly simple.


Sorry if I missed it, but maybe you should post your error.
---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004
Nov 18 '05 #2

P: n/a
Curt,

The error will help to determine where the problem is.
When you configure the OledbDataAdatper, it has all the code written inside
the #Region section for Add, Delete, Update.

Mark

"Curt Emich" <ce****@comcast.net> wrote in message
news:YO********************@comcast.com...
I've tried every possible combination of commands to insert a new record
into an Access table, and it just won't happen. Does anyone know if Access has problems working with .NET?

Check out this link:

http://www.dotnetextreme.com/code/BasicAdo.asp

This is the simplest code sample I've seen anywhere (book or Internet) to
demonstrate how to insert a new record into an Access table (why finding
such an example was like pulling a rhino's teeth is another issue). I
copied the code almost verbatim (mine was VB instead of C#). No dice.

I've made sure my security settings in the folder containing the Access
database are not "read only", etc. Any other ideas, or is ADO.NET a red
herring? I've noticed that a good many other experienced developers are
having difficulty pulling off something this absurdly simple.

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.