RefreshTableLinks Module in Solutions.mdb

I intend to split an .mdb I have developed in Access 2003 so that the
Back-End will reside on one computer (not server) and the FrontEnd will be on
each of the computers that need to access it along with a runtime version of
Access 2003.

I have never split a database before or set it up for sharing in this way.

I have been reading at
http://support.microsoft.com/kb/162522
and
http://support.microsoft.com/kb/154397/

They refer to a database called Solutions.mdb where one can find a Module
called RefreshTableLinks. I am unable to find the Solutions.mdb and so am in
the dark as to how to modify what I do not have.

I would appreciate any insight into this problem. Perhaps someone knows
where I can find it. I do have the Access Developer Extensions CD, the MSDN
Library for Microsoft Visual Studio.Net Discs 1-3 and a number of other discs
which deal with .Net.

Thanks.

Mary

On Sep 4, 1:54*pm, sweeneysmsm
wrote:
I intend to split an .mdb I have developed in Access 2003 so that the
Back-End will reside on one computer (not server) and the FrontEnd will be on
each of the computers that need to access it along with a runtime version of
Access 2003.

I have never split a database before or set it up for sharing in this way..

I have been reading athttp://support.microsoft.com/kb/162522
andhttp://support.microsoft.com/kb/154397/

They refer to a database called Solutions.mdb where one can find a Module
called RefreshTableLinks. I am unable to find the Solutions.mdb and so am in
the dark as to how to modify what I do not have.

I would appreciate any insight into this problem. Perhaps someone knows
where I can find it. I do have the Access Developer Extensions CD, the MSDN
Library for Microsoft Visual Studio.Net Discs 1-3 and a number of other discs
which deal with .Net.

Thanks.

Mary

something like this maybe?
http://www.mvps.org/access/tables/tbl0009.htm

Thank you so much, Piet.

I will have a go at it next week when I get back to work. What you have
shared with me looks very helpful. I will try and then let you know. This
will be a real achievement for me if I succeed. Thanks for your help. I will
publish with it the credit that was listed to Dev Ashish.

Mary

"Piet Linden" wrote:

On Sep 4, 1:54 pm, sweeneysmsm
wrote:
I intend to split an .mdb I have developed in Access 2003 so that the
Back-End will reside on one computer (not server) and the FrontEnd will be on
each of the computers that need to access it along with a runtime version of
Access 2003.

I have never split a database before or set it up for sharing in this way..

I have been reading athttp://support.microsoft.com/kb/162522
andhttp://support.microsoft.com/kb/154397/

They refer to a database called Solutions.mdb where one can find a Module
called RefreshTableLinks. I am unable to find the Solutions.mdb and so am in
the dark as to how to modify what I do not have.

I would appreciate any insight into this problem. Perhaps someone knows
where I can find it. I do have the Access Developer Extensions CD, the MSDN
Library for Microsoft Visual Studio.Net Discs 1-3 and a number of other discs
which deal with .Net.

Thanks.

Mary

something like this maybe?
http://www.mvps.org/access/tables/tbl0009.htm

This should give you the direct link to solutions.mdb:
http://www.mvps.org/access/downloads/bapp2000.exe

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sweeneysmsm" wrote in message
...
I intend to split an .mdb I have developed in Access 2003 so that the
Back-End will reside on one computer (not server) and the FrontEnd will be
on
each of the computers that need to access it along with a runtime version
of
Access 2003.

I have never split a database before or set it up for sharing in this way.

I have been reading at
http://support.microsoft.com/kb/162522
and
http://support.microsoft.com/kb/154397/

They refer to a database called Solutions.mdb where one can find a Module
called RefreshTableLinks. I am unable to find the Solutions.mdb and so am
in
the dark as to how to modify what I do not have.

I would appreciate any insight into this problem. Perhaps someone knows
where I can find it. I do have the Access Developer Extensions CD, the
MSDN
Library for Microsoft Visual Studio.Net Discs 1-3 and a number of other
discs
which deal with .Net.

Thanks.

Mary