-----Original Message-----
Speed Ferret is a useful 3rd Party tool which will search out all instances
of a string (e.g. a table name) and change it everywhere - form
recordsources, queries, code, etc.
It's not free, but it works great!
There are no set limits on users and db size for an Access database.
I've had 100 concurrent users on an Access database without affecting
performance, but have heard of problems with as few as 4 or 5.
It depends on a lot of things - database design, esp. query design, type of
use (read or write), heaviness of traffic (are users interacting with the db
continuously, or in "spurts").
As for db size, a single Access database can be up to 2 GB.
The front end should be split from the back end (tables) and if necessary
individual tables can live in separate databases.
I think most developers would get concerned, though, if a back-end db got
much bigger than 1 GB and was still growing - it's far better to be
proactive than reactive.
HTH
- Turtle
.
