Data Access Page won't reconnect

  • Thread starter Thread starter Carl E. Campbell
  • Start date Start date
C

Carl E. Campbell

I am trying to create a data access page for a project I'm working on. When
I create the page, it works fine. I can save it to my web server - it works
fine and I can access the data from any web browser. As long as I don't
leave "design mode" I can continue to modify and save the data access page,
but as soon as I leave I'm locked out of making any changes. When I try to
open the page in design mode, I get an 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"

Fine. Strange, since I didn't change anything, but fine. So now I open the
page connection properties and re-enter the username and password (I'm using
specific user, not integrated security). I click the "Test Connection"
button, and get a "Test Connection Succeeded" message. OK. I've even tried
allowing it to save the password, which I don't really want to do.

Now I click on the "refresh field list" button and get an error message!

"Microsoft Access is unable to connect to the data source specified in the
connection string of this page."

As long as I don't save at this point, the original page will continue to
work fine, but saving will break everything and I'll have to start over from
scratch.

Any ideas on why this is happening?
 
What driver, connection string and version of Access are you using?

Also, this newsgroup is for ADP and not DAP. For DAP, you should post in
m.p.a.dataccess.pages.
 
Back
Top