Newbie question - Unhandled exception OleDbDataAdapater.Update

[Lance Geeck]

I am following an example in the walk throughs that uses an
oledbdataAdapter, grid, and then updates the database when an update button
is pushed. It works fine and is dirt simple. This is going against SQL pubs
authors table.

When I follow the exact same steps with my database and a simple table, the
program breaks while attempting an update on
oledbdataadapter1.update(dsCD1)

The differences are that I am trying to use an Access 2000 database. Other
than that, they seem as if they should be the exact same process.

I did find a help document that says that it could be I am not passing the
database user name and password. As near as I can figure, the database is
not secured in any way.

Thanks in advance for any comments or help you can provide.

 

[Armin Zingler]

I am following an example in the walk throughs that uses an
oledbdataAdapter, grid, and then updates the database when an update
button is pushed. It works fine and is dirt simple. This is going
against SQL pubs authors table.

When I follow the exact same steps with my database and a simple
table, the program breaks while attempting an update on
oledbdataadapter1.update(dsCD1)

Is an exception raised? Which one?

 

[Armin Zingler]

Thanks for responding.

The error message is:

An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

This is all that it says.

Catch the exception (Try..Catch..end try) and examine it.

Armin