Re: VBA SQL

From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
Date: Tue, 31 Jul 2007 18:18:13 GMT

Starke wrote:

I have a database that I am converting to a mysql backend so I can
access it across a wan a little better (hopefully).. Im converting my
DLookups to sql statements but I have an issue when they return no
records. See below for the code. Also, what are your thoughts of
converting the access db to a mysql backend with use over a t1 wan?

In my experience with tracing tools, Domain functions applied to an ODBC
link are already translated into nicely formatted SQL statements sent to the
server so I doubt that you will see any benefit to replacing all of your
DLookups() as described.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

.

References:
- VBA SQL
  - From: Starke

Prev by Date: Re: Changing the Value of a Field in a Bound Form
Next by Date: Re: How to run multiple queries through a macro?
Previous by thread: Re: VBA SQL
Next by thread: FE/BE and Citrix
Index(es):
- Date
- Thread

Relevant Pages

Re: VBA SQL
... strVenName = rsVendor!vendor_name ... you might find this easier than rewriting all your domain aggregate ... access it across a wan a little better.. ... converting the access db to a mysql backend with use over a t1 wan? ...
(comp.databases.ms-access)
VBA SQL
... I have a database that I am converting to a mysql backend so I can ... access it across a wan a little better.. ...
(comp.databases.ms-access)