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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top