How do you open multiple tables from a database in a form and update..

[samuelsisgay]

How do you open multiple tables from a database in a form and update records - that is, fill the records according to user entries in a textbox, checkbox, etc.

I have a problem with updating multiple table records from a single database. Eg.

I can open a certain table from a database and retrieve its records but cannot connect to another table within the same database(in the same form) and add new records to it. I have a command button that should do this job.

 

[ahhuang]

You can specify different recordsets to open or different tables. If you are to update many tables at 1 time, then it would be better to have commit/rollback sessions :>

 

[vyper78]

How do you organise commit/rollback sessions??
Can you point out where i can find some code?

 

[johnwm]

If you're using Jet, then look up 'Transaction' in JetSQL help, which is normally in:
"C:\Program Files\Common Files\Microsoft Shared\Office10\1033"

If you're using MSSQL look in SQLBooksOnLine, downloaded from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[BehnamPro]

Do u use ADO or DAO?
if u use DAO,so use a "Data" object.Then u may change table from its properties(RecordSource).It contains all tables of a database.



Behnam2204@yahoo.com

http://www.geocities.com/behnam2204

BehnamPro