Adding feature to old MS Access Project
Posted: Thu Aug 06, 2009 4:25 am
Hello Friends,
I have a unique small project in my hand. I developed a payroll system for a manufacturing company about 10 years back. This application was developed with MS Access both back end and front end
This project is still running with lots of data. Now, this company wanted to add some small features and reports to this app (for a negligible payment).
Now, I don't work on Access now. So, I decided to add these small features with HMG.
I saw some topics about Access database in this forum. Those are very helpful.
Now I want to:-
1) Create table in the database, if this table doesn't exist within the database.
2) Create forms which can update data in the tables.
3) Create specific report (Bonus Register and Bonus Pay Slip)
Should I use ODBC for this purpose or use ADORDD? Which method will be easier?
Can anyone have an idea how to start with
TIA.
With best regards.
Sudip
I have a unique small project in my hand. I developed a payroll system for a manufacturing company about 10 years back. This application was developed with MS Access both back end and front end
This project is still running with lots of data. Now, this company wanted to add some small features and reports to this app (for a negligible payment
).Now, I don't work on Access now. So, I decided to add these small features with HMG.
I saw some topics about Access database in this forum. Those are very helpful.
Now I want to:-
1) Create table in the database, if this table doesn't exist within the database.
2) Create forms which can update data in the tables.
3) Create specific report (Bonus Register and Bonus Pay Slip)
Should I use ODBC for this purpose or use ADORDD? Which method will be easier?
Can anyone have an idea how to start with
TIA.
With best regards.
Sudip