Help with DAP (data access page) and MS Office Web Components 3

[Focusfocs]

Hello,
I've just got my very first DAP (data access page) up and tentively going (access 2003)..it works just great if I am at work, but when I try to enter in data remotely I am having an error
-- Microsoft Office Web Components could not open database

"databasename"--
Would anyone know why this would be? I have everything that is required of the page...does the database need to be open on the network for it to be updatable?
TIA

 

[Slippenos]

It sounds to me like you wrote the DAP in Web Components 10.0 (Comes with Office 2003). 9.0 Comes with Windows Office 2000. There is no backwards compatibility between the two. You can only read and write with 10.0.

Let me know if this helps.

 

[FancyPrairie]

Slippenos, is correct concerning the fact that DAP created with Access 2003 uses the OfficeXP web components (owc10.dll) rather than the Office 2003 web components (owc11.dll). If you installed the standard version of Office 2003, you don't get the OfficeXP web components. However, if you install Office 2003 Pro, you do receive the OfficeXP web components.

Note that Access 2003 adds some code to you DAP the checks to see if the web components are installed. If not, it will attempt to install them. However, for me anyway, the code that Access generated attempted to install the Office 2003 web components (owc11.dll) and not what it needed (owc10.dll).

Another thing you might want to check is your Internet (or Intranet) security settings. If you don't have the right options enabled (i.e. ActiveX controls) you could receive the message you are receiving.

 

[fneily]

This may be of some use to you. It's a microsoft article on how to Distribute DAP's across the Internet.

http://support.microsoft.com/?kbid=264080

 

[Focusfocs]

Thank you all so very much. You granted me much needed and very useful information. Thank you for taking the time to write!