DLL from module

[nagyf]

I want to reuse codes as DLL-s instead of copying modules everywhere.
How can I make a DLL from my Visual Basic 6.0 string manipulation modules?
Which should be the type of the new project?
Where are the .OBJ files in Visual Basic 6.0?
How must I use a linker?
More exactly: they are written not in Visual Basic 6.0 but in the Basic of Access 97.
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"

 

[Databaseguy]

You'd have to copy the code into VB6.0 and compile it into a DLL. Then, you'd need to set reference to the DLL in the VBE in Access. (In theory, never actually done it myself)

Perhaps you could get Mr. Michal Red to help. From what I've seen, He's a VB Expert.

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[nagyf]

Tyrone,

In theory... seems easy.
In practice:
VB6 100 types of projects. Which one I should choose?
How can I command the linker that I do not want exe but dll?
When I compiled an Access module by VB 6.0 the first error was in the second line: "Option Compare Database". That line seems to be very important, because it handles the national sort order properly: A,Á,B,..., E,É,F ...,,O,Ó,Ö,Õ,...
The pure ASCII order is not Hungarian Sort order but like the Swedish: A,B,...,X,Y,Z,Á,É,...

Regards Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"

 

[Databaseguy]

Well, I'm still working my way towards MCP, and haven't done a DLL "Yet". However, it appears that if you open VB 6.0, and choose ActiveX Dll Project, you'll be on your way.

As far as your Compile Error, you'll have to make reference to the DAO 3.51 or DAO 3.6, and possibly the Microsoft Access 8.0 and/or 9.0 object libaries. You can do this by going to project/references in VB.

If you'er using Access 2000 or interfacing with SQL or ASP, you should consider using the ADO and ADOX object models.

There's info about ADO vs DAO on my web page and here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate.asp

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy