Ms Access DLL

[101287]

Can someone advise me how to learn about DLL and MS access? I have learn a little bit about access but would like to learn and/or understand the use to changing and/or updating DLL to make an access application more efficient.

Thank you for guidance and collaboration. Books or articles regarding this subject will be appreciated.

Luis

 

[JoeAtWork]

You can't make DLL's in Access. You need a coding environment such as VB6 for that.

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[jsteph]

Well, you can, and I have, but as Joe says, you need VB6 to make it work, and it is somewhat tedious.

I've had entire Access applications run from a VB6 .dll, using the VB6 OLE objects for access, which can display forms, etc, from an Access.Application object.

This was not done for performance reasons, more for security. It was a real pain and I don't make a habit of it.
--Jim

 

[JoeAtWork]

To add to my original answer, I don't see how making a DLL would make Access more "efficient". You are just moving the code outside of Access. I can see one advantage, though. If the code was in a DLL, it can't be corrupted by Access.

Choosing to create a DLL is usually a design/architecture decision. I tend to do it if I foresee that the code may be useful in other projects, or perhaps if the functionality is only included if the user buys a certain license (i.e. the DLL is an add-on module).

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[ZmrAbdulla]

Instead of DLL you can create MDE or MDA versions of Access and add reference to that in your database.

________________________________________________________
Zameer Abdulla
Help to find Missing people