Hi,
I have an application with a SQL server database and using VBA, also some temporary tables in Access. I need to make it working for being used by more than one user in the same time.My boss wants to have the entire database on a network server and everyone shares the data and uses the same forms, reports, queries, macros, and modules.
Is there something particular that I have to setup to allow more than one user to use the database at the same time? what I should modify?
how can I resolve the problem with these temporary tables?to block them when one user is working with them?
I have an application with a SQL server database and using VBA, also some temporary tables in Access. I need to make it working for being used by more than one user in the same time.My boss wants to have the entire database on a network server and everyone shares the data and uses the same forms, reports, queries, macros, and modules.
Is there something particular that I have to setup to allow more than one user to use the database at the same time? what I should modify?
how can I resolve the problem with these temporary tables?to block them when one user is working with them?