multiuser update of database

[Gerry]

Hi Al. The company I work for has a guest list. It can be accesed from
several workstations. The problem is that we are using excel not nad only one
user can be updating at a time. is there a way that multiple users can be
entering info at the same time and after it is entered all the other open
screens will either refresh with teh new data of be prompted to do so???
Thanks

 

[Jeff Boyce]

This newsgroup supports the use of MS Access, the relational database.
Please post to an Excel-oriented newsgroup.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Dale Fye]

You could create an Access application that allows multiple users to access
the data at one time, although actually updating a linked Excel file requires
coding. I'd move the data into an Access table located in a database on your
network.

Then create an Access application that links to that data.