Looking for *= in queries?

  • Thread starter Thread starter Maury Markowitz
  • Start date Start date
M

Maury Markowitz

We are considering upgrading from SQL Server 2000 to 2008, but the
Compatibility Wizard states that *= is no longer supported. I looked
through our modules and storedprocs and found a couple of examples
that I was able to fix.

However, I am sure that there are many instances of this in queries
coded directly into the forms and reports. How can I find these?

Maury
 
Maury Markowitz said:
We are considering upgrading from SQL Server 2000 to 2008, but the
Compatibility Wizard states that *= is no longer supported. I looked
through our modules and storedprocs and found a couple of examples
that I was able to fix.

However, I am sure that there are many instances of this in queries
coded directly into the forms and reports. How can I find these?

Maury
Click to expand...

Dim qdf As Dao.QueryDef

For Each qdf In DBEngine(0)(0).QueryDefs
If Instr(1, qdf.SQL, "*=") > 0 Then
Debug.Print qdf.Name
End If
Next

Any names that turn up with ~sq as the first three characters are embedded
into Forms, Combos etc. It's pretty easy to work out where they are from
their names.

You need a reference to DAO for this to work, of course.
 
Maury Markowitz said:
This is excellent stuff! Is there a way to adapt this for ADP's as
well?

Maury
Click to expand...

Sorry, no. I've always been strictly mdb. Perhaps someone else will chime in
with a suggestion for you.
 
Back
Top