View Single Post
  #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