Problem adding new record to inner join recordset... 
Author Message
 Problem adding new record to inner join recordset...


Quote:

> I'm getting the same error with any attached tables.  I have a Access
> db with a few attached dbf files.  In Access the everything works
> fine.  In VB3 everything works fine.  With VB4 I get the same error
> that you describe.  Checked with MS they have no idea whats going on,
> of course everything they do is with "biblio" which has no attached
> tables.  I'm in big trouble trying to upgrade to VB4.

>                                    MEH

Do you have a one-to-one join or a one-to-many. If it is the latter,
you can't alway change the one-side.

I've the same problem as you (if it is one-to-one and you are not
violating relation-rules), but not with attached tables, but with
access 2.0 tables. It works fine with Access and VB3 but not with
VB4. Deep trouble. MS has no idea!



Thu, 14 May 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problem adding new record to inner join recordset...

2. Problem adding new record to inner join recordset...

3. Problem adding new record to inner join recordset...

4. SELECT . INNER JOIN--INNER JOIN

5. Query/Recordset problem on inner join with sql oledb provider

6. Problem adding new record to SQL database recordset

7. Problems with adding new records in a recordset

8. Can not add a new record to the recordset based on the INNER JOIN query (SQL Server)

9. Adding a record to a recordset based on a join

10. Using ADO recordsets in an inner join

11. VB5-DB:INNER JOIN on two crosstab recordsets?

12. error updating a recordset using an inner join - please help

 

 
Powered by phpBB® Forum Software