Can I Use Data Access Pages

[Curben]

Hello all, I am back with the new project i have had thrown at me.

I need to make a DB with forms that are accessible by multiple countries on our network so this will not be "web based" per se.

I am using access 2003 with an access 2000 format.

I tried to make a data access page but once i save the page i get connection errors. The form itself when pulled up in IE shows, but there is no data. when i pull the page back up in design view I recieve the error:
"Cannot find the database or some objects that this page refers to. Update the connection information of the page or fix the reference to the missing database objects."

The path is correct and i have made no changes to any connection settings. This is not a web server but more of a shared PC that everyone uses to store documents as well as our general access DBs as well.

Can I use DAPs for what I am looking for, and if so, anyone have any ideas on where to start looking?

[ADezii]

Hello all, I am back with the new project i have had thrown at me.

I need to make a DB with forms that are accessible by multiple countries on our network so this will not be "web based" per se.

I am using access 2003 with an access 2000 format.

I tried to make a data access page but once i save the page i get connection errors. The form itself when pulled up in IE shows, but there is no data. when i pull the page back up in design view I recieve the error:
"Cannot find the database or some objects that this page refers to. Update the connection information of the page or fix the reference to the missing database objects."

The path is correct and i have made no changes to any connection settings. This is not a web server but more of a shared PC that everyone uses to store documents as well as our general access DBs as well.

Can I use DAPs for what I am looking for, and if so, anyone have any ideas on where to start looking?

With Data Access Pages there are 2 different Connections:

1. Connection from Access to the Data Access Page. This can be set and/or retrieved or set via the FullName Property of the Page as in:
   

   Dim aob As AccessObject
   Set aob = CurrentProject.AllDataAccessPages("Page3")
    
   'Set
   aob.FullName = "Fully qualified Path to the *Page3.htm File"
    
   'Retrieve
   Debug.Print aob.FullName 

2. The Connection between the Page and the Data Source, This can be set and/or retrieved in the following manner:
   1. Open the DAP in Internet Explorer or your Browser.
   2. Select the Option to View the Source Code. In IE, this is View ==> Source.
   3. CTRL+F to Open the Find Dialog Box.
   4. Search for the String 'Data Source='.
   5. When found, either verify or correct.
   6. Hope this helps.

[Curben]

Still not working:
Here is what i did
I added the code as a module which i Titled Dap Connection and added the following code

Option Compare Database
 
Dim aob As AccessObject
Set aob = CurrentProject.AllDataAccessPages("AltOverride.htm")
 
'Set
aob.FullName = "\\3.28.239.168\SwapServer\Users\Curt\Lab\AltOverride.htm"
 
'Retrieve
Debug.Print aob.FullName

and this is the connection string, all paths appear to be correct

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=501017623;Data Source=\\3.28.239.168\SwapServer\Users\Curt\Lab\DEX RR DB Support.mdb;Mode=ReadWrite|Share Deny None;Extended Properties=&amp;quot;&amp;quot;;Persist Security Info=False;Jet OLEDB:System database=\\3.28.239.168\swapserver\DB Support\System.mdw;Jet OLEDB:Registry Path=&amp;quot;&amp;quot;;Jet OLEDB:Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>

Did i misunderstand something or break something else?