Brad Smith wrote: >At present, I am using the DBI module to open Access databases. As >the databases are rapidly growing, the performance is decreasing >greatly. > Rewrite your queries perhaps? Index tuning?
> >If you had the following alternative options, which one would you >choose? >1. MS SQL Server with corresponding MS SQL driver. > There are tools to upgrade from JET (Access) to SQL Server. MSDE (SQL Server Desktop Engine) is free (sort of). You can manage MSDE from Access. >2. MySQL Server with MyODBC driver. >3. MySQL Server with MS SQL driver. > >Thanks in advance for offering advice. I don't know enough about how >each of these servers and drivers compares. > Access is basically a single user db. I wouldn't blame the driver. > >Sincerely, >Brad Smith > > > >
