By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,028 Members | 1,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,028 IT Pros & Developers. It's quick & easy.

Can I Use Data Access Pages

Curben
P: 47
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?
Dec 7 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,706
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:
    Expand|Select|Wrap|Line Numbers
    1. Dim aob As AccessObject
    2. Set aob = CurrentProject.AllDataAccessPages("Page3")
    3.  
    4. 'Set
    5. aob.FullName = "Fully qualified Path to the *Page3.htm File"
    6.  
    7. 'Retrieve
    8. 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.
Dec 8 '07 #2

Curben
P: 47
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

Expand|Select|Wrap|Line Numbers
  1. Option Compare Database
  2.  
  3. Dim aob As AccessObject
  4. Set aob = CurrentProject.AllDataAccessPages("AltOverride.htm")
  5.  
  6. 'Set
  7. aob.FullName = "\\3.28.239.168\SwapServer\Users\Curt\Lab\AltOverride.htm"
  8.  
  9. 'Retrieve
  10. Debug.Print aob.FullName
and this is the connection string, all paths appear to be correct


Expand|Select|Wrap|Line Numbers
  1. <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?
Dec 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.