query execution

[Guest]

If I have a back end on a server (linux) and a frontend on user machines, where are the queries executed
If on server, i suppose they want function because the server doesn't run access
Should i try to build the queries into code so that they can be runned on users machines
Thanks
Rocc

 

[Rick Brandt]

If I have a back end on a server (linux) and a frontend on user machines,

where are the queries executed?

If on server, i suppose they want function because the server doesn't run access.
Should i try to build the queries into code so that they can be runned on users machines?
Thanks,

When run against a standard JET back end ALL processing is done on the
client. The server where the data file resides is nothing more than a
"remote hard drive".

This doesn't mean that every query you run causes the entire file or even
the entire table to be pulled across the network (a common misconception).
It just means that whatever I/O would ordinarily occur on your hard drive
(when the data file is local) now occurs over the network instead.

 

[Van T. Dinh]

Queries are executed on the user's PC unless you use Pass-Through Queries to
pass the SQL String to the back-end database servers like MS-SQL Server,
Oracle, etc ...

The Linux server is simply a file server (AFAIK).

--
HTH
Van T. Dinh
MVP (Access)

If I have a back end on a server (linux) and a frontend on user machines,

where are the queries executed?

 

[Guest]

thanks
so that's fine but i still can't understand why some process will run perfectly on my system and the same process will return error messages while called from users machines
i mean for instance a simple command button on the form that will allow for printing the form
This command works perfectly during testing the application on my pc. Now i have splitted the db, posted the back end on the server and the fornt end (mde file) on the user machine
Well the command for printing gives a message saying "print command not available" and the application freeze. i need to use ctrl+alt+canc to stop the process and reopen the application
i think something lacks on user machine. But I can't immagine what..
Any suggestion?

 

[Van T. Dinh]

The first thing I would check is the Reference Errors on the user's machine.
See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
HTH
Van T. Dinh
MVP (Access)

thanks,
so that's fine but i still can't understand why some process will run

perfectly on my system and the same process will return error messages while
called from users machines.

i mean for instance a simple command button on the form that will allow for printing the form.
This command works perfectly during testing the application on my pc. Now

i have splitted the db, posted the back end on the server and the fornt end
(mde file) on the user machine.

Well the command for printing gives a message saying "print command not

available" and the application freeze. i need to use ctrl+alt+canc to stop
the process and reopen the application.