Thanks.

I had a backup from 3 days earlier. I chose to repair the db with data loss. I then restored the backup and found 2 payments that were...

Thanks, I had to go to the local group Remote Desktop Users and add the administrator.

So I have to upgrade server to Enterprise?

all 32 bit

Looks like SQL Express was the culprit. I upgraded it to SQL standard. It has been up for a week and no problems. Can't tell you how...

MS used to actaully throttle the performance of msde. With the release of R2 the db size increased to 10GB. I would think 50 users would be chump...

Thanks for the replies. Perhaps I will move it try it on standard edition. You think the 1GB RAM is limiting SQL's ability to handle that many users?

The...

SQL Express in not throttled. It does however have some limits. It only addresses 1GB of Ram adn 1 CPU and max db size is 10GB.

50 Users, the db is 250MB. The server is also a Terminal Server. All users Terminal in and run the Access app.