A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Law Tracks Example db



 
 
Thread Tools Display Modes
  #1  
Old July 6th, 2009, 10:09 PM posted to microsoft.public.access
JK[_4_]
external usenet poster
 
Posts: 51
Default Law Tracks Example db

In the Law Tracks example db in the frmSplash form the on timer event has
a feature called ReConnect that goes through a series of functions checking
to see if the backend is available. I've tried to incorporate this into my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features and if
so, can offer some good advice.

As always - much appreciated.

Jason
  #2  
Old July 7th, 2009, 02:19 AM posted to microsoft.public.access
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Law Tracks Example db

JK,

I've never seen this database on the Microsoft Templates site. Where did
you get it? To answer your question one would need to see the database
example.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
In the Law Tracks example db in the frmSplash form the on timer event
has
a feature called ReConnect that goes through a series of functions
checking
to see if the backend is available. I've tried to incorporate this into my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features and
if
so, can offer some good advice.

As always - much appreciated.

Jason



  #3  
Old July 7th, 2009, 03:19 PM posted to microsoft.public.access
JK[_4_]
external usenet poster
 
Posts: 51
Default Law Tracks Example db

I don't remember where I found it. I'm completely self-taught and I relied
heavily on the example databases I found online by doing random searches. One
of the more comprehensive examples out there would be the Law Tracks db. I’m
sure if you did a search using “Law Tracks” you would find it.

The function I’m having trouble with checks the backend during the on load
event of my Splash form. It tries to link up with a table in the backend. If
it cannot connect, then it asks the user to navigate to the backend, select
it, and then it tries to reconnect. This has never worked for me the way I’m
sure it was intended to work.

Rather than trying to get the Law Tracks Reconnect/AttachAgain examples to
work, maybe someone has another way to check for the ability to connect to
the backend during the login process and if the backend is not available
display an error?

I’m trying to prevent the application from crashing if the network is
unavailable and the user cannot gain access to the backend.

Any help would be appreciated.

Regards,
Jason

"Gina Whipp" wrote:

JK,

I've never seen this database on the Microsoft Templates site. Where did
you get it? To answer your question one would need to see the database
example.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
In the Law Tracks example db in the frmSplash form the on timer event
has
a feature called ReConnect that goes through a series of functions
checking
to see if the backend is available. I've tried to incorporate this into my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features and
if
so, can offer some good advice.

As always - much appreciated.

Jason




  #4  
Old July 8th, 2009, 03:37 AM posted to microsoft.public.access
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Law Tracks Example db

"This has never worked for me the way I'm sure it was intended to
work." doesn't communicate any specific symptoms. What does it do?
Exactly what error message(s) received? What have you already done to
debug it? Has that application ever worked for you on its current
system? If so, what changed before the symptoms appeared?

While I've never seen that particular application either, your
description of the over all process sounds like something I recognize
from way back when.

HTH
--
-Larry-
--

"JK" jasonk at necoffeeco dot com wrote in message
...
I don't remember where I found it. I'm completely self-taught and I

relied
heavily on the example databases I found online by doing random

searches. One
of the more comprehensive examples out there would be the Law Tracks

db. I'm
sure if you did a search using "Law Tracks" you would find it.

The function I'm having trouble with checks the backend during the

on load
event of my Splash form. It tries to link up with a table in the

backend. If
it cannot connect, then it asks the user to navigate to the backend,

select
it, and then it tries to reconnect. This has never worked for me the

way I'm
sure it was intended to work.

Rather than trying to get the Law Tracks Reconnect/AttachAgain

examples to
work, maybe someone has another way to check for the ability to

connect to
the backend during the login process and if the backend is not

available
display an error?

I'm trying to prevent the application from crashing if the network

is
unavailable and the user cannot gain access to the backend.

Any help would be appreciated.

Regards,
Jason

"Gina Whipp" wrote:

JK,

I've never seen this database on the Microsoft Templates site.

Where did
you get it? To answer your question one would need to see the

database
example.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -

Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
In the Law Tracks example db in the frmSplash form the on

timer event
has
a feature called ReConnect that goes through a series of

functions
checking
to see if the backend is available. I've tried to incorporate

this into my
db. However, I've never been able to get it working correctly. I

was
wondering if anyone out there has any experience with these

features and
if
so, can offer some good advice.

As always - much appreciated.

Jason






  #5  
Old July 8th, 2009, 03:37 AM posted to microsoft.public.access
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Law Tracks Example db

"This has never worked for me the way I'm sure it was intended to
work." doesn't communicate any specific symptoms. What does it do?
Exactly what error message(s) received? What have you already done to
debug it? Has that application ever worked for you on its current
system? If so, what changed before the symptoms appeared?

While I've never seen that particular application either, your
description of the over all process sounds like something I recognize
from way back when.

HTH
--
-Larry-
--

"JK" jasonk at necoffeeco dot com wrote in message
...
I don't remember where I found it. I'm completely self-taught and I

relied
heavily on the example databases I found online by doing random

searches. One
of the more comprehensive examples out there would be the Law Tracks

db. I'm
sure if you did a search using "Law Tracks" you would find it.

The function I'm having trouble with checks the backend during the

on load
event of my Splash form. It tries to link up with a table in the

backend. If
it cannot connect, then it asks the user to navigate to the backend,

select
it, and then it tries to reconnect. This has never worked for me the

way I'm
sure it was intended to work.

Rather than trying to get the Law Tracks Reconnect/AttachAgain

examples to
work, maybe someone has another way to check for the ability to

connect to
the backend during the login process and if the backend is not

available
display an error?

I'm trying to prevent the application from crashing if the network

