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

MS access on a network

P: 6
I have inherited an ms access application for maintenance work, I have only coded cobol mainframe previously. The Access application is linked to tables on sql server with ODBC. Can several users access the one ms access application on the network or must each workstation be installed with the app.
Nov 18 '06 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,418
It depends of your application!

In certain cases when there is a few data and not complicated queries and reports that are modified in function of current user you can use the same app for all users...

But if it is a powerful system i can't belive that one copy can do the work well!

So if it is big application do a copy on each computer...

Also for big applications you can place some user data on local machine to accelerate the connections and exchange of information in the network...

Remember that less network charge, fast queries, fast execution, better performance!

But in the network it isn't the case!

So for big application i suggest you to place the Access application on each computer!
Nov 18 '06 #2

P: 6
Many Thanks
Nov 18 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.