dudley221

I have imported a number of tables from an old Dbase III system into Access. When I reference the tables, usinf Access, all works very well but when I make modifications to the Access database with VB.net I can't do an Update to the file - help.

wayneph

2 things to check...

1. Make sure that your user has Create and Delete permissions on the directory containing the Access Database. It is required for Access to process the table locking. (.ldf file)
2. Make sure your application is set up to use the existing copy of your database. If you included the file in your project, it may be copying the database locally each time your project starts. That would appear that your database wasn't being updated because the updates are being made in a different file.

dudley221

Thanks but I don't think this is the problem. I get a message on the update command of: changes = dataAdapter.Update(dt)

"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."