Forms in Outlook and Tables in Access ?

[hjeff71]

Ok, we've got this complicated form with 10000s of lines of vba code, doing all sorts of calculation,

The forms are on several pcs, and the tables are on the server, (using the external link)

Now we need to install those forms on many other pcs and are looking into buying liscencing,

Along the road, someone suggested to have the forms in Outlook instead of Access, (Since every one has Outlook)

My question is: Can a Form be imported and used and run from Outlook using external link to the tables on the server?

(i know simple forms can be created in outlook, but they dont have the complexity of access, so again, the question is: can a form created in access be imported in outlook)

Thanks,

[Scott Price]

Ok, we've got this complicated form with 10000s of lines of vba code, doing all sorts of calculation,

The forms are on several pcs, and the tables are on the server, (using the external link)

Now we need to install those forms on many other pcs and are looking into buying liscencing,

Along the road, someone suggested to have the forms in Outlook instead of Access, (Since every one has Outlook)

My question is: Can a Form be imported and used and run from Outlook using external link to the tables on the server?

(i know simple forms can be created in outlook, but they dont have the complexity of access, so again, the question is: can a form created in access be imported in outlook)

Thanks,

As far as I know, you cannot, nor would you want to try, use Outlook in the manner you describe. The only reason I can possibly think of for that suggestion is budget crunching, as certain versions of MS Office do not have Access, while Outlook is ubiquitous.

You mention the forms are built with vb, is that vba as in the visual basic for applications that Access uses, or the visual basic that is a stand alone programming language (the two are not the same animal!)

Regards,
Scott