Hello,
I inherited a Microsoft Access 2003 database project. This was created a few years back by business users in Microsoft Access 2003. They have created several data access pages using the wizard to display data from MS Access 2003.
Now we are looking to take these data access pages and point them to SQL Server 2008. Take the generated HTM files and put them on a web server so it is completely independant of MS Access.
I have successfully changed the connection string to look at the data in SQL Server 2008. But the data access page form behavior is different. Is it possible to host these DAP pages out on a Windows Server (seperate from Access)? Or do these forms need to be rebuilt from the ground up if we want to elimate the MS Access dependancy?
Our plan is to re-write this in ASP.NET, but we'd like to host the pages on a web server and connected to SQL Server as something they can use until the app is re-written in ASP.NET. Any feedback would be greatly appreciated.