Need for Speed

[deetee]

Hi, I've got a multi-user database being used by around 40-50 people regulalary every day. The database is pretty big and there's some large calculations going on. The problem I've got is that it's really slowing down, some calculations use a couple of functions and 6 or 7 queries to get to the end product on a read only form. The result is that the form can take over a minute to load sometimes. Does anyone know how I could speed this up?

Cheers

 

[FoFa]

Switch to SqlServer.
Really.
You are past what we consider MSAccess as reliable.
Anything past 10 concurrent users (concurrent is all that matters) means something other than desktop DB.

 

[deetee]

thanks for the reply FoFa. I had a feeling SQL server might be the answer!

 

[Newman]

What exactly is SQL Server?
How do you switch to SQL Server?
How much faster is it?
Is there other options to SQL Server?
Thank you!