Hi! I tried creating a Recordset from "Views" instead of "Tables"; unfortunately, DW didn't read the data within this MS Access Query. The reason I can't do it through "Tables" is because DW is not recognizing the tables as part of the query either (probably because these tables are linked). Any suggestions/alternate ways to skin the cat? Thanks.

DT

How does your query look like? What makes you think DW doesn't understand relations? If you're in the Query Builder you can select multiple tables and join them in your query.

Can you provide more details what you're trying to accomplish and what Server Behaviors you're using?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I am trying to create a Recordset (Query) under Server Behaviors to post/edit data from MS Access. I had no problems doing this with a smaller file, but this is a very large file with linked tables within Access.

Even though the connection was successful, when I select this connection in the Recordset dialogue box, I have a message "Unable to retrieve tables from this connection, click on the 'Define...' button to test this connection" (which, when I do, it will say again that the connection was made successfully).

The MS Access query file then is listed as a "table" (the only one listed under the Recordset dialogue box) and the linked tables within MSAccess are not acknowledged in this same pull down menu (from the Recordset dialogue box).

I "test" this data, and "No data" is displayed when all, or selected columns are selected.

My conclusion is that either 1) the MS Access file is too large or 2) linked tables within MS Access cannot be connected or 3) I'm missing something...

Thanks for your help!

d.t.

When you say large, what exactly do you mean? Hundreds of megabytes?

What happens when you create a copy of the .mdb file and delete all records? Do you still have the same issue? This way you can find out if it's the table structure (which I can hardly image as I used databases with lots of tables and joins as well) or the amount of data DW is choking on....

Imar

One more thing. What do you mean with Linked Tables. Are you referring to joins between the tables, or to links to a separate Sql Server or other database?

Imar

The "linked" tables have been created from MS Access as a connection to another MS database...which means...YES!! I did it!

Ah the Socratic method. I love it. :)

All I needed to do was to go directly to the source file and voila!

You're great man!
d.t.

Great. Glad it's working.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.