which is better practise - stored procedure or activex to create a
adodb connection for visual basic applications that can be called from
multiple applications? thank you very much.

Tough to reply as these are not the same thing.

A stored procedure is a query that is already compiled and runs on the
server. Such queries are generally faster than commands from a Data Access
Library. SPs should always be your first choice.

As for creating ADO Connections, manage them in your middle layer. Either an
ActiveX Exe or Dlls.

-ralph

Why ?? (Path/File access error (Error 75)
VB.NET or C++.NET or C#
Password Change
TransparentBlt and Autoredraw issues (refresh isnt solving it)
Picturebox fit newbe question
NTFS File Access in VB6
Sub or Function is not defined
Control similar to MS Access List Box
write to disk and permissions
re-use code for multiple applications