how to produce code-generated queries in ADP

[Guest]

I have converted an MDB to an ADP because it was too big for the PC. However,
I can't see how to port the code that I used to generate SQL queries. As far
as i can tell, 'views' do not have an 'SQL' property.

Where do I go from here?

Thanks!

 

[Brendan Reynolds]

You can use DDL ...

Public Sub CreateView()

CurrentProject.Connection.Execute _
"CREATE VIEW TestView AS SELECT * FROM dbo.Employees"

End Sub

 

[Van T. Dinh]

I don't use ADP but view definitely has SQL String. If you look at a View
in Design View in Access, use the Menu command View / Show Panes / SQL to
display the SQL pane. There is also an equivalent button (with the letter
"SQL" on the "View Design" Toolbar.

I am not sure of what you meant by your first sentence???

Do you have Front-End and Back-End MDB prior to ADP conversion? How big was
the Front-End MDB? Back-End MDB?

Note that with the coming Access 2007 version, ADP format does not have the
same set of features as the new ACCDB format ... so you may need to read
more documentation and decide whether converting to ADP is the correct path
for your situation.

 

[Guest]

Thanks, Brendan. Just what I needed.

I have 2 books that touch on ADP (Balter's 'Mastering MSO Access 2003' and
Allison/Berkowitz's 'SQL for MS Access'), but both of them are actually
pretty useless on the subject: just enough info to trick me into reading the
chapters before realising that all I got was an appetiser.