Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I would to have a database that:

1) stores all the property addresses and names in all counties in only a single state, so efficiency is a factor.

2) allows for multiple people to access the database at the same time and make changes to it.

3) is installed on multiple computers, so price is a factor

4) has a relatively small learning curve

5) 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

6) 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

7) has some kind of ability to measure success of a marketing campaign

Does anyone know of a database that best suits these needs? I don't mean something like PHP with a Mysql server. I mean something like Microsoft Access vs Act! vs Goldmine vs SugarCRM vs something else. Something that you purchase and comes with some degree of support. That is, something already designed and ready to be used with little programming knowledge.

Thanks for response.

share

migration rejected from superuser.com Jan 22 at 6:43

This question came from our site for computer enthusiasts and power users. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

put on hold as off-topic by HopelessN00b Jan 22 at 6:43

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

    
These kinds of questions are inevitably either too broad (rendering them into simple popularity polls) or too localized because they ask us to answer only for the OP's use case. This particular instance is worse than usual because conditions 7 is unrelated to the database and conditions 5 & 6 suggest that the OP has asked us to solve the intermediate problem instead of telling us what the really issue is (i.e. John has already decided on half his technology stack). Too localized. –  dmckee Oct 4 '10 at 17:19

2 Answers 2

I don't think you are going to be able to resolve all your issues by only using a DataBase. I would suggest PostgreSQL (free, performs very well, integrates very well with .NET, Python, Java, PHP, you name it) and deploying an application for your users with a programming language that suits your needs.

share

Sounds like you are likely to have a pretty small database without many users that needs to integrate with MS Office to some degree. and you don't have a advanced programming skill at the ready. Your best bet is probably MS Access.

share
1  
Would you recommend running Access as a front end (since this is something that needs to be done quick and it appears access is already a finished product as opposed to a php app which would need to be done from scratch) and Mysql as the backend - since the default Access database is extremely limited(think it's called ACE?) from my understanding? –  JohnMerlino Oct 3 '10 at 16:41
    
The Access Database engine (JET) is not extremely limited. It is more limited than industrial strength databases like SQL Server, Oracle, MySQL, etc., but for what he is describing it should do just fine and the backend can be ported to a larger platform if the project grows in scope later without much rework of the UI. –  JohnFx Oct 3 '10 at 16:45