Duplicate queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been tasked with converting an Access 2003 solution to .Net & SQL
Server. The Access solution has an MDB file that contains the database and
some query definitions out on a file server. There is also an MDE file that
contains the UI, reports and some more query definitions that sits on the
user's system. If a report that is defined in the MDE file uses
"qryForecast" and there is a "qryForecast" in both the MDE file and the MDB
file, which one is actually being used?

Thanks in advance!
 
If a report that is defined in the MDE file uses
"qryForecast" and there is a "qryForecast" in both the MDE file and the MDB
file, which one is actually being used?
Click to expand...

The one in the local (MDE) database (unless someone has some
particularly sneaky code).

John W. Vinson[MVP]
 
Back
Top