| Author |
Message |
|
RzB
#1 / 14
|
 Will Tsisoon work with Access XP?
Will TSISOON work with Access XP? I have it workng
nicely with 2000 but have just moved to XP and it seems
to have stopped working. Are there any workarounds?
The info on www.trigeminal.com seems to indicate that it only works
with 2000 or 97. Any thoughts?
Thanks,
Roy
|
| Sat, 30 Apr 2005 05:32:57 GMT |
|
 |
|
michk
#2 / 14
|
Will Tsisoon work with Access XP? Never tested there, though there is nothing that should keep it from working that immediately comes to mind. --
MichKa
This posting is provided "AS IS" with
no warranties, and confers no rights.
Quote: > Will TSISOON work with Access XP? I have it workng
> nicely with 2000 but have just moved to XP and it seems
> to have stopped working. Are there any workarounds?
> The info on www.trigeminal.com seems to indicate that it only works
> with 2000 or 97. Any thoughts?
> Thanks,
> Roy
|
| Sat, 30 Apr 2005 05:57:27 GMT |
|
|
|
RzB
#3 / 14
|
Will Tsisoon work with Access XP? Hmmm.... Seems to work first time after opening Access but next invocation it wont close down... This is the code I'm using to execute tsisoon.... am I missing anything? Works fine with Access 2000. Dim tsd As Object
Set tsd = CreateObject("TsiSoon90.Connect80")
With tsd
.FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
.Exclusive = False
.CloseAll Application
End With
Many thanks,
Roy
Quote: > Never tested there, though there is nothing that should keep it from working > that immediately comes to mind. > --
> MichKa
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
> > Will TSISOON work with Access XP? I have it workng
> > nicely with 2000 but have just moved to XP and it seems
> > to have stopped working. Are there any workarounds?
> > The info on www.trigeminal.com seems to indicate that it only works
> > with 2000 or 97. Any thoughts?
> > Thanks,
> > Roy
|
| Sat, 30 Apr 2005 06:22:09 GMT |
|
|
|
Sandra Daigl
#4 / 14
|
Will Tsisoon work with Access XP? It works in my applications - --
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.
Quote: > Never tested there, though there is nothing that should keep it from > working that immediately comes to mind.
>> Will TSISOON work with Access XP? I have it workng
>> nicely with 2000 but have just moved to XP and it seems
>> to have stopped working. Are there any workarounds?
>> The info on www.trigeminal.com seems to indicate that it only works
>> with 2000 or 97. Any thoughts?
>> Thanks,
>> Roy
|
| Sat, 30 Apr 2005 10:11:37 GMT |
|
|
|
RzB
#5 / 14
|
Will Tsisoon work with Access XP? Hmm... No wait a moment - I had missed it - not in there so you were right!!!! :-) Roy
Quote: > Bob, > Yes,it is just not in the snippet.... Thanks. > However thinking about it... does it matter. > The application is going to get closed anyway... > Many thanks, > Roy > > Don't forget to do this before leaving the function:
> > Set tsd = Nothing
> > HTH
> > Bob Hairgrove
> > >Hmmm.... Seems to work first time after opening Access but next
> > >invocation it wont close down... This is the code I'm using to execute
> > >tsisoon.... am I missing anything? Works fine with Access 2000.
> > >Dim tsd As Object
> > >Set tsd = CreateObject("TsiSoon90.Connect80")
> > >With tsd
> > > .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> > > .Exclusive = False
> > > .CloseAll Application
> > >End With
|
| Sun, 01 May 2005 04:46:08 GMT |
|
|
|
Bob Hairgro
#6 / 14
|
Will Tsisoon work with Access XP?
Quote: >Hmmm.... Seems to work first time after opening Access but next >invocation it wont close down... This is the code I'm using to execute >tsisoon.... am I missing anything? Works fine with Access 2000. >Dim tsd As Object
>Set tsd = CreateObject("TsiSoon90.Connect80")
>With tsd
> .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> .Exclusive = False
> .CloseAll Application
>End With
Don't forget to do this before leaving the function: Set tsd = Nothing
HTH
Bob Hairgrove
|
| Sun, 01 May 2005 03:17:42 GMT |
|
|
|
RzB
#7 / 14
|
Will Tsisoon work with Access XP? Sandra, That is good to know... I must have a logic bug or something. Funny that it works OK in 2000. What are you using Tsisoon for? I am using it to close and re-open the current db so that I am able to make an archive of the backend. I set a flag on in a front end table before closing down using Tsisoon, then detect it when it opens and take some actions... Are you using it to close/open a db or for it's compaction capability? The logic of my application is as follows,,, Archiving the backend
' save the path/name of current backend (BE1)
' generate archivepath / Name(BEA)
' save this away.in a FE table.
' save a flag in FE table to say next time you open must do copy
' link to dummy BE
'
' Run TSISoon
' Close MaplXP
' Open MaplXP
'
' dummy BE gets automatically linked
' copy BE1 into BEA
' turn of flag in FE table
' link to BE1
'
' Run TSISoon
' Close MaplXP
' Open MaplXP
'
I have tried both ..................
Set tsd = CreateObject("TsiSoon90.Connect80")
With tsd
.FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
.Exclusive = False
.CloseAll Application
End With
and........................
With COMAddIns("TsiSoon90.Connect").Object
.FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
.Exclusive = False
.FileIsAdp = False
.CloseAll
End With
but it only works once in Access XP. Works multiple times just fine in 2000.
Any thoughte would be welcome...
Many thanks,
Roy
Quote: > It works in my applications - > --
> Sandra Daigle
> [Microsoft Access MVP]
> For the benefit of others please post all replies to this newsgroup.
> > Never tested there, though there is nothing that should keep it from
> > working that immediately comes to mind.
> >> Will TSISOON work with Access XP? I have it workng
> >> nicely with 2000 but have just moved to XP and it seems
> >> to have stopped working. Are there any workarounds?
> >> The info on www.trigeminal.com seems to indicate that it only works
> >> with 2000 or 97. Any thoughts?
> >> Thanks,
> >> Roy
|
| Sun, 01 May 2005 05:04:44 GMT |
|
|
|
Sandra Daigl
#8 / 14
|
Will Tsisoon work with Access XP? I use it to close one database, open a different one - run some code, close the second database and re-open the first database. I'll double check it tomorrow and let you know what I have - --
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.
Quote:
> Sandra, > That is good to know... I must have a logic bug or something. > Funny that it works OK in 2000. What are you using Tsisoon for? > I am using it to close and re-open the current db so that I am able > to make an archive of the backend. I set a flag on in a front end > table before closing down using Tsisoon, then detect it when it > opens and take some actions... Are you using it to close/open > a db or for it's compaction capability? > The logic of my application is as follows,,, > Archiving the backend
> ' save the path/name of current backend (BE1)
> ' generate archivepath / Name(BEA)
> ' save this away.in a FE table.
> ' save a flag in FE table to say next time you open must do copy
> ' link to dummy BE
> '
> ' Run TSISoon
> ' Close MaplXP
> ' Open MaplXP
> '
> ' dummy BE gets automatically linked
> ' copy BE1 into BEA
> ' turn of flag in FE table
> ' link to BE1
> '
> ' Run TSISoon
> ' Close MaplXP
> ' Open MaplXP
> '
> I have tried both ..................
> Set tsd = CreateObject("TsiSoon90.Connect80")
> With tsd
> .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> .Exclusive = False
> .CloseAll Application
> End With
> and........................
> With COMAddIns("TsiSoon90.Connect").Object
> .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> .Exclusive = False
> .FileIsAdp = False
> .CloseAll
> End With
> but it only works once in Access XP. Works multiple times just fine in
> 2000.
> Any thoughte would be welcome...
> Many thanks,
> Roy
>> It works in my applications -
>> --
>> Sandra Daigle
>> [Microsoft Access MVP]
>> For the benefit of others please post all replies to this newsgroup.
>>> Never tested there, though there is nothing that should keep it from
>>> working that immediately comes to mind.
>>>> Will TSISOON work with Access XP? I have it workng
>>>> nicely with 2000 but have just moved to XP and it seems
>>>> to have stopped working. Are there any workarounds?
>>>> The info on www.trigeminal.com seems to indicate that it only works
>>>> with 2000 or 97. Any thoughts?
>>>> Thanks,
>>>> Roy
|
| Sun, 01 May 2005 06:41:42 GMT |
|
|
|
RzB
#9 / 14
|
Will Tsisoon work with Access XP? Bob, Yes,it is just not in the snippet.... Thanks. However thinking about it... does it matter. The application is going to get closed anyway... Many thanks, Roy Quote: > Don't forget to do this before leaving the function: > Set tsd = Nothing
> HTH
> Bob Hairgrove
Quote:
> >Hmmm.... Seems to work first time after opening Access but next
> >invocation it wont close down... This is the code I'm using to execute
> >tsisoon.... am I missing anything? Works fine with Access 2000.
> >Dim tsd As Object
> >Set tsd = CreateObject("TsiSoon90.Connect80")
> >With tsd
> > .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> > .Exclusive = False
> > .CloseAll Application
> >End With
|
| Sun, 01 May 2005 04:37:23 GMT |
|
|
|
RzB
#10 / 14
|
Will Tsisoon work with Access XP? Sandra, Many thanks for your assistance. I have started a new thread - see "TSISoon - can't get simple example to work" Many thanks, Roy
Quote: > I use it to close one database, open a different one - run some code, close > the second database and re-open the first database. I'll double check it > tomorrow and let you know what I have - > --
> Sandra Daigle
> [Microsoft Access MVP]
> For the benefit of others please post all replies to this newsgroup.
> > Sandra,
> > That is good to know... I must have a logic bug or something.
> > Funny that it works OK in 2000. What are you using Tsisoon for?
> > I am using it to close and re-open the current db so that I am able
> > to make an archive of the backend. I set a flag on in a front end
> > table before closing down using Tsisoon, then detect it when it
> > opens and take some actions... Are you using it to close/open
> > a db or for it's compaction capability?
> > The logic of my application is as follows,,,
> > Archiving the backend
> > ' save the path/name of current backend (BE1)
> > ' generate archivepath / Name(BEA)
> > ' save this away.in a FE table.
> > ' save a flag in FE table to say next time you open must do copy
> > ' link to dummy BE
> > '
> > ' Run TSISoon
> > ' Close MaplXP
> > ' Open MaplXP
> > '
> > ' dummy BE gets automatically linked
> > ' copy BE1 into BEA
> > ' turn of flag in FE table
> > ' link to BE1
> > '
> > ' Run TSISoon
> > ' Close MaplXP
> > ' Open MaplXP
> > '
> > I have tried both ..................
> > Set tsd = CreateObject("TsiSoon90.Connect80")
> > With tsd
> > .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> > .Exclusive = False
> > .CloseAll Application
> > End With
> > and........................
> > With COMAddIns("TsiSoon90.Connect").Object
> > .FileToOpen = Application.CurrentProject.Path & "\MaplXP.mdb"
> > .Exclusive = False
> > .FileIsAdp = False
> > .CloseAll
> > End With
> > but it only works once in Access XP. Works multiple times just fine in
> > 2000.
> > Any thoughte would be welcome...
> > Many thanks,
> > Roy
> >> It works in my applications -
> >> --
> >> Sandra Daigle
> >> [Microsoft Access MVP]
> >> For the benefit of others please post all replies to this newsgroup.
> >>> Never tested there, though there is nothing that should keep it from
> >>> working that immediately comes to mind.
> >>>> Will TSISOON work with Access XP? I have it workng
> >>>> nicely with 2000 but have just moved to XP and it seems
> >>>> to have stopped working. Are there any workarounds?
> >>>> The info on www.trigeminal.com seems to indicate that it only works
> >>>> with 2000 or 97. Any thoughts?
> >>>> Thanks,
> >>>> Roy
|
| Mon, 02 May 2005 01:55:10 GMT |
|
|
|
mbila8
#11 / 14
|
Will Tsisoon work with Access XP? Does TSISOON work with access runtime. cannot get it to work.
I get it to work with access 2000 and access xp.
Any suggestions...
Originally posted by Rzb
Quote: > Hmm... No wait a moment - I had missed it - not in there so you were > right!!!! :-) > Roy
> ngp09[/url]...
> > Bob,
> > Yes,it is just not in the snippet.... Thanks.
> > However thinking about it... does it matter.
> > The application is going to get closed anyway...
> > Many thanks,
> > Roy
> > > Don't forget to do this before leaving the function:
> > > Set tsd = Nothing
> > > HTH
> > > Bob Hairgrove
> > > On Mon, 11 Nov 2002 22:22:09 -0000, "RzB"
> > > >Hmmm.... Seems to work first time after opening Access but
> next
> > > >invocation it wont close down... This is the code I'm using
> to execute
> > > >tsisoon.... am I missing anything? Works fine with Access
> 2000.
> > > >Dim tsd As Object
> > > >Set tsd = CreateObject("TsiSoon90.Connect80")
> > > >With tsd
> > > > .FileToOpen = Application.CurrentProject.Path &
> "\MaplXP.mdb"
> > > > .Exclusive = False
> > > > .CloseAll Application
> > > >End With
-- Posted via http://dbforums.com
|
| Tue, 04 Oct 2005 22:45:21 GMT |
|
|
|
michk
#12 / 14
|
Will Tsisoon work with Access XP? No, it does not. The Access product does not allow Access to stay open without a currentdb. --
MichKa [MS]
This posting is provided "AS IS" with
no warranties, and confers no rights.
Quote: > Does TSISOON work with access runtime. cannot get it to work.
> I get it to work with access 2000 and access xp.
> Any suggestions...
> Originally posted by Rzb
> > Hmm... No wait a moment - I had missed it - not in there so you were
> > right!!!! :-)
> > Roy
> > ngp09[/url]...
> > > Bob,
> > > Yes,it is just not in the snippet.... Thanks.
> > > However thinking about it... does it matter.
> > > The application is going to get closed anyway...
> > > Many thanks,
> > > Roy
> > > > Don't forget to do this before leaving the function:
> > > > Set tsd = Nothing
> > > > HTH
> > > > Bob Hairgrove
> > > > On Mon, 11 Nov 2002 22:22:09 -0000, "RzB"
> > > > >Hmmm.... Seems to work first time after opening Access but
> > next
> > > > >invocation it wont close down... This is the code I'm using
> > to execute
> > > > >tsisoon.... am I missing anything? Works fine with Access
> > 2000.
> > > > >Dim tsd As Object
> > > > >Set tsd = CreateObject("TsiSoon90.Connect80")
> > > > >With tsd
> > > > > .FileToOpen = Application.CurrentProject.Path &
> > "\MaplXP.mdb"
> > > > > .Exclusive = False
> > > > > .CloseAll Application
> > > > >End With
> --
> Posted via http://dbforums.com
|
| Tue, 04 Oct 2005 23:57:45 GMT |
|
|
|
michk
#13 / 14
|
Will Tsisoon work with Access XP? (I am referring to the runtime, below)
Quote: > No, it does not. The Access product does not allow Access to stay open > without a currentdb. > --
> MichKa [MS]
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
> > Does TSISOON work with access runtime. cannot get it to work.
> > I get it to work with access 2000 and access xp.
> > Any suggestions...
> > Originally posted by Rzb
> > > Hmm... No wait a moment - I had missed it - not in there so you were
> > > right!!!! :-)
> > > Roy
> > > ngp09[/url]...
> > > > Bob,
> > > > Yes,it is just not in the snippet.... Thanks.
> > > > However thinking about it... does it matter.
> > > > The application is going to get closed anyway...
> > > > Many thanks,
> > > > Roy
> > > > > Don't forget to do this before leaving the function:
> > > > > Set tsd = Nothing
> > > > > HTH
> > > > > Bob Hairgrove
> > > > > On Mon, 11 Nov 2002 22:22:09 -0000, "RzB"
> > > > > >Hmmm.... Seems to work first time after opening Access but
> > > next
> > > > > >invocation it wont close down... This is the code I'm using
> > > to execute
> > > > > >tsisoon.... am I missing anything? Works fine with Access
> > > 2000.
> > > > > >Dim tsd As Object
> > > > > >Set tsd = CreateObject("TsiSoon90.Connect80")
> > > > > >With tsd
> > > > > > .FileToOpen = Application.CurrentProject.Path &
> > > "\MaplXP.mdb"
> > > > > > .Exclusive = False
> > > > > > .CloseAll Application
> > > > > >End With
> > --
> > Posted via http://dbforums.com
|
| Wed, 05 Oct 2005 00:01:12 GMT |
|
|
|
mbila8
#14 / 14
|
Will Tsisoon work with Access XP? Thanks, that is what I thought.
Have a great weekend!
Originally posted by Michael \ Kaplan
Quote: > No, it does not. The Access product does not allow Access to stay open > without a currentdb. > --
> MichKa [MS]
> This posting is provided "AS IS" with
> no warranties, and confers no rights.
> bforums.com[/url]...
> > Does TSISOON work with access runtime. cannot get it to
> work.
> > I get it to work with access 2000 and access xp.
> > Any suggestions...
> > Originally posted by Rzb
> > > Hmm... No wait a moment - I had missed it - not in there so
> you were
> > > right!!!! :-)
> > > Roy
> > > ngp09[/url]...
> > > > Bob,
> > > > Yes,it is just not in the snippet.... Thanks.
> > > > However thinking about it... does it matter.
> > > > The application is going to get closed anyway...
> > > > Many thanks,
> > > > Roy
> > > > > Don't forget to do this before leaving the function:
> > > > > Set tsd = Nothing
> > > > > HTH
> > > > > Bob Hairgrove
> :3dd153a0.1-[/url]
> > > > > On Mon, 11 Nov 2002 22:22:09 -0000, "RzB"
> > > > > >Hmmm.... Seems to work first time after opening Access
> but
> > > next
> > > > > >invocation it wont close down... This is the code I'm
> using
> > > to execute
> > > > > >tsisoon.... am I missing anything? Works fine with
> Access
> > > 2000.
> > > > > >Dim tsd As Object
> > > > > >Set tsd = CreateObject("TsiSoon90.Connect80")
> > > > > >With tsd
> > > > > > .FileToOpen = Application.CurrentProject.Path &
> > > "\MaplXP.mdb"
> > > > > > .Exclusive = False
> > > > > > .CloseAll Application
> > > > > >End With
> > --
> Posted via
http://dbforums.com/http://dbforums.com --
Posted via http://dbforums.com
|
| Wed, 05 Oct 2005 03:27:31 GMT |
|
| |
