how to do create view from VA in adp

  • Thread starter Thread starter Jerry Qu
  • Start date Start date
J

Jerry Qu

Hi All

In access, we can create query on fly using QueryDef.

can we do the samething in adp


TIA

Jerry
 
Use ADODB objects instead of QueryDef. To have access to the current open
connection, use one of the following:

CurrentProject.Connection
CurrentProject.Connection.ConnectionString
CurrentProject.Connection.Execute

S. L.
 
You must use the command « DoCmd.OpenView ("VIEW1"), acViewNormal » to
display a SQL View or the .OpenStoredProcedure for a SQL stored procedure.

However, if you want to create them on the fly with a schema change, you
cannt use the command RefreshDatabaseWindow command to refresh the
information about the schema change; meaning that you will to close/reopen
the connection.

Don't try to see ADP as the same things and capabilities as Access with an
MDB file, it's asking for trouble.

S. L.
 
Back
Top