Looking for a Windows-based program

[Bellegarath]

I work for a health insurance broker who deals with about 10-20 insurance companies & all of their products. I'm looking for a program that can handle a large database of the companies & ALL of their products & features . It needs to be able to do comparisons of different companies & print 3 products on a page. The program we currently use someone created and it doesn't lend itself well to being run on newer systems. Can anyone help? We use Windows XP software on Windows 2000 OS. Come to think of it, it doesn't have to be windows-based, just windows-friendly. Thanks!

 

[Drakkon]

Access and VB are all you would need...find urself a decent VB programmer that knows how to integrate with Access DB's...pay him a few hundred to develope a program...shouldn't take too long...what your asking for is fairly simple and stright forward...

 

[jonmullen]

Second the Access VB idea

 

[Bellegarath]

Okay, you can tell I'm a novice: What is VB?

 

[MrChad]

VB = Visual Basic

 

[RayH]

SQL Server 2000 and a 3rd party front end tool like Hummingbird BI Query.

 

[Bellegarath]

Thanks, guys for the suggestions! I'll see what I can do.

 

[Bellegarath]

Wait a minute, Ray H. I just saw your suggestion - what the heck is that? We don't have a server but we have a network. Will that work?

 

[Codewiz]

Originally posted by: Bellegarath
Wait a minute, Ray H. I just saw your suggestion - what the heck is that? We don't have a server but we have a network. Will that work?

SQL Server is a database application. I doubt you need all the functionality of SQL Server.

 

[RayH]

SQL Server typically runs on a dedicated server but can run on a client pc. I guess some questions to ask is how big is the database going to be and how many people are going to access it?

 

[Bellegarath]

There will be 160 plans and 20 categories in the database & we need to be able to pick & choose from both. There'll only be 2 of us accessing it. Will this work on a 2000 OS with XP programs?

 

[RayH]

Sounds like the database is small enough that you can just use Access. If the database was going to be a couple hundred MB or larger than I'd consider SQL Server.

 

[Bellegarath]

Looks like I'm getting Access. Thanks everyone for your help!

 

[Nothinman]

There's also MSDE, which is SQL Server for desktops essentially. I'm not sure what all the limiations are but it's probably worth looking into as Access's mdb files are ass.