Form's recordource property as remote sql server db?

[nani]

Form's recordource property as remote sql server db?

I developed my project in ADP, now it's time to deploy it as mdb (since Access runtime doesn't support ADP - why?).
Unortunately in mdb I can't set my forms' recordource properties to a remote sql server db.
Can I do it from code somehow?

 

[sjn]

Try the following, as the form is opened, in the FormOpen event you can probably specify the recordsource dynamically by using

me.recordsource = <name of recordsource>

If this method works, you might want to create a table with the form names in your application and their associated record sources. Then as you open each of the forms, you can assign the appropriate recordsource as it opens.

Good luck.

Scott.