sharing?

[bpaquette]

So before i release this onto the server for all 7 of my users, i'm curious, how will it perform?


i'm running access 2000 and everyone uses either XP or win2k. generally at any given time 5-7 people will be manipulating one form, and possibly generating queries/reports/etc. there's not too much background processing going on, so that shouldn't bog it down.

will the performance of the DB be hindered noticeably ? i dont know enough about shared databases to anticipate, unfortunately :\

 

[Autoeng]

If your users will be generating queries and reports then you definately want a split db. There have been many threads on splitting db's as well as distributing split db's so use the search capability.