A client needs a database system...

[5LiterMustang]

We have to build a database system for a client. I am not allowed to mention the client, but it must be able to store a couple hundred contracts and information of that nature. I think oracle would be overkill, something like access appears to be very feasible, however, access is not that great a system for building a database. What do you guys recommend?

 

[AgaBoogaBoo]

MySQL?

 

[ironcrotch]

Originally posted by: AgaBoogaBoo
MySQL?

 

[ggavinmoss]

Well how is the client supposed to interact with this data and what will it be used for?

-geoff

 

[AFB]

Originally posted by: ironcrotch

Originally posted by: AgaBoogaBoo
MySQL?

+ PHP web interface.

 

[KLin]

You can build a frontend within Access pretty quick. If it's just for contact info, I think Access is an adequate solution. BTW, WRONG FORUM.

 

[Landroval]

Originally posted by: ggavinmoss
Well how is the client supposed to interact with this data and what will it be used for?

-geoff

 

[PlatinumGold]

Originally posted by: KLin
You can build a frontend within Access pretty quick. If it's just for contact info, I think Access is an adequate solution. BTW, WRONG FORUM.

agreed, access front end, MSDE backend.

 

[5LiterMustang]

Originally posted by: PlatinumGold

Originally posted by: KLin
You can build a frontend within Access pretty quick. If it's just for contact info, I think Access is an adequate solution. BTW, WRONG FORUM.

agreed, access front end, MSDE backend.

Thats what we're leaning towards, but we're giving some thought to mysql...the system is used for contract tracking and notification of renewal and incomplete contracts. I can't specify what for I'm sorry but we had to sign confidentiality statements.

 

[AgaBoogaBoo]

I would look at what other open source projects are doing that might be similar to what you need to do. Sourceforge should be a good start, but also look at hotscripts.com

 

[5LiterMustang]

Originally posted by: AgaBoogaBoo
I would look at what other open source projects are doing that might be similar to what you need to do. Sourceforge should be a good start, but also look at hotscripts.com

cool thanks