By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Second Query Question

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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!

Nov 12 '05 #2

P: n/a
"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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.