Results 1 to 11 of 11
  1. #1
    bgarey is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    33

    Multiple Keyboards on form


    I want to have several people plugging in data on a form.
    I can have multiple keyboards hooked up to the computer. All work but there is only one cursor. So only one person can enter data at a time.
    Any way to get around this?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    In most multi-user databases, you would have a front end on each user's PC and a single back end database in a shared directory accessible by the front ends.

    Research multiuser database and split database.

  3. #3
    bgarey is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    33
    I know how to split data bases, but that won't work for this application and the users that are plugging in data.

  4. #4
    bgarey is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    33
    We only have one computer available for this project.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Please tell us more about the 1 computer. How do you plan on having multiple keyboards (operational simultaneously)?

    Any way to get around this?
    Have you considered sending the data(in whatever form your users have [paper/documents]) to a data entry service?
    I'm sure that isn't what you meant, but it must be a feasible option.

  6. #6
    bgarey is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    33
    The program is for voting in a school. We have about 1900 students voting. I have about 4 teachers that will plug in votes simultaneously to count the votes.
    Unfortunately our district server will not accept Office databases. That is why I can't split the data base.
    I can load the program on different computers, but that will add some problems because we have multiple votes, runoffs etc.
    I also have used bar code scanners. That worked, but we had so many errors that it slowed us down. So I decided to try multiple keyboards.

  7. #7
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    There is no way you're going to be able to handle multiple concurrent data entry on a single form on a single computer from multiple keyboards.

    In fact I do not think you could do it with ANY application at all, every windows based program I know of requires the the person doing entry (word processors, spreadsheets, etc) to have the cursor under their control.

    If you are truly not allowed to build a database that could be accessed from multiple computers and you are really only allowed to use one computer you are stuck with 1 data entry person. The only other thought would be to put the results into a text document, then import the results after the fact, or put them in a spreadsheet and import them after the fact.

  8. #8
    bgarey is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    33
    Thanks,
    I was afraid of that.

  9. #9
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You could set up a private LAN with 4 or 5 computers/laptops. A router (and maybe a switch for more ports) and 4 to 5 25 foot Cat-5 cables is all you would need.
    The router is the DHCP server (gives out IP addresses). Most routers have 4 or 5 ports. Plug in a switch and you can have up to 16 more ports.

    DO NOT use wireless - you will/can corrupt the dB.

    Have one of the computers host the BE and all computers have the FE linked to the BE.

    Don't know what you would do after entering the data.... print reports, export to a text file, ?????

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    But,Steve the original constraint was

    We only have one computer available for this project.

  11. #11
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Yea, well, a lot of people have laptops.... if they need is great for a short time, maybe they would use their personal laptops to get the job done.
    It was just an option to have multiple data entry people ......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-29-2015, 11:08 AM
  2. Replies: 7
    Last Post: 06-20-2013, 12:09 PM
  3. Replies: 5
    Last Post: 12-21-2012, 11:05 PM
  4. Replies: 23
    Last Post: 12-06-2011, 09:18 AM
  5. Replies: 1
    Last Post: 03-02-2009, 11:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums