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