Pool Master
04-22-2009, 05:22 PM
Hi Everyone,
I've dabbled in Access 2003 in the past, but I may be starting a project in the next couple of weeks that would require some things I'm not sure that Access can handle. It would be greatly appreciated if someone could confirm that Access will work for such a need.
The plan would be to design a Userform with Access with tables that store the various options available in the userform. I know that this works for 1 person, but my concern is that multiple users (20+) may be using the userform at the same time (example noted below). Will Access allow these users to utilize the same Userform and output the selected results to the same master table? Even perhaps at the same time? Could this cause issues with table locks or performance degradation? Does the master table have to exist in the same db as the useform and the tables that populate the userform?
Example: Userform has multiple list boxes and options to choose from. User selects "Apple" from a list box, and selects a qty of 2 from a option button. The user will then execute the macro which will string their selections and store them in 1 row of a master table.
Thank you very much for your time and patience with this question!
Adam E.
I've dabbled in Access 2003 in the past, but I may be starting a project in the next couple of weeks that would require some things I'm not sure that Access can handle. It would be greatly appreciated if someone could confirm that Access will work for such a need.
The plan would be to design a Userform with Access with tables that store the various options available in the userform. I know that this works for 1 person, but my concern is that multiple users (20+) may be using the userform at the same time (example noted below). Will Access allow these users to utilize the same Userform and output the selected results to the same master table? Even perhaps at the same time? Could this cause issues with table locks or performance degradation? Does the master table have to exist in the same db as the useform and the tables that populate the userform?
Example: Userform has multiple list boxes and options to choose from. User selects "Apple" from a list box, and selects a qty of 2 from a option button. The user will then execute the macro which will string their selections and store them in 1 row of a master table.
Thank you very much for your time and patience with this question!
Adam E.