|
Home > Archive > MS Access data conversion > February 2006 > Registering programs in access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Registering programs in access
|
|
| Dr. Brad 2006-01-27, 1:24 pm |
| 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
| |
| Douglas J. Steele 2006-01-27, 8:25 pm |
| 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@sbcglobal.net> wrote in message
news:uqtCf.4540$2O6.4101@newssvr12.news.prodigy.com...
> 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
>
| |
| Dr. Brad 2006-01-28, 9:23 am |
| 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@NOSP
AM_canada.com> wrote in message
news:O1Yu9S4IGHA.2896@TK2MSFTNGP09.phx.gbl...
> 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@sbcglobal.net> wrote in message
> news:uqtCf.4540$2O6.4101@newssvr12.news.prodigy.com...
>
>
| |
| Douglas J. Steele 2006-01-28, 9:23 am |
| 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@sbcglobal.net> wrote in message
news:LsKCf.14946$_S7.12845@newssvr14.news.prodigy.com...
> 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@NOSP
AM_canada.com> wrote in message
> news:O1Yu9S4IGHA.2896@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Dr. Brad 2006-01-28, 9:23 am |
| 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@NOSP
AM_canada.com> wrote in message
news:uEuRtSBJGHA.3144@TK2MSFTNGP11.phx.gbl...
>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@sbcglobal.net> wrote in message
> news:LsKCf.14946$_S7.12845@newssvr14.news.prodigy.com...
>
>
| |
| Dr. Brad 2006-01-28, 11:23 am |
| Well, I've tried everything I can think of this morning! Everything looks
okay; however, when I attempt to execute the With block I am getting "
Run-time Error 91: Object variable or With block variable not set." I do
not know what this means nor it is Help any use to me.
Any suggestions??
Brad
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:LtLCf.22665$F_3.3409@newssvr29.news.prodigy.net...
> 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@NOSP
AM_canada.com> wrote in message
> news:uEuRtSBJGHA.3144@TK2MSFTNGP11.phx.gbl...
>
>
| |
| Douglas J. Steele 2006-01-28, 11:23 am |
| You did say you registered the DLL, using regsvr32.exe, didn't you?
I'd never used MichKa's utility before your question (although I was aware
of it), and all I did was register it and use the code I pasted and it
worked.
Try compiling your application, in case there's an unrelated problem that's
causing that line to fail.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:_eMCf.22681$F_3.6552@newssvr29.news.prodigy.net...
> Well, I've tried everything I can think of this morning! Everything looks
> okay; however, when I attempt to execute the With block I am getting "
> Run-time Error 91: Object variable or With block variable not set." I do
> not know what this means nor it is Help any use to me.
>
> Any suggestions??
>
> Brad
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:LtLCf.22665$F_3.3409@newssvr29.news.prodigy.net...
>
>
| |
| Dr. Brad 2006-01-28, 1:23 pm |
| OK. I will see. I am running a program developed in Access 2000. If that
matters.
Brad
"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:ualqzTCJGHA.2628@TK2MSFTNGP15.phx.gbl...
> You did say you registered the DLL, using regsvr32.exe, didn't you?
>
> I'd never used MichKa's utility before your question (although I was aware
> of it), and all I did was register it and use the code I pasted and it
> worked.
>
> Try compiling your application, in case there's an unrelated problem
> that's causing that line to fail.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:_eMCf.22681$F_3.6552@newssvr29.news.prodigy.net...
>
>
| |
| Dr. Brad 2006-01-28, 1:23 pm |
| Yes I did registered the DLL, using regsvr32.exe. I allways compile when I
make a change.
Brad
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:5SNCf.5163$2O6.271@newssvr12.news.prodigy.com...
> OK. I will see. I am running a program developed in Access 2000. If
> that matters.
>
> Brad
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:ualqzTCJGHA.2628@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Douglas J. Steele 2006-01-28, 1:23 pm |
| Just as a test, create a new database strictly to test TSISoon.
If it works, try importing all of the objects from your existing database
into a new one.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:SVNCf.5164$2O6.669@newssvr12.news.prodigy.com...
> Yes I did registered the DLL, using regsvr32.exe. I allways compile when
> I make a change.
>
> Brad
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:5SNCf.5163$2O6.271@newssvr12.news.prodigy.com...
>
>
| |
| Dr. Brad 2006-01-28, 8:24 pm |
| Hi Douglas,
I did and I got the same results! I also reregisered "TsiSoon90.dll". I
recieved the same error
" Run-time Error 91: Object variable or With block variable not set." It
hangs on the first statment within the With block (i.e..FileToOpen =
"c:\db1.mdb"). If I take that ststement out, it hangs on the next statement
etc.
It seem to me that it wants me to Define an Object; Though, I do not know
what object Object.
Brad
"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:%23EgIp0DJGHA.3696@TK2MSFTNGP15.phx.gbl...
> Just as a test, create a new database strictly to test TSISoon.
>
> If it works, try importing all of the objects from your existing database
> into a new one.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:SVNCf.5164$2O6.669@newssvr12.news.prodigy.com...
>
>
| |
| Douglas J. Steele 2006-01-28, 8:24 pm |
| Sorry, I don't know what to say.
It worked fine for me with no changes to the sample code. In fact, I copied
your code into a test database, and it worked fine for me.
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
Of course, you really should be declaring your variable types as Strings,
and there's no reason for variable Called_DB:
Function Call_BFB_Brad(strDB As String)
With COMAddIns("TsiSoon90.Connect").Object
.FileToOpen = strDB
.Exclusive = False
.FileIsAdp = False
.CloseAll
End With
End Function
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:GPQCf.5233$2O6.2500@newssvr12.news.prodigy.com...[color=darkred]
> Hi Douglas,
> I did and I got the same results! I also reregisered "TsiSoon90.dll". I
> recieved the same error
> " Run-time Error 91: Object variable or With block variable not set." It
> hangs on the first statment within the With block (i.e..FileToOpen =
> "c:\db1.mdb"). If I take that ststement out, it hangs on the next
> statement etc.
>
> It seem to me that it wants me to Define an Object; Though, I do not know
> what object Object.
>
> Brad
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:%23EgIp0DJGHA.3696@TK2MSFTNGP15.phx.gbl...
| |
| Dr. Brad 2006-01-28, 8:24 pm |
| Thanks Douglas,
I will work on it tomorrow. Thanks again.
Brad
"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:%23omybDFJGHA.532@TK2MSFTNGP15.phx.gbl...
> Sorry, I don't know what to say.
>
> It worked fine for me with no changes to the sample code. In fact, I
> copied your code into a test database, and it worked fine for me.
>
> 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
>
> Of course, you really should be declaring your variable types as Strings,
> and there's no reason for variable Called_DB:
>
> Function Call_BFB_Brad(strDB As String)
>
> With COMAddIns("TsiSoon90.Connect").Object
> .FileToOpen = strDB
> .Exclusive = False
> .FileIsAdp = False
> .CloseAll
> End With
>
> End Function
>
>
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:GPQCf.5233$2O6.2500@newssvr12.news.prodigy.com...
>
>
| |
| Dr. Brad 2006-01-29, 8:24 pm |
| Good afternoon Douglas,
I think I know what the problem might be! One of the first things that the
directions say is to make sure that you have the VB6 run-time files on your
machine! I cannot find vb6sys.exe on my computer.
As the directions suggested I tried going to:
http://support.microsoft.com/downlo...iles/Vb6sys.exe
however, this page is no longer supported. I then spent about an hour
trying to find a way to download vb6sys.exe with no luck. Things in office
XP-Pro do not seem to be as simple as the old Office 2000.
Do you have a suggestions on where I might find this module?? I know this
may seem like a very dumb question; however, any suggestions will be
helpful. I am pretty sure that this is is my problem.
Brad
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:1dTCf.28349$H71.4976@newssvr13.news.prodigy.com...
> Thanks Douglas,
> I will work on it tomorrow. Thanks again.
>
> Brad
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:%23omybDFJGHA.532@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Douglas J. Steele 2006-01-29, 8:24 pm |
| When I went to Google and specified +vb6 +runtime +files, the first hit was:
http://www.microsoft.com/downloads/...&displaylang=en
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:ILbDf.28555$H71.27373@newssvr13.news.prodigy.com...
> Good afternoon Douglas,
>
> I think I know what the problem might be! One of the first things that
> the directions say is to make sure that you have the VB6 run-time files on
> your machine! I cannot find vb6sys.exe on my computer.
>
> As the directions suggested I tried going to:
> http://support.microsoft.com/downlo...iles/Vb6sys.exe
> however, this page is no longer supported. I then spent about an hour
> trying to find a way to download vb6sys.exe with no luck. Things in
> office XP-Pro do not seem to be as simple as the old Office 2000.
>
> Do you have a suggestions on where I might find this module?? I know this
> may seem like a very dumb question; however, any suggestions will be
> helpful. I am pretty sure that this is is my problem.
>
> Brad
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:1dTCf.28349$H71.4976@newssvr13.news.prodigy.com...
>
>
| |
| Dr. Brad 2006-01-30, 9:28 am |
| Good morning Douglas,
I never thought of using Google; but, I will from now on. I found the
program and installed It, then I reregisered "TsiSoon90.dll". I then went to
my original system and it worked fine! I went back and forth from one
database to the other a couple of times and then I went running to tell my
wife I had fixed her system.
Interesting thing happened on the way to satisfaction. When I closed this
system I was notified that there was an internal error and Microsoft would
sure like me to allow them to collect the data and transmitte it to them.
As I usually do I said OK; and I had another cup of coffee while it
completed. (Naturally I have no idea what problem is system encountered.)
As I sat down and opened the system to do some work, woe woe I have the same
OLD problem!
From time to time over the next two years I may revisit this problem. But
for now, I do not want to take up any more of your time. I am a retired
professor and at the age 74 I have much time; however, I may spend it
differently for awhile.
I really appreciate your support and patients (I am not very well qualified
on computer problems). You have been very helpful and I am grateful.
Brad
"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:uRSgD%23SJGHA.1728@TK2MSFTNGP09.phx.gbl...
> When I went to Google and specified +vb6 +runtime +files, the first hit
> was:
>
> http://www.microsoft.com/downloads/...&displaylang=en
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:ILbDf.28555$H71.27373@newssvr13.news.prodigy.com...
>
>
| |
| Dr. Brad 2006-01-31, 9:25 am |
| Good morning Douglas,
One more thing this morning. I am running Windows XP-Pro (2003) with access
XP-Pro (2003). Opening a module in the database I have the following
references checked (listed in order):
Visual Basic for Applications
Microsoft Office 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Looking at your access set up, do you have anything different chosen in the
reference listing?? I thought perhaps I'm missing something.
PS I also have the security levels set at medium.
Brad
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:r%oDf.15304$_S7.11546@newssvr14.news.prodigy.com...
> Good morning Douglas,
>
> I never thought of using Google; but, I will from now on. I found the
> program and installed It, then I reregisered "TsiSoon90.dll". I then went
> to my original system and it worked fine! I went back and forth from one
> database to the other a couple of times and then I went running to tell my
> wife I had fixed her system.
>
> Interesting thing happened on the way to satisfaction. When I closed this
> system I was notified that there was an internal error and Microsoft would
> sure like me to allow them to collect the data and transmitte it to them.
> As I usually do I said OK; and I had another cup of coffee while it
> completed. (Naturally I have no idea what problem is system encountered.)
>
> As I sat down and opened the system to do some work, woe woe I have the
> same OLD problem!
>
> From time to time over the next two years I may revisit this problem. But
> for now, I do not want to take up any more of your time. I am a retired
> professor and at the age 74 I have much time; however, I may spend it
> differently for awhile.
>
> I really appreciate your support and patients (I am not very well
> qualified on computer problems). You have been very helpful and I am
> grateful.
>
> Brad
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:uRSgD%23SJGHA.1728@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Douglas J. Steele 2006-02-01, 3:26 am |
| My settings are identical.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
news:DSJDf.21231$Jd.626@newssvr25.news.prodigy.net...
> Good morning Douglas,
>
>
>
> One more thing this morning. I am running Windows XP-Pro (2003) with
> access XP-Pro (2003). Opening a module in the database I have the
> following references checked (listed in order):
>
>
>
> Visual Basic for Applications
>
> Microsoft Office 11.0 Object Library
>
> OLE Automation
>
> Microsoft DAO 3.6 Object Library
>
> Microsoft ActiveX Data Objects 2.1 Library
>
>
>
> Looking at your access set up, do you have anything different chosen in
> the reference listing?? I thought perhaps I'm missing something.
>
>
>
> PS I also have the security levels set at medium.
>
>
>
> Brad
>
>
>
> "Dr. Brad" <rbthomas@sbcglobal.net> wrote in message
> news:r%oDf.15304$_S7.11546@newssvr14.news.prodigy.com...
>
>
|
|
|
|
|