Problem with running an action query on a view

[Rob Wills]

Hi,

I'm confused as to why the following line of code didn't work in my Access
2007 version....

currentproject.Connection.Execute "INSERT INTO tblCashFlowsHistorical_OUT
SELECT * FROM vw_Principal"

Where vw_Principal is a View on a table.

Basically the code ran, with no errors, however the expected results were
not achieved.

Yet when I changed the above to "Currentdb.Execute" this did work.

Is this a bug in the ACE db engine?

Thanks
Rob

 

[Rob Wills]

Problem solved....

The view was using the "*" wildcard character which is fine when using the
Jet engine....

However when typing "CurrentProject.Connection" that specifies use of the
ACE db engine, which uses ANSI-92 as opposed to ANSI-89.

Basically I needed to change my wildcard character to a "%"...