how to do create view from VA in adp

[Jerry Qu]

Hi All

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

can we do the samething in adp


TIA

Jerry

 

[Sylvain Lafontaine]

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.

 

[Jerry Qu]

Thanks,

but how can it be opened in datasheet like docmd.openquery did.

thanks

Jerry

 

[Sylvain Lafontaine]

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.