I have a few DAPs that I created but I really need to get the database and everything of my "local" drive and moved to the Network drive. However when I copy the .mdb and ALL the HTML files associated to the DAPs I open the DAP and the database connection is gone. I then have the DAP connect to the database but it wont save the setting. This is Access 2000 in case you need to know. Is there a different way to copy all of this that im missing? I tried importing the page too but when I do and mouse over the DAP it still point to my C:\My Documents location. Any ideas?

Hi kalebson,

You need to change the connection string for the page. To do this you can right-click on the DAP name, and select Properties. Change the path to point to your network drive. Also, open the page itself and right-click anywhere on the page. Choose Page Properties, select the Data tab, and edit the ConnectionString.

I hope this helps.

You mean do this from within the database window right? Because if you are I dont get that option.

I do not see anything that says "Page Properties" I have "Properties" but its not editable.I also do not have a connection string option on the page in design view. It seems to be connected to the correct database however the page itself does not. The page says C:\...My Documents..\ when I mouse over it. I see no option to changing the location to where it points. Am I maybe missing some setting?

Kalebson,

What version of Access are you running? Also, yes I do mean to change the connection string from within the db. What you have to do is open your page in design view. Right-click anywhere on the page. You should get an option for Element Properties, Group Properties, and Page Properties. Page Properties is what you want to change. Once you open the Page Properties window, you need to select the Data tab. If these options do not appear when you right-click the page, try using the File menu, and then select Page Properties. One more question. Is your database running on a web server. If so, you need to be sure that the web server is running IIS, not Apache. I ran into this problem early in my project. You also need to ensure that Microsoft Web Components are running. Once you have your pages up and running, you need to make them a Trusted Site, under your Internet Explorer Internet Options. You'll also need to enable ActiveX controls. All of this is done in IE under the Internet Options Security tab.

I hope this helps you, because when I first began my project I posted numerous messages, and no one helped me!

Iashia

I submitted this problem a while back and I had since moved to other projects and have now come back to this issue and thought since last time maybe the issue was unclear that I might clarify with some screenshots that might help get me a solution to this issue...I dont know any other way to explain this other than it seems that my DAPS lose connection to my dB once I save them. I can do anything I want to them until I save and reopen as you will see in the SS's..here goes..

-I create a simple DAP w/ the wizard this is the result:
http://img.photobucket.com/albums/v6...son/create.gif

-It looks like this in the normal view...still good here..
http://img.photobucket.com/albums/v6...ftercreate.gif

-Then I simply save it...
http://img.photobucket.com/albums/v6...savedasDAP.gif

-Now lets reopen and see what happens...
http://img.photobucket.com/albums/v6...n/reopened.gif

Well...where did it all go? Thats what I cant seem to figure out. All attributes are now set to hidden and there is no data connection as you can see here...

http://img.photobucket.com/albums/v6...fterreopen.gif

I have tried reconnection to the dB in this screen but it makes no difference once I reconnect the page is dead and the data does not come back...Has anyone ever seen this before?..This is Access 2000 w/ SP3...When I originally posted I still only had SP2..thought maybe that might be it..but it wasnt.

I can say that I am certain that the original installation of Office 2K was done thru the network and not directly from a CD.

One thing I did notice which was the only difference from creating a DAP on my machine and creating one my other PC was actually in the View Source portion in Web View...here is the portion of HTML from the pages created on 2 diff machines that seem to not match:

Created on my PC:

<OBJECT id=MSODSC codeBase=file:D:\msowc.cab
classid=CLSID:0002E530-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a=&quot;urn:schemas-microsoft-com:office:access&quot;>

Created on a different PC:

<OBJECT id=MSODSC codeBase=file:msowc.cab#version=9,0,0,3821
classid=CLSID:0002E530-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a=&quot;urn:schemas-microsoft-com:office:access&quot;>

This is the same page on the same dB saved to the same location...However this one never stops working. I hope this is clear and understandable..any help would be great ...TIA