Hello Jerry,

Access can use Excel as data source with no problem. VBA allows data to be exchanged between the programs. As for the question about simultaneous running of the macro, they shouldn't be a problem if each user is only updating their information. If the database is on a network drive, be sure the users are given the proper access privileges.

Sincerely,
Leith Ross