I am posting this message on both SQL and Access Boards.
We currently have an application that has access forms and an access database, sits on a server, and has multiple users accessing it. Now due to various things(mostly caused by brief outages), we have alot of coruption on the Access Database and have to continually repair.
Now, the vendor has a SQL version of this same software, however, I do not know for sure yet if it has access forms for a front end.
Anyways, I guess my question is, can an access application on a server with multiple users cause a SQL Database to become corupt for the same reasons as an Access database would?
Can anyone tell me if there are any limitations/problems to an Access Front End/SQL Database?
Thanks. Any help would be appreciated.
We currently have an application that has access forms and an access database, sits on a server, and has multiple users accessing it. Now due to various things(mostly caused by brief outages), we have alot of coruption on the Access Database and have to continually repair.
Now, the vendor has a SQL version of this same software, however, I do not know for sure yet if it has access forms for a front end.
Anyways, I guess my question is, can an access application on a server with multiple users cause a SQL Database to become corupt for the same reasons as an Access database would?
Can anyone tell me if there are any limitations/problems to an Access Front End/SQL Database?
Thanks. Any help would be appreciated.
