I have very small database on network where I work. The server is located in a different state in the US and four adjacent states have access to it.
When only one person is using the database it works a ok speed. But when two or more people use the database, the forms and reports take 30 secs to 3 mins to load.
What are some of the things I might look for to improve?
The database is not split and is about 4MB in size.
When only one person is using the database it works a ok speed. But when two or more people use the database, the forms and reports take 30 secs to 3 mins to load.
What are some of the things I might look for to improve?
The database is not split and is about 4MB in size.