LincolnMarkV
Programmer
Here is my issue of the day...
I have a BE/FE Setup using Access 2000. The front end is a MDE and the back end is MDB. I have implemented many of the great suggestions found here for security and crash prevention. I work for a non-profit and funds are tight to say the least. They want a full-scale commercial level product without opening their pocketbook. I do not have access to a server and I have an additional workstation on the network acting as a server. The system is NT4.0.
The problem with this is that only ten remote users can log in at once. I have a staff of 20-25, big problem. I have implemented a feature to AutoLogout folks who are inactive for the DB and tweaked the registry on my "server" to disconnect inactive users.
This database is accessed over the network by two remote locations and the mainoffice. The remote machines are terribly slow and need to be improved.
Any advice on the speed for the remote locations and the # of users would be greatly appriciated. Also, should I upgrade to MySQL or any other products?
Thanks,
Dave
PS...Thanks to all the people who post. I have taught myself through the info I have learned here. The books and MS website are pointless.
I have a BE/FE Setup using Access 2000. The front end is a MDE and the back end is MDB. I have implemented many of the great suggestions found here for security and crash prevention. I work for a non-profit and funds are tight to say the least. They want a full-scale commercial level product without opening their pocketbook. I do not have access to a server and I have an additional workstation on the network acting as a server. The system is NT4.0.
The problem with this is that only ten remote users can log in at once. I have a staff of 20-25, big problem. I have implemented a feature to AutoLogout folks who are inactive for the DB and tweaked the registry on my "server" to disconnect inactive users.
This database is accessed over the network by two remote locations and the mainoffice. The remote machines are terribly slow and need to be improved.
Any advice on the speed for the remote locations and the # of users would be greatly appriciated. Also, should I upgrade to MySQL or any other products?
Thanks,
Dave
PS...Thanks to all the people who post. I have taught myself through the info I have learned here. The books and MS website are pointless.