access database

[Hai Nguyen]

with access database

1/ How can we insert mutiple row into a table at the same time?
2/ is it possible a table in access database to have more than one primary
key?

Thanks

 

[Miha Markic]

with access database

1/ How can we insert mutiple row into a table at the same time?

I don't think jet oledb driver supports batch operations.
You might use a query as a stored procedure though.

2/ is it possible a table in access database to have more than one primary
key?

Primary key is one and only. Why do you need another one?