IT Employment

Ask something
Discussion Locked

Database madness

0 helpful
4 replies

by vickik

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are a small company - we have an Exchange 2000 server, Windows 2000 servers, and host our own website. About 1 1/2 years ago we purchased ACT database in hopes that it would become the piece that would tie things together into history files for our clients but we have had some poor experiences with this database. We are currently using 4 different databases and re-entering the same data in each of these - user productivity is a mess since we are entering duplicate data - does anyone have a good solution for getting rid of databases?

4 replies

by captain krunch

You do not state your level of expertise so have you tried using Microsoft Access, you can link multiple dbs together and then use a VB front end processor to do the queries or you can go directly to an SQL db but you will have to develop a user interface that the clients can use to get teir results.

by vickik

I have used Microsoft Access and we had a very nice application built but I was not able to make it "synchronize" which is the big hype for ACT -
because the data can go to laptops and to PDA's -I am currently the webmaster and we are doing our web with a SQL server database and I would like to see us move everything to that so we could eventually web enable everything - but I am not as familiar with .aspx as I need to be so the cost of web enabling is high for us - and it needs to be accessible by everyone in the building without too much need of buying new software,etc. I think I could figure out how to make that happen without too much trouble. I just would like to hear how others are consolidating - because I think we have too many databases going.

by vickik

I do feel that I am pretty knowledgeable in Access - even though I could not figure out the "synchronize" thing - and I have learned quite a bit about SQL by way of necessity -

by realgem

I recommend MS SQL Server unless you only have a couple of users. These synchronization things can be complicated; I would take some formal training in your product, get some technical references, cruise forums, and look for someone who has done this before.

This discussion is closed to new replies.