Re-link tables function

[m.cringle]

Hi folks!

I have found an example database which automatically checks whether it
is connected to the back end (if not it will let you select the correct
file) - much better than the usual error messages and messing about!

Only problem is that I'm unsure how to get it to work! I have copied
the required code in the module and it starts as "Public Sub
Competitor_AttachTables()". Anybody got any ideas how I can call this
when I open my database?

They have set-up their own password protection and the event seems to
be triggered by clicking the sign-in button on their login form - but I
am using the general access security (so no form)

(Example database can be found at
www.candace-tripp.com/download/boilerplate2k.zip)

Any assistance would be much appreciated - I'm lost (as usual)!

 

[Roger Carlson]

I'm not sure what your exact question is. Do you want to know how to
implement the User Login? Or just how to do the table relinking without the
security stuff.

If the latter, just add:
' reattach tables
Call BoilerPlate_AttachTables

in the On Open event of the first form your application opens.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[aaron.kempf]

if you used Access Data Projects then you woudln't have to worry about
this crap

relink and refresh is a pain in the butt

you just need to lose the training wheels and use Access Data Projects
exclusively

a single connection / logon.. much much simpler for real world use