By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,846 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,846 IT Pros & Developers. It's quick & easy.

Multiple Users.

P: 5

I've just started work with a new firm and as I know how to turn on a computer, they assume I am a programer. I know enough to get myself started and this forum helped alot... However. I must create and migrate an Excel database (No maxed out) into Access. My first of probably many questions to come is. How can you set up the database to accept multiple imput users at once.

What I mean is that in a call center environment, with case numbers assigned by "Autonumber" and multiple users inputing data at once (about 20), how to ensure that once a number is selected and while one user inputs data (about 10min) that the number is removed and the database will proceed to the next available number for the next user.

Thank You!
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 114
Access will do this automaticall. Just ensure that the "key" is entered.

If you really want to get around this don't use an auto-number at all. You can assign everyone a user ID and base the key of your table on that ID. It is quite easy to do and would have the added advantage of allowing you to see who it was entered the information initially. You can also put a "date/time stamp" on this to see when they where entered.

The command you need is CurrentUser in this case, search for my threads started on a topic like this and you will get the rest of the code you need.
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.