Access Page Can't Display Records...

[Aluicious]

I have a network drive mounted on my Windows XP machine (w:\) and have the
database stored in a folder in that drive. Testing with one simple table.

Created an access page with the wizard and saved the page to the same folder
as the database.

When I view the page from Access, I get a blank page. When I return to
design view I get the error message:

"Cannot find the database or some database objects that this page refers to.
Update the connection information of the page , or fix the references to the
missing database objects."

The ConnectionString for the page looks ok (to me):

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=W:\Public\PCGPS_MeanAge\MeanAge.mdb;Mode=Share Deny None;Extended
Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine
Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact
Without Replica Repair=False;Jet OLEDB:SFP=False

Any Ideas?

thanks,
Al

 

[a a r o n . k e m p f]

You should use a UNC path and not an Mapped Network drive. Shouldn't
you?

For the record-- i think that DAP on top of ADP is a _MUCH_ better
platform. I swear my cnnstring would be about 20 characters total..
With MDB you need to put perms in 3 different places - instead of one.

and the connection string.. instead of this:

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=W:\Public\PCGPS_MeanAge\MeanAge.mdb;Mode=Share Deny
None;Extended
Properties="";Persist Security Info=False;Jet OLEDB:System
database="";Jet
OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet
OLEDB:Engine
Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial
Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet
OLEDB:Compact
Without Replica Repair=False;Jet OLEDB:SFP=False

It would just be this
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=UF_20080416;Data Source=dev01\sqlexpress

PS - you're not editing these by hand are you? I refuse to touch these
HTML / DAP files outside of MS Access.



-Aaron