Support Multiple Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 20 May 2005 05:13 GMT

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?

Reply to this Message

Scott L. Heim [MSFT] - 20 May 2005 19:44 GMT

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

Reply to this Message

Sanj - 20 May 2005 21:37 GMT

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?

> Hi Steve,
>
[quoted text clipped - 10 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights

Reply to this Message