which database should I use?

[johnmerlino]

I would to have a database that:
• stores all the property addresses and names in all counties in only a single state, so efficiency is a factor.
• allows for multiple people to access the database at the same time and make changes to it.
• is installed on multiple computers, so price is a factor
• has a relatively small learning curve
• is compatible with excel, since a lot of calculations to manipulate strings (e.g. addresses) is necessary before info is imported into database, UNLESS the database has similar functions like excel to manipulate content, such as splitting addresses based on spaces or delimiters and being able to compare and match two files of content and do something if there's a match
• has the ability to import columns from excel and translate them into fields, if the fields do not exist, and if they do, then to update the value of the fields
• has some kind of ability to measure success of a marketing campaign

Does anyone know of a database that best suits these needs?

Thanks for response.

[ajetrumpet]

what is the purpose of this post John? obviously you know this is an Access forum. what kind of response are you expecting to get?

one answer - access can do everything you've mentioned...e.g. - access suits your needs just fine.

[johnmerlino]

Is it easy to use MySQL with Access rather than JET and would there be some setback or unintended cost involved?

[ajetrumpet]

Is it easy to use MySQL with Access rather than JET and would there be some setback or unintended cost involved?

no, mysql is free, but you have to pay to get your domain hosted. I'm not that familiar with mysql as far as integrating it with other front end systems like Access, but as far as I know there is no cost in using it.

as far as coding the schema request in it though, I've used PHP and I've heard that PHP is the easiest to use when you're trying to make requests through the database.

As far as the ease of using it with Access, I don't know what you mean by that. As far as I know, JET is for Access exclusively, so nothing is easier than using that because you have no leg work to do. Not sure what you meant by that.