Software

Ask something
Discussion Locked

ms access vb modules to visual basic

0 helpful
2 replies

by justinwilshire2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Microsoft Access has a feature that allows you to convert macros to visual basic modules. Is there a way one can easily, starting with these modules, produce a compiled Visual Basic executable that can be run by users in windows 9x/me/2k/xp etc?
The switchboard runs the apps I created without a problem, however I want other people to be able to use these in windows who don't have MS Access on their computer but are running on windows 9x or later OS. In other words is there a way to easily convert the vb modules to a windows gui exe. Third party software is fine or something easy in the vb studio that's in my windows system.

2 replies

by mattohare

Such a migrating job would be difficult, not as much because of the modules, but because of the forms. I do not know of any tool (though I have thought of writing them) that migrates the forms. They are just too different.

However, another solution might work for you. Upgrade your own MSOffice to Office Developer Edition. That comes with a scaled-down version of MS-Access that you can distribute without royalties. Users can not create new databases with it, or use the database window. (I believe.) But they can run your programs pretty well.

by candyman

MS Office (Developer) packages an access run time module that will let you distribute a tightly integrated access application - using the Pack and Deploy Wizard makes this distribution rather painless. I found this to be a plus for those limited scope applications and did not want the user to have to have a full access product for both cost and security reasons. This may be too elementary but hope it helps.
Don H.

This discussion is closed to new replies.