Network interruption

[Pietro]

Hi,

As my network is not stable,sometimes the connection between the be and
the fe is interrupted,the fields on all forms are full of the word
"#Name",user in this case should close the database and reopen it,this makes
me loses much time.

Can i reconnect the be and the fe through a VB code without having to close
and reopen the database ?

 

[Douglas J. Steele]

There's code at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" for reconnecting, but you really should see if you can improve the
reliability of your network. Access is extremely sensitive to network
issues, and you'll end up corrupting your database if you're not lucky.
Hopefully you're not trying to use a wireless network: they're almost never
capable of supporting Access.

 

[Pietro]

Thank you Douglas for you professional reply...
I saw the code but i don't know where's to put it...

 

[a a r o n . k e m p f]

the kids around here blame everything on the network.

It might not be the network-- Maybe MS Access just can't 'keep it up'

Move to SQL Server and see if you have the same problem then.
With ADP, you don't need to link _ANYTHING_ you just set the server /
db name in _ONE_ place

-Aaron

 

[Tony Toews [MVP]]

the kids around here blame everything on the network.

It might not be the network-- Maybe MS Access just can't 'keep it up'
Rubbish.

Move to SQL Server and see if you have the same problem then.
With ADP, you don't need to link _ANYTHING_ you just set the server /
db name in _ONE_ place

ADPs haven't been updated in several versions of Access and thus are
dead end technology.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Douglas J. Steele]

Well, you asked "Can i reconnect the be and the fe through a VB code". How
did you envision doing it?

If you were thinking in terms of having a button that the user would click
on, have the OnClick event call the fRefreshLinks function from that page.

 

[Pietro]

Can you please mention more details ..
If i want to copy and paste the code,where can i put it ?
how can i call the function..
Thank you anyway for your guidance

 

[Peter Hibbs]

Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

 

[Pietro]

Hi Peter,
The link is not working...

Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

 

[Peter Hibbs]

Pietro,

Try http://www.rogersaccesslibrary.com/index.htm and click on Other
Developers Libraries, you should find it there under my name.

Peter Hibbs.

 

[Douglas J. Steele]

Copy the code from that page (what's in the shaded section between Code
Start and Code End) and paste it into a new module (not a class module nor a
module associated with a form or report). Make sure you do not name the
module the same as any routines within it.

You can then either set the OnClick property for your button to

=fRefreshLinks()

(remember to include the equal sign and parentheses)

or you can set the property to [Event Procedure] and then create a routine
like

Private Sub MyButton_Click()

Call fRefreshLinks

End Sub

(replace MyButton with the name of your command button)

 

[a a r o n . k e m p f]

MDBs haven't been updated in several versions of Access and thus are
dead end technology.

Aaron

 

[a a r o n . k e m p f]

give a url -- I don't see any evidence of this.

It's just not true, you dirty lying homo-canadian

 

[david s.]

Consider making a hidden form with a connection to a table and keep that
connection active anytime the FE is open.

also, if it can be applied to your situation, Terminal Server will eliminate
this problem completely. with the FE and BE on the same server, the
connection between them is not lost, and you will access the FE via a
terminal server session and if you lose connection everthing will be as you
left it when the connection is re-established. it works very well for my
company.