carlnewton
Registered User.
- Local time
- Today, 14:44
- Joined
- Jan 10, 2008
- Messages
- 19
Please bear with me, but this is a strange one:
I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more records for 'export' to a word mailmerge or to a shipper report.
In order to make each users 'export' selections unique in this multi-user environment I use the CopyObject method to copy the underlying Equipment table to a temporary new table titled 'Temp <Now()>' (within the Form_Open Event). I then set subform.recordsource = 'Temp Now()'. In this way, the original Equipment table never really has it's 'Export' field set to = True. Only the temporary table does. Each user is using a unique dataset at runtime. I delete the Temp table from the database from within the Form_Unload event and set the subform.recordsource = 'Equipment'.
This worked fine until I split the database. The Temp table and the Equipment table seem to be linked. If I make Export = True on the temp table, that record is also updated within the Equipment table! I'm stumped...
Carl
I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more records for 'export' to a word mailmerge or to a shipper report.
In order to make each users 'export' selections unique in this multi-user environment I use the CopyObject method to copy the underlying Equipment table to a temporary new table titled 'Temp <Now()>' (within the Form_Open Event). I then set subform.recordsource = 'Temp Now()'. In this way, the original Equipment table never really has it's 'Export' field set to = True. Only the temporary table does. Each user is using a unique dataset at runtime. I delete the Temp table from the database from within the Form_Unload event and set the subform.recordsource = 'Equipment'.
This worked fine until I split the database. The Temp table and the Equipment table seem to be linked. If I make Export = True on the temp table, that record is also updated within the Equipment table! I'm stumped...
Carl
