Second Query Question

  • Thread starter Thread starter Matthew Braumiller
  • Start date Start date
M

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!
 
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.
 
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.
Click to expand...

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.
 
Back
Top