Connectivity

[Truthseeker]

I have built a standard "three-tier" database model, following Visual Basic
models and using Access. I have a Data Services class module, a Business
Services class module, and a form with unbound controls. I can't get data to
populate to populate the form. I think that I already know the problem..I
have been trying to find a way to expose the data from the Data Services
module (with the connection to my tables) to my Business Services module so
that the form can read the data from the tables, as filtered through my
classes. In VB, it uses a standard BindingCollection, but I cannot find an
equivalent method in Access2003. Any suggestions as to how I can make this
work?

 

[Paul]

I've done a similar thing in VB, but not in Access. However, I would imagine
you do the following:

1. Ensure that you have referenced your Data Services dll using
Tools|References in Access.
2. Ensure your dll exposes the recordset (of data from your database) as a
property.
3. In Access use code like:

Me.txtField1.value = clDataServices.Rs.Fields(Field1).value

where clDataServices is your data services class and Rs is a property of
that class that is the current recordset.

Is that any help at all? Apologies if I have misunderstood the question.