A
AMH
Hi,
I was hoping someone could help me with inserting a record from an ADP
to a MDB, based on the current record displaying on a form.
eg. I add a new record in an access form, when I click Save, copies
that record to another database.
Previously, both databases were MDB, and this is the SQL I used:
INSERT INTO [MS Access;DATABASE=T:\Databases\Training
Database\training.mdb].training ( [number], type, name, [Yes-No_Fld] )
SELECT documents.number_rev, "Internal" AS Expr2, documents.title, "No"
AS Expr1
FROM documents
WHERE (((documents.number_rev)=Forms!documents_form!number_box));
Now, I need to do the same thing from SQL Server (ADP) to MDB.
I have heard that you can do this using an ADO command, but I have no
idea what that is...?
Any help would be appreciated.
I was hoping someone could help me with inserting a record from an ADP
to a MDB, based on the current record displaying on a form.
eg. I add a new record in an access form, when I click Save, copies
that record to another database.
Previously, both databases were MDB, and this is the SQL I used:
INSERT INTO [MS Access;DATABASE=T:\Databases\Training
Database\training.mdb].training ( [number], type, name, [Yes-No_Fld] )
SELECT documents.number_rev, "Internal" AS Expr2, documents.title, "No"
AS Expr1
FROM documents
WHERE (((documents.number_rev)=Forms!documents_form!number_box));
Now, I need to do the same thing from SQL Server (ADP) to MDB.
I have heard that you can do this using an ADO command, but I have no
idea what that is...?
Any help would be appreciated.