RefreshTableLinks Module in Solutions.mdb

[sweeneysmsm]

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

 

[Piet Linden]

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 versionof
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 amin
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

 

[sweeneysmsm]

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

 

[Allen Browne]

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