General Questions About differences between working with a MDB and ADP

[David C. Holley]

Is it possible to create custom properties for the ADP file?

CurrentDB and DAO.DBEngine(0)(0) are crapping out.

SET db = CurrentDB results in an object variable not set

SET db = DAO.DBEngine(0)(0) returns 'Item not found in the collection'

I do have a reference to DAO 3.6 set.

 

[Douglas J. Steele]

ADPs work with SQL Server. The concepts of CurrentDb and DAO.DBEngine(0)(0)
don't really make much sense in an ADP. What are you hoping to be able to
do?

 

[David C. Holley]

1) I was hoping to create custom properties for the front end.

2) Being entirely .mdb when it comes to Access, DAO is my poison of choice.
I was able to sort out the ADO equivalents of what I was doing. One example
is that I've got a couple of places where I use an unbound list box in a
query-by-form scenario to display child records in a subform. To make things
easier for the users, I've got an unbound text box whose AfterUpdate event
will search through the list box and if it finds the key value (in one of
two different columns) select the value in the list box and display the
relevant records. Much easier than it sounds overall, unless you've avoided
ADO in favor of DAO.