Dear List, When I run the following query by pressing a command button in VB.
Sub Update_SystemTab() Dim QueryStatement As String QueryStatement = "INSERT INTO System(System_ID, Oblast_Name, District_Name, Village_Name,Longitude, Latitude, Elevation ) IN 'C:\Irshad_UN\Rehabilitated_Water_Supply.mdb'SELECT System.System_ID, System.Oblast_Name, System.District_Name, System.Village_Name, System.Longitude, System.Latitude, System.Elevation FROM System IN 'C:\Irshad_UN\WSS_Khatlon.mdb';" Docmd.RunSQL (QueryStatement) End Sub I get a runtime error 424, Object required after Docmd.RunSQL. I am running this from Arcview 9.1 Thanks in advance. Irshad ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
