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 --------------------~-->
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/
