Access web database vs Zoho?

[Delta223]

Hi,

I'm looking to create an online database where my online staff can enter data from the web into the database simultaneously via forms, run reports, and download information into csv files.



Zoho seems ideal but costs a lot of money for the amount of records it allows. Past 100,000 records (cumulative, not per month) I believe they charge $200 a month.

Access web database seems interesting but I could never figure out how to set up a sharepoint server; I'm just not that technical. But their new Office 365 package seems to be able to handle the web configuration out of the box.

Do you guys believe Access web databases are a good solution for simultaneous use? I need frequent updating of the database to protect against 2 people entering the same information into the database without a duplicate notification triggering due to lag

[June7]

Why would 2 people be entering the same information? These users are not on internal network?

[Delta223]

That is correct; I employ virtual assistants who do web research & data entry, so duplicate entries are a concern. Are access web databases good for this purpose, or should I go with Zoho?

[June7]

What do you mean by 'duplicate' entries? Not sure anything could prevent users from entering multiple records like:

ID Comment
1 Account 345 cancelled
2 Account 345 cancelled

[Delta223]

Zoho has validation rules that prevent records like that from being created. Not sure about Access but I thought it would since it's fairly basic; even excel can highlight duplicates using conditional formatting.