Support Multiple Tables

[Steve]

I have a project that connot use web services, the clients are disconnected
and a local IIS server is not acceptable. I would like to use multiple
tables in MSDE as the data source for my form in a star schema.

Is there anyway of designating all of the tables as a main data source? or
any other suggestions?

 

[Scott L. Heim [MSFT]]

Hi Steve,

How often will the data be changing? It sounds as if some of the tables
would typically not be a part of the main data source if the users had
continual access - is this correct? If so, what you may want to look at
doing is adding "resource files" (these would consist of your table data)
for the tables that would typically be used as a "secondary data source."

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Sanj]

My problem is this,

Prospecting Table - Inserting, adding and subtracting prospects as well as
maintaining a que to bring potential prospects into and out of active status

Prospecting_Detail Table - multiple activities w/ multiple details per
activity per prospect

It logically setups as a star schema.

What I am planning to do right now is to create a single large Schema
independent of the database and then fill the nodes on the fly using an ADO
connection. Thoughts?