Primary Keys and VB5 ?? 
Author Message
 Primary Keys and VB5 ??

Thank you for finding the time to read this e-mail.

I have created an Access database using ACCESS97. The database houses
two tables (Machine, Components) and have created a primary key for
both and linked these two together.  Testing the database by building
a form within Access works fine - in the case that when I enter a new
Machine record, it automatically updates the Component table.

I then wrote some VB5 code to access this same database where a user
enters information into forms (designed under VB) then save the info
to the database, but this time the Components table doesn't update
like I saw under Access and as a result generates an error.

Do I have to redefine the primary and index keys again in my VB code -
I would have thought this would happen automatically as I have defined
the keys in Access.

I am only fairly new to databases so this question may seem strange.

Best Regards
Peter Moscatt

CIS: 100032,2114

Wed, 02 Feb 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Joined Primary Key in Foxpro (Make 1 Primary Key from 2 fields)

2. Primary key is a combination of two keys

3. Primary key is a combination of two keys

4. Primary key , Secondary Key ???????

5. Primary key is a combination of two keys

6. Primary key, Foreign key, referential integrity, etc?

7. Using SQL to create 2 Primary/Unique Keys in a Table

8. Primary Key Disappears

9. add primary key in VB code

10. multifield primary keys

11. Returning AutoNumber Primary Key when using INSERT

12. Access97 - Linked Tables - Primary Keys - VBA


Powered by phpBB® Forum Software