Hello all... Does anyone know how I might set up an application in Access so that multiple users can run it at the same time on a network? The problem is that there is an extract when the app opens that creates a table to be used later on and if more than one person opens the app at the same time, it causes issues. Both users can't write data to the same table at the same time through a make-table query. Is there a solution to this like a setting that will tell Access to wait if one user has the file already open when another is trying to work with it? Any help in this area would be greatly appreciated.
Glenn