Second Query Question

[Matthew Braumiller]

Greetings again:

The database we are using at the office here has an Access 2002 front
end (client) on each user's work station. The data tables are stored
on the server located elsewhere in our office. Each client links to
the tables on that server allowing shared access by the 25 users we
have here. Is there a way to have the queries run on the server side,
the back end, rather than on each individual client? I have not found
a way to link queries stored server side like a shared resource,
though I have been told it is possible. Is it possible? How is it
done?

Thanks again for your time!

[Wayne Morgan]

There is nothing "running" on the server. The file is simply being accessed across the
network. To do what you are asking, you would need a database program running on the
server that you could send request to, such as SQL Server.

--
Wayne Morgan
"Matthew Braumiller" <ma**@dwminc.com> wrote in message
news:di********************************@4ax.com...

Greetings again:

The database we are using at the office here has an Access 2002 front
end (client) on each user's work station. The data tables are stored
on the server located elsewhere in our office. Each client links to
the tables on that server allowing shared access by the 25 users we
have here. Is there a way to have the queries run on the server side,
the back end, rather than on each individual client? I have not found
a way to link queries stored server side like a shared resource,
though I have been told it is possible. Is it possible? How is it
done?

Thanks again for your time!

[Ross Presser]

"Wayne Morgan" <co***************************@hotmail.com> wrote in
news:eM**************@TK2MSFTNGP09.phx.gbl:

There is nothing "running" on the server. The file is simply being
accessed across the network. To do what you are asking, you would need
a database program running on the server that you could send request
to, such as SQL Server.

Or MSDE, the free stripped-down 5-concurrent-user version of SQL Server
that comes with Office 2000 and many other products. An excellent
replacement for an MDB backend in many environments.