G
Guest
I currently have a database that that is used by 4 users over a network. The
four users are connected via winterms. The database is being accessed by
these users simultaneously and each user has his own form that he updates.
Each form also has a sub form and all the data is stored in two tables. The
database isn’t split due to the winterm issue.
The problem is that every so often the network starts to slow down and my
database becomes corrupt. Sometimes just the relationships are deleted and
other times I have to restore a backup copy. Our IT department insists that
the problem is with the database but I feel it is the network. We also have
the same problems with excel and other programs that we use. The IT guys tell
me that Access isn’t meant to be used for multiple users and this is the
problem. The database is in .mdb form and is stored on our local network. IT
tells me that we do have a SQL server available but say this would not help
the problem. Currently they are wanting me to convert my database and use
Infopath which I am hesitant to do. I am told that the reason this is wanted
is because it is more user friendly and can reside on the SQL server. I
guess I want to know what does it take to run a database from a SQL server
and do you think this would help? My data base is simple to use and the
reports are important in our production facility. Any advice would be
appreciated.
four users are connected via winterms. The database is being accessed by
these users simultaneously and each user has his own form that he updates.
Each form also has a sub form and all the data is stored in two tables. The
database isn’t split due to the winterm issue.
The problem is that every so often the network starts to slow down and my
database becomes corrupt. Sometimes just the relationships are deleted and
other times I have to restore a backup copy. Our IT department insists that
the problem is with the database but I feel it is the network. We also have
the same problems with excel and other programs that we use. The IT guys tell
me that Access isn’t meant to be used for multiple users and this is the
problem. The database is in .mdb form and is stored on our local network. IT
tells me that we do have a SQL server available but say this would not help
the problem. Currently they are wanting me to convert my database and use
Infopath which I am hesitant to do. I am told that the reason this is wanted
is because it is more user friendly and can reside on the SQL server. I
guess I want to know what does it take to run a database from a SQL server
and do you think this would help? My data base is simple to use and the
reports are important in our production facility. Any advice would be
appreciated.