Set Recordset from external Access to form/controls

[tsosiel]

Greetings All,

I'm trying to do the following in my application. I have an external Access2000 db for my backend and an Access2000 db for my frontend (w/plans of migrating in the future). I'm having difficulties trying to perform the following (after much reading from UserGroups/WebSites/etc.)
1) Defining stored queries at runtime - trouble setting up pass-through queries! Or would it be better to use linked tables? (which works now)
2) Forms/Reports that are based on data - how do I defined data from the backend? There are concepts of client-server apps that I'm unware of...

I appreciate any and all advice! Thank you in advance..

Lorentz

 

[zevw]

I can only talk from my own experience that Linked Tables work great and it is pretty safe for corruption.

 

[tsosiel]

zevw...

Thanks for the input. And yes, I hadn't thought about corruption or other admin duties. I agree with you. Thanks again...

- Lorentz!