how to produce code-generated queries in ADP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allen_N - 06 Nov 2006 06:09 GMT

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!

Reply to this Message

Brendan Reynolds - 06 Nov 2006 10:30 GMT

You can use DDL ...

Public Sub CreateView()

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

End Sub

Signature

Brendan Reynolds
Access MVP

>I have converted an MDB to an ADP because it was too big for the PC.
>However,
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

Allen_N - 06 Nov 2006 21:36 GMT

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.

> You can use DDL ...
>
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message

Van T. Dinh - 06 Nov 2006 10:32 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

>I have converted an MDB to an ADP because it was too big for the PC.
>However,
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message