PDA

View Full Version : A question for someone involving networks (preferably Windows) plus an MS Access Q


ReaperFett
Feb 26th, 2004, 10:32:07 AM
Okay, I know that on a network an Administrator can disable certain features from use by other accounts. My question is, could he do it so that EVERYTHING is disabled except for opening icons on the desktop, using them and logging off?


EDIT - Also, an MS Access question. Would a database with thousands of entries be significantly slower than one with few entries?
TheHolo.Net
Feb 26th, 2004, 11:17:03 AM
Yes.

Yes.
ReaperFett
Feb 26th, 2004, 11:50:30 AM
1 - Yay! :)

2 - Darnit! Time to think how to cut down a DB I can't delete data from :(
TheHolo.Net
Feb 26th, 2004, 11:53:32 AM
The second answer is dependant on the complexity of the queries. If the queries are simple single lookup ones then there would be little slowdown.
ReaperFett
Feb 26th, 2004, 11:57:08 AM
It would basically be me in Visual Basic saying "Show everything in the loans archive" or "Search for this in the loans archive".
TheHolo.Net
Feb 26th, 2004, 11:58:38 AM
Then it shouldn't be too terribly slow really. Access is supposed to be very quick for simple lookups.
ReaperFett
Feb 26th, 2004, 12:04:16 PM
Aha, excellent. Thanks :)
ReaperFett
Feb 26th, 2004, 03:17:20 PM
Ooh, another thing. If you had one table within a database which was large, would it slow down the others?
Mu Satach
Feb 26th, 2004, 08:58:06 PM
not really

your performance factor is going to depend more on your query than the size of your table

I've got a little access database with several small tables and one large table with over 100,000 entries and it's only slow when I want a list of "everything" in that table.