I hope that somone can give me some advice / help.
I have got an old database that is on it's last legs and is threatening to fall over any day.
I have also got a stable database using SQL. What I want to do is use the stable database as a front end to store the information.
My problem is that the stable database is not designed to store the same information as the dodgy dbase.
The solution is to store some information in the stable database and the information that cannot be stored put into a seperate excel spreadsheet so that it can be added when a new database is created.
The stable database is capable of producing a word report, pulling in key fields. I then want to use this report to populate the additional spreadsheet. The fields will need to be drop-down menus or free text. Once this information is entered the form is printed and faxed - I then also want the data to be saved automatically for later.
Any ideas..?
cheers
Vis
I have got an old database that is on it's last legs and is threatening to fall over any day.
I have also got a stable database using SQL. What I want to do is use the stable database as a front end to store the information.
My problem is that the stable database is not designed to store the same information as the dodgy dbase.
The solution is to store some information in the stable database and the information that cannot be stored put into a seperate excel spreadsheet so that it can be added when a new database is created.
The stable database is capable of producing a word report, pulling in key fields. I then want to use this report to populate the additional spreadsheet. The fields will need to be drop-down menus or free text. Once this information is entered the form is printed and faxed - I then also want the data to be saved automatically for later.
Any ideas..?
cheers
Vis