Hello all.
I have a database that many of you helped me develope by your problems and answers. I created a database that at first was supposed to be a single user application which now is residing on one of our servers.
My new task is to change the database to be a server application. When we put the database on the network we noticed a few problems. First the speed at which the database opens and returns data is very slow. Second every night our network is backed up. Some of our users forget to shutdown their PCs at night and stay logged into the database. When this happens the database becomes locked and gives an error that says the database is already in use. We must then go to our server and disable the connection in Administrative tools.
I do not know anything about how to speed up the database or where to look. My boss mentioned that we may be able to have apps on each user's PC that pulls data from the network Database and writes to it as needed.
I do not have any knowledge of Server Databases.
Any pointers would be helpful.
Thanks
Krash
Krash878@hotmail.com
I have a database that many of you helped me develope by your problems and answers. I created a database that at first was supposed to be a single user application which now is residing on one of our servers.
My new task is to change the database to be a server application. When we put the database on the network we noticed a few problems. First the speed at which the database opens and returns data is very slow. Second every night our network is backed up. Some of our users forget to shutdown their PCs at night and stay logged into the database. When this happens the database becomes locked and gives an error that says the database is already in use. We must then go to our server and disable the connection in Administrative tools.
I do not know anything about how to speed up the database or where to look. My boss mentioned that we may be able to have apps on each user's PC that pulls data from the network Database and writes to it as needed.
I do not have any knowledge of Server Databases.
Any pointers would be helpful.
Thanks
Krash
Krash878@hotmail.com