frank_spencer
New member
- Local time
- Yesterday, 18:22
- Joined
- Jun 9, 2007
- Messages
- 6
Hello, I would be very grateful if someone could please help with the following enquiry.
I have just moved over to using Access as the front end and MSDE as the back end. I have created a web application that communicates with the adp file and on the PC where it was created, everything works fine.
Yet, when I copy the .adp file to another PC (that has all necessary installations MSDE etc) I cant seem to open the adp file. I have even tried changing the PC name of the 2nd PC to ensure that the SQL server name is the same as on the PC where it was created.
However, the adp file still wont open. I have to go into university and demonstrate my file working on thier PC but I cant figure out how to change the adp file SQL server connection details.
When I try and change the adp file SQL server connection options, I cant alter the options already selected so the file only works on the PC where it was created.
All advice will be gratefully recieved, thanks!
I have just moved over to using Access as the front end and MSDE as the back end. I have created a web application that communicates with the adp file and on the PC where it was created, everything works fine.
Yet, when I copy the .adp file to another PC (that has all necessary installations MSDE etc) I cant seem to open the adp file. I have even tried changing the PC name of the 2nd PC to ensure that the SQL server name is the same as on the PC where it was created.
However, the adp file still wont open. I have to go into university and demonstrate my file working on thier PC but I cant figure out how to change the adp file SQL server connection details.
When I try and change the adp file SQL server connection options, I cant alter the options already selected so the file only works on the PC where it was created.
All advice will be gratefully recieved, thanks!