Hello Dennis, I think the connection object you are suggesting is the very object the error message is talking about.
My 2 cents, Regards Robin. --- In [email protected], Dennis Jensen <[EMAIL PROTECTED]> wrote: > > Okay my first question is why not make the process a > bit simpler and either use a DAO or ADO connection to > the database? It would facilitate easier maintenance > and portability in the future. > > --- irshadjamal <[EMAIL PROTECTED]> wrote: > > > 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! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
