I work for a hospital support team and have created Access databases with a SQL back-end for our department. I have no control over the SQL. Here is my issue. Onsite, my database is average to good speed. The other users are much slower than mine. Using Cisco to connect from offsite, we get the same problems, with 2 of the users not being able to even open their front-end. It could be the way each was setup.
I connected to the SQL DB through my front-end via an ODBC connection. I then made a copy for each of the users (5). On each station I would connect to the SQL DB using the same connection method. As I made updates, I would export them to the other databases; forms, tables, queries, etc. Occasionally, I would replace the whole database by copying mine over to their respective folders and replacing theirs. My speed has been constant. Theirs seems to keep getting slower.
I have a suspicion that my replacing their original database has caused some confusion with that SQL connection and is the reason theirs is slower. Can anyone address this issue.
Thank you.
I connected to the SQL DB through my front-end via an ODBC connection. I then made a copy for each of the users (5). On each station I would connect to the SQL DB using the same connection method. As I made updates, I would export them to the other databases; forms, tables, queries, etc. Occasionally, I would replace the whole database by copying mine over to their respective folders and replacing theirs. My speed has been constant. Theirs seems to keep getting slower.
I have a suspicion that my replacing their original database has caused some confusion with that SQL connection and is the reason theirs is slower. Can anyone address this issue.
Thank you.