Access A Problem?

C

Curt Emich

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.
 
J

jm

Curt Emich said:
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.
 
P

PC Trouble Shooter -->

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top