If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access and servers question
I am getting resistance to using Access databases at work because some
people who I believe don't know what they are talking about. I am told that when Access runs a query from tables on a server(split database)it pulls all of the data back to the front end then querries it, therefore using a lot of bandwidth. If this is true, is there a way around this feature. I would appreciate any comments on this subject. I really appreciate all you people do to help us out here who are in the "I don't know level". TIA Pat -- Lord, walk beside me always with your arm around my shoulders and your hand over my mouth! |
#2
|
|||
|
|||
Access and servers question
On Wed, 7 May 2008 16:51:06 -0400, "Dupatt" wrote:
I am getting resistance to using Access databases at work because some people who I believe don't know what they are talking about. I am told that when Access runs a query from tables on a server(split database)it pulls all of the data back to the front end then querries it, therefore using a lot of bandwidth. If this is true, is there a way around this feature. I would appreciate any comments on this subject. I really appreciate all you people do to help us out here who are in the "I don't know level". TIA Pat That is a very common assertion and it is (almost always!) WRONG. If you have Indexes on the fields being searched, Access will retrieve only the index (much smaller than the table), and only those records (or 2048 byte pages) containing records which match the criteria in the query. If you search fields that don't have indexes, or use criteria which can't use indexes such as LIKE "*" & [Enter criteria:] & "*", or apply critera to calculated fields then yes, it will do a full table scan. So... don't! -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Access and servers question
Thank you very much for your help......I should also have asked if data
entry through forms and viewing files in the form cause band width problems? I love Access and hope to be able to convince that is is not counter productive to run small databases on the server. Again thank you. Pat -- "John W. Vinson" wrote in message ... On Wed, 7 May 2008 16:51:06 -0400, "Dupatt" wrote: I am getting resistance to using Access databases at work because some people who I believe don't know what they are talking about. I am told that when Access runs a query from tables on a server(split database)it pulls all of the data back to the front end then querries it, therefore using a lot of bandwidth. If this is true, is there a way around this feature. I would appreciate any comments on this subject. I really appreciate all you people do to help us out here who are in the "I don't know level". TIA Pat That is a very common assertion and it is (almost always!) WRONG. If you have Indexes on the fields being searched, Access will retrieve only the index (much smaller than the table), and only those records (or 2048 byte pages) containing records which match the criteria in the query. If you search fields that don't have indexes, or use criteria which can't use indexes such as LIKE "*" & [Enter criteria:] & "*", or apply critera to calculated fields then yes, it will do a full table scan. So... don't! -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Access and servers question
"Dupatt" wrote in
: I love Access and hope to be able to convince that is is not counter productive to run small databases on the server. What do you mean by "run small databases on the server"? Access doesn't run on your server at all, in fact. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#5
|
|||
|
|||
Access and servers question
I guess my question was not correctly presented. Try again. I hope to be
able to convince my IT supervisor that is is not counter productive to run small split databases with 3 or 4 tables, maybe 50,000 recordsets, backend on the server; being accessed by 3 or 4 users with the front end on their computer. I hope you can make sense of that. Thanks for your reply. -- Lord, walk beside me always with your arm around my shoulders and your hand over my mouth! "David W. Fenton" wrote in message .89... "Dupatt" wrote in : I love Access and hope to be able to convince that is is not counter productive to run small databases on the server. What do you mean by "run small databases on the server"? Access doesn't run on your server at all, in fact. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#6
|
|||
|
|||
Access and servers question
On Thu, 8 May 2008 00:24:40 -0400, "Dupatt" wrote:
I guess my question was not correctly presented. Try again. I hope to be able to convince my IT supervisor that is is not counter productive to run small split databases with 3 or 4 tables, maybe 50,000 recordsets, backend on the server; being accessed by 3 or 4 users with the front end on their computer. One of my clients is running a database with 73 tables, 240,000 records in the largest of them (and several tables over 100000), twelve to twenty concurrent users. Split app of course with each user having their own frontend. Your proposed database is VERY practical for Access. If your IT supervisor would like to contact me directly I'll be happy to discuss. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Access and servers question
Thank you very much. My IT supervisor has a control issue and he does not
like Access(probably because he knows nothing about it). He says we have stressed bandwidth now (which is true)and MS Access would over load the lines. He would never consult with anyone and have to admit he was wrong, but thanks for the offer. You guys are great, keep up the good work. Pat -- Lord, walk beside me always with your arm around my shoulders and your hand over my mouth! "John W. Vinson" wrote in message ... On Thu, 8 May 2008 00:24:40 -0400, "Dupatt" wrote: I guess my question was not correctly presented. Try again. I hope to be able to convince my IT supervisor that is is not counter productive to run small split databases with 3 or 4 tables, maybe 50,000 recordsets, backend on the server; being accessed by 3 or 4 users with the front end on their computer. One of my clients is running a database with 73 tables, 240,000 records in the largest of them (and several tables over 100000), twelve to twenty concurrent users. Split app of course with each user having their own frontend. Your proposed database is VERY practical for Access. If your IT supervisor would like to contact me directly I'll be happy to discuss. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Access and servers question
"Dupatt" wrote in
: My IT supervisor has a control issue and he does not like Access(probably because he knows nothing about it). He says we have stressed bandwidth now (which is true)and MS Access would over load the lines. Your IT supervisor is an ignorant fool. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#9
|
|||
|
|||
Access and servers question
On 10 May 2008 01:45:15 GMT, "David W. Fenton"
wrote: My IT supervisor has a control issue and he does not like Access(probably because he knows nothing about it). He says we have stressed bandwidth now (which is true)and MS Access would over load the lines. Your IT supervisor is an ignorant fool. Ignorant, certainly - but in very numerous company. IT departments in general are ignorant (sometimes willfully ignorant) of Access; and often they do have an attitude that "all your data are belong to us" and only WE can dole it out to you, even if you created the data in the first place. Easy user-driven development tools like Access are a real threat to those who would maintain tight control over all data. -- John W. Vinson [MVP] |
#10
|
|||
|
|||
Access and servers question
"John W. Vinson" wrote in message ... On Wed, 7 May 2008 16:51:06 -0400, "Dupatt" wrote: I am getting resistance to using Access databases at work because some people who I believe don't know what they are talking about. I am told that when Access runs a query from tables on a server(split database)it pulls all of the data back to the front end then querries it, therefore using a lot of bandwidth. If this is true, is there a way around this feature. I would appreciate any comments on this subject. I really appreciate all you people do to help us out here who are in the "I don't know level". TIA Pat That is a very common assertion and it is (almost always!) WRONG. If you have Indexes on the fields being searched, Access will retrieve only the index (much smaller than the table), and only those records (or 2048 byte pages) containing records which match the criteria in the query. If you search fields that don't have indexes, or use criteria which can't use indexes such as LIKE "*" & [Enter criteria:] & "*", or apply critera to calculated fields then yes, it will do a full table scan. So... don't! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|