Access Backend integrated with SQLServer
Posted on 2006-05-17
Wonder if I could get some of your opinions. I have a friend of mine who has two systems. One is system is based off of an Access Back-end and is currently used by some of the staff for day-to-day operations
They are also in the process of having a website developed by an outside company. Since some of the staff is very comfortable with the access program and to save on costs, they want to keep the internal application the way it is, instead of redeveloping the app in SQLSvr.
But, they would like to be able to integrate the Access data into the website's back-end which will be SqlServer. So, my idea was to create an in-between application, that would post the day's updates into some tables in the SQLSrvr back-end. But this would require that the app be able to use pull from both the Access Database and the SqlSrvr database in the same event, which I know requires two different types of DataAdapters/Datasets.
So, if anyone has any experience with this and knows it can be done, or has a better idea, I'd appreciate any input.