Solved

Can DAO recordsets be stored as .dlls ?

Posted on 1998-06-25
4
224 Views
Last Modified: 2011-10-03
Since my array recordsets are access frequently, Can both control arrays and DAO recordsets be stored as .dlls ?
0
Comment
Question by:optical
  • 2
4 Comments
 
LVL 6

Expert Comment

by:clifABB
Comment Utility
Yep, as long as they are Activex DLLs.
0
 

Accepted Solution

by:
MikeReilly earned 50 total points
Comment Utility
You can store recordset information in a dll.  I believe you have to pass recordsets to/from automation servers as variant data types, so you will have to assign your recordset to a variant data type before you transfer, and re-assign to recordset once the target receives it.  You have to be careful if you are creating a server that will be available to multiple clients, as you have the issue of each client creating a separate instance of the dll.  If you are using VB, look into the following topic in Books On-line:
1. ActiveX components (read the whole chapter)
2. COM

I'm not so sure about control arrays, however.

0
 
LVL 6

Expert Comment

by:clifABB
Comment Utility
MikeReilly:
If the ActivexDLL is going to be used by VB exclusively, you can pass recordset types.
0
 

Author Comment

by:optical
Comment Utility
Thank you.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now