Rename tables + db size

[Benn Vosloo]

I want to import our existing db into SQL server. The
person that made the db 18 months ago put : in the table
names. I can import the data but when I try to replicate
in SQL it will not accept the :. Is there a way I can
change the names of the tables without rendering the db
useless? If so, how?

P.S. What is the max amount of users that should work on
an access db and what is the max size the db can be before
I should concider SQL or another db program?

 

[MacDermott]

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

 

[Benn Vosloo]

Can I rename the tables with the trail copy as I would
only need to do this once and don't want to buy the
package just for that?

 

[MacDermott]

Not reliably -
the trial version blanks out every other line.

Let me guess, though, that you make at least $20/hour.
Would 10 hours really be enough for you to be *sure* that you've taken
care of everything related to the renaming?

I've heard of other renaming tools - you can spend some time on Google
searching - but I've been happy enough with Speed Ferret that it's been well
worth the price for me.

HTH
- Turtle

 

[Larry Daugherty]

There is also a shareware utility named Find and Replace from Rick Fisher.
I believe the link is www.rickworld.com If not you can google search on
his name or names like rickworld.

The shareware version is fully functional but I register it to encourage
Rick to keep improving it.

HTH

 

[John Nurick]

I've been happy enough with Speed Ferret that it's been well
worth the price for me.

Agreed: it paid for itself in time saved the first day I used it.