I've created an access database using the .adp and using the microsoft SQL server service manager (MSDE that came with office corporate). Also, I was using data access pages as my user interface.
Everything was working fine until I move the .adp files into a computer in a network setting then I'm getting error whether I was accessing it throu the data access pages or the .adp.
Errors that I'm getting are:
1. Data provider could not be initialized.
2. [DBNETLB][ConnectionOpen(Connect()).] SQL Server does not exist or access
Since I put the .adp in a networked computer, I thougth it would be the settings in the network. When I got home I've installed the servicepack 2 for MSDE and hoping that it would still work but unfortunately it did exactly the thing as in the office.
Well, I figure that everytime I change from one computer to another with there own MSDE installed have there own SQL Server and SQL server database name. So, those .adp database that I've created is expecting different SQL server name and SQL server database but since I've change the SQL Server Service Manager version or changed from one computer to another it found a different one. Therefore my .adp database wouldn't open.
So what can I do to fix this problem? I really need this database to work. Please help :-(