Re: Registering programs in access

Thank you Douglas,

I guess you are telling me that if I register the program with Windows 2003,
Access 2003 will find it. I have noticed that when I open a Module I can
check the References. Sure enough TSISoon is present and checked.

Because this system is so critical to me (I wrote it for my wife to use with
her Fuller Brush business and all I heard was loud noises when she tried to
use it.) I was hoping that if it ran on Access 2000 it would automatically
convert OK to access 2003. Because I open several databases from a control
database I developed a common function:

Function Call_BFB_Brad(strDB)
Dim Called_DB
'Create text string containing "Database to Call".
Called_DB = strDB

With COMAddIns("TsiSoon90.Connect").Object
.FileToOpen = Called_DB
.Exclusive = False
.FileIsAdp = False
.CloseAll
End With
End Function

And I passed the parameter strDB to it.

Thank you for your help. Now that I know it will work, I will play around
and see what may be the problem. Thanks again!

Brad
"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:uEuRtSBJGHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
>I can confirm that TSISoon works with Access 2003.
>
> There's no need to add a reference to it or anything: all you need do is
> follow the Access 2000 instructions that come with the DLL.
>
> 1) Register the dll with regsvr32.exe
> 2) Use the following code to run the ComAddIn's capabilities:
>
> With COMAddIns("TsiSoon90.Connect").Object
> .FileToOpen = "c:\db1.mdb"
> .Exclusive = False
> .FileIsAdp = False
> .CloseAll
> End With
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
> news:LsKCf.14946$_S7.12845@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> By "register different programs for the system," I mean "Make known to an
>> Access database." For several years I have been using a module
>> "TsiSoon90.dll" developed by Michael Kaplan. I thought I would see if it
>> could be used by access 2003.
>>
>> To use this module I usually registered it with Windows by using
>> regsvr32.exe. And then in access 2000 there was an option under Tools
>> that allowed me to make this program known to access 2000. With Windows
>> 2003 I registered it with regsvr32.exe; however, I cannot find any place
>> in access 2003 to reference this module.
>>
>> Of course I could recode the processes in each database; however, I would
>> prefer using "TsiSoon90.dll" also there may be other modules that I need
>> to access. I don't know what modules are currently being used by my
>> databases. (With Access 2000 "under Tools" I used to be able to look at
>> the various modules a given database was using.)
>>
>> Any suggestions??
>> Brad
>>
>>
>> "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
>> news:O1Yu9S4IGHA.2896@xxxxxxxxxxxxxxxxxxxxxxx
>>> What do you mean by "register different programs for the system" using
>>> Access?
>>>
>>> --
>>> Doug Steele, Microsoft Access MVP
>>> http://I.Am/DougSteele
>>> (no private e-mails, please)
>>>
>>>
>>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>>> news:uqtCf.4540$2O6.4101@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>> Good morning,
>>>>
>>>> I was using access 2000. I am now using access 2003. In 2000 I could
>>>> register different programs for the system. How do I do this in 2003??
>>>> I cannot find out how to see the programs that are registered??
>>>>
>>>> Thank you.
>>>> Brad
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Registering programs in access
    ... > I guess you are telling me that if I register the program with Windows ... > 'Create text string containing "Database to Call". ... >>> in access 2003 to reference this module. ...
    (microsoft.public.access.conversion)
  • Re: Run-time error on Calendar click
    ... Did you copy this database beetween two different versions of Windows? ... decompile/recompile the database, particularly when you want to move it to ... also do it without using this switch by adding a dummy reference in the VBA ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Runtime Error -- Library not Registered Access 2003
    ... so that you don't need to set a reference to Word. ... The database uses the MSWORD Object ... How do I register that Library? ...
    (microsoft.public.access.forms)
  • Re: Registering programs in access
    ... There's no need to add a reference to it or anything: ... > Of course I could recode the processes in each database; ... >>> register different programs for the system. ... >>> Brad ...
    (microsoft.public.access.conversion)
  • Re: Missing DLL when Creating Replica
    ... Now we have a newbie and he is on Windows XP but ... When I attempted to put him on the database by Creating a Replica ... Why in the world would a data file have a reference to an outside ...
    (microsoft.public.access.replication)