Problem adding record to blank Access Table using DAO 
Author Message
 Problem adding record to blank Access Table using DAO

I hope someone out there can help me with this weird

I get exceptions when adding a record/row to a blank
Access table and then trying to read the values of the
newly added record.
Once there is at least one record (added by hand)
everything is fine.

It is not just my code because I can recreate a similar
problem when using the VS supplied sample DAOEnrol
If I delete all the Courses from the sample stdreg
database and then try adding a new course it does not
work correctly.

I am using VS.Net 2000 Proffesional. The ODBC driver for
Access is 4.00.6019.00
I dont know what else to check for version numbers etc.
There is a KB article on a similar problem no:124998 but
that talks about pre 2.0 ODBC and is dated 1999!

Any ideas - appreciated.

Sat, 23 Jul 2005 21:02:10 GMT
 [ 1 post ] 

 Relevant Pages 

1. How to Avoid adding BLANK Records to a table using a FORM

2. HileStorm:how to add a picture into table using ado/dao code not using controls

3. Using ADO VC++ to add a new record to an Access table with one autonumber field

4. Using Access VBA to add multiple records in a loop to a table from a form

5. .AddNew not adding blank record points to existing record

6. ADO2.5, can't add new record to an empty table using record binding

7. Adding records to a MDB file using DAO

8. Get the record ID after add from MDB using DAO

9. DAO & Indexes - Adding records/Current record

10. Strange ODBC errors using DAO to access linked tables in Access .MDB

11. error 6 overflow: accessing large access table using DAO

12. Cannot add record to Visual Foxpro table after deleting all records in table

Powered by phpBB® Forum Software