A querry would not run in server but would run in local machine

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

I have the following querry in a database, that runs
totally fine is my

"mdb" file is located in my local machine.

Where as if the same "mdb" file is moved to a server and
run the same querry

from there it creates some problems. It tries to return
some records and

stops saying "At most one record can be returned by this
subquerry" in a

message box. After I click "OK" all the values in the
querry's results

changes to #Name?.

I do use a custom created function to join results from
multiple table to

every record in another table.


Any thoughts, please help.
 
Back
Top