relinking backend

[chriske911]

wanting to be fancy I got code from Dev Ashish to relink the backend db

I have a main form that opens a dao.rs to get the forms to open, a
title for the main form, the current dev version and so on
when I open the dao.rs I get an error if the backend is not there

what is the best way to check if the backend is still there or not and
call the refreshlink code without giving the default msaccess error
first
if I use rs.eof = true I get "object variable not set" because rs is
still Nothing

thnx

 

[Tony Toews [MVP]]

wanting to be fancy I got code from Dev Ashish to relink the backend db

I have a main form that opens a dao.rs to get the forms to open, a
title for the main form, the current dev version and so on
when I open the dao.rs I get an error if the backend is not there

what is the best way to check if the backend is still there or not and
call the refreshlink code without giving the default msaccess error
first

Use the error on the dao.rs. That's what I do and it works for me.

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/

 

[chriske911]

Tony Toews [MVP] wrote on 5/12/2007 :

Use the error on the dao.rs. That's what I do and it works for me.

Tony

thought so ;-)

so I already used:
err_form:
if vberror = 10 then ....

and it does work

grtz