is
unavailable and the user cannot gain access to the backend.

Any help would be appreciated.

Regards,
Jason

"Gina Whipp" wrote:

JK,

I've never seen this database on the Microsoft Templates site.

Where did
you get it? To answer your question one would need to see the

database
example.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -

Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
In the Law Tracks example db in the frmSplash form the on

timer event
has
a feature called ReConnect that goes through a series of

functions
checking
to see if the backend is available. I've tried to incorporate

this into my
db. However, I've never been able to get it working correctly. I

was
wondering if anyone out there has any experience with these

features and
if
so, can offer some good advice.

As always - much appreciated.

Jason






  #6  
Old July 8th, 2009, 06:40 AM posted to microsoft.public.access
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Law Tracks Example db

JK,

I did a search on Law Tracks and it netted me nothing. But if all you are
trying to do is link/relink tables have a look at...

http://www.mvps.org/access/tables/tbl0009.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
I don't remember where I found it. I'm completely self-taught and I relied
heavily on the example databases I found online by doing random searches.
One
of the more comprehensive examples out there would be the Law Tracks db. I'm
sure if you did a search using "Law Tracks" you would find it.

The function I'm having trouble with checks the backend during the on load
event of my Splash form. It tries to link up with a table in the backend.
If
it cannot connect, then it asks the user to navigate to the backend,
select
it, and then it tries to reconnect. This has never worked for me the way I'm
sure it was intended to work.

Rather than trying to get the Law Tracks Reconnect/AttachAgain examples to
work, maybe someone has another way to check for the ability to connect to
the backend during the login process and if the backend is not available
display an error?

I'm trying to prevent the application from crashing if the network is
unavailable and the user cannot gain access to the backend.

Any help would be appreciated.

Regards,
Jason

"Gina Whipp" wrote:

JK,

I've never seen this database on the Microsoft Templates site. Where did
you get it? To answer your question one would need to see the database
example.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"JK" jasonk at necoffeeco dot com wrote in message
...
In the Law Tracks example db in the frmSplash form the on timer
event
has
a feature called ReConnect that goes through a series of functions
checking
to see if the backend is available. I've tried to incorporate this into
my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features
and
if
so, can offer some good advice.

As always - much appreciated.

Jason






  #7  
Old July 8th, 2009, 07:22 AM posted to microsoft.public.access
Jeff Conrad [MSFT]
external usenet poster
 
Posts: 233
Default Law Tracks Example db

Hi Jason,

The LawTrack Contacts database is one of the main sample databases found in John Viescas' Access
2003 Inside Out book.

To assist you further, I think we're going to need some more information. Specifically,
1. What version of Access are you using?
2. Does the database work as is with the reconnecting code?
3. What errors are you getting when you try and incorporate this into your own application?

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"JK" wrote in message:
...

In the Law Tracks example db in the frmSplash form the on timer event has
a feature called ReConnect that goes through a series of functions checking
to see if the backend is available. I've tried to incorporate this into my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features and if
so, can offer some good advice.

As always - much appreciated.

Jason



  #8  
Old July 8th, 2009, 02:58 PM posted to microsoft.public.access
John Viescas
external usenet poster
 
Posts: 1
Default Law Tracks Example db

Thanks for jumping in there, Jeff.

Jason - can you answer Jeff's questions?

John Viescas, author
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

"Jeff Conrad [MSFT]" wrote in message
...
Hi Jason,

The LawTrack Contacts database is one of the main sample databases found
in John Viescas' Access 2003 Inside Out book.

To assist you further, I think we're going to need some more information.
Specifically,
1. What version of Access are you using?
2. Does the database work as is with the reconnecting code?
3. What errors are you getting when you try and incorporate this into your
own application?

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"JK" wrote in message:
...

In the Law Tracks example db in the frmSplash form the on timer event
has
a feature called ReConnect that goes through a series of functions
checking
to see if the backend is available. I've tried to incorporate this into
my
db. However, I've never been able to get it working correctly. I was
wondering if anyone out there has any experience with these features and
if
so, can offer some good advice.

As always - much appreciated.

Jason





  #9  
Old July 8th, 2009, 03:53 PM posted to microsoft.public.access
Hans Up
external usenet poster
 
Posts: 284
Default Law Tracks Example db

JK wrote:
The function I’m having trouble with checks the backend during the on load
event of my Splash form. It tries to link up with a table in the backend. If
it cannot connect, then it asks the user to navigate to the backend, select
it, and then it tries to reconnect. This has never worked for me the way I’m
sure it was intended to work.

Rather than trying to get the Law Tracks Reconnect/AttachAgain examples to
work, maybe someone has another way to check for the ability to connect to
the backend during the login process and if the backend is not available
display an error?

I’m trying to prevent the application from crashing if the network is
unavailable and the user cannot gain access to the backend.


Please clarify what you hope to accomplish. What database will the user
reconnect to when the network is unavailable?
  #10  
Old July 8th, 2009, 04:18 PM posted to microsoft.public.access
Armen Stein
external usenet poster
 
Posts: 507
Default Law Tracks Example db

On Tue, 7 Jul 2009 07:19:02 -0700, JK jasonk at necoffeeco dot com
wrote:

Rather than trying to get the Law Tracks Reconnect/AttachAgain examples to
work, maybe someone has another way to check for the ability to connect to
the backend during the login process and if the backend is not available
display an error?


I'm sure John Viescas's code will work when you figure out what's
going on. But if you want an alternative for automatic Access table
relinking, you're welcome to incorporate our free J Street Access
Relinker at:
http://www.jstreettech.com/downloads

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.