relinking split database

[rossz]

I'm in the process of splitting the database to simplify updating people
when changes are made to reports and such (it's currently a real pain
the rear) and to make it happier in a multiuser environment.

The plan is to keep the data portion on the server and install the
query/report portion on the workstations. The problem is getting the
client side to locate the data portion on the server. When a client
starts up I'd like it to display a message and give the user the
opportunity to browse for the correct server side database and
automatically relink everything.

Can someone point me to some code that does this?

I'm working in Access 2002, but I might need to be backwards compatible
with 2000.

Thanks.

 

[Larry Daugherty]

You'll find some code at www.mvps.org/access It gives you enough to get the
job done and you'll have to tweak it to fit your use.

HTH

 

[Graham R Seach]

Specifically http://www.mvps.org/access/tables/tbl0009.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Virgil]

Yes, I tested that code just today. Works fine when
there's a single back end source. Warning though! The
code listed on the
http://www.mvps.org/access/tables/tbl0009.htm is missing
several functions. You'll have to do a word search for
each when you get a compile error. I believe
http://www.mvps.org/access/api/api0001.htm has all the
missing functions. It's also linked on the tbl0009 page.

 

[Tony Toews]

I'm in the process of splitting the database to simplify updating people
when changes are made to reports and such (it's currently a real pain
the rear) and to make it happier in a multiuser environment.

The plan is to keep the data portion on the server and install the
query/report portion on the workstations. The problem is getting the
client side to locate the data portion on the server. When a client
starts up I'd like it to display a message and give the user the
opportunity to browse for the correct server side database and
automatically relink everything.

Also the following free utility may be of assistance.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

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