SQL and access

[Guest]

should we use SQL 2000 and access 2000 to run our data base we are only
running access 2000, but with plenty problems and very slow,

Thank You

 

[Allen Browne]

Changing the back end to SQL Server will generally not make your database
faster. In fact, it may make it slower.

There are some genuine reasons why you might want to change to SQL Server,
e.g. if you have millions of records, hundreds of simultaneous users, the
database must run 24x7, or security is very important.

For performance, though it is probably a matter if sorting out why it is
slow and what needs addressing. You could start with the Performance FAQ
written by Tony Toews:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Guest]

Chances are you (although there are a lot of factors) the database might not
be designed well. You may want to pay to have an Access Pro redesign it -
which would probably be a lot lot cheapier then moving it to SQL (assuming
you do not already own SQL).