Linking Alternative Sets of Tables

[Robert B via AccessMonster.com]

A client has 100 or so projects. Each project is managed by its own .mdb.
All the .mdb's are identical except for the data in two of the 32 tables (the
rest are non-dynamic reference tables). If I create a compiled .MDE file,
can I, via code, select a project data set (file) from a pull-down list
populated by a table in the .MDE containing project names and server paths)
and cause the tables to link to the .mde as they do using the Linking Manager?
Can this be done repeatedly with the same .MDE and different data files? I
assume that each workstation would require a copy of the .mde, but this would
make revison of the .mde much easier than having to deal with 100 .mdb's.

 

[Nick Coe \(UK\)]

Yes. You can do this in code using a version of the table
linking/relinking code from the mvps website or that
contained in The Access Developers Handbook (pub'd by
Sybex).

http://www.mvps.org/access/tables/tbl0012.htm

First modify the code for your own purposes.

Second call it from your autoexec macro or preset start up
form on open event.

Third probably need it as an option on your main form (menu)
or your menu bar.

Fourth you will need a copy of the front end mde on each
users pc.

Fifth take a look at the FE updater on Tony Toews site:
http://www.granite.ab.ca/access/autofe.htm

Sixth you might think about having a single standard back
end containing your non-dynamic reference tables then the
100 or so project mdb's with only project unique stuff in.

Seventh you need to think about whether it is a good idea to
have the 100 seperate projects in different mdb's or one
single one. There are pro's and con's for both. Seperate
ones are often used because of size or physical location, a
single one is easier to manage/backup. And so on...

Good luck
--
Nick Coe (UK)
Available - Will work for money
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Robert B via AccessMonster.com typed:

 

[Robert B via AccessMonster.com]

Many thanks, Nicki=, .... will try this next week

Yes. You can do this in code using a version of the table
linking/relinking code from the mvps website or that
contained in The Access Developers Handbook (pub'd by
Sybex).

http://www.mvps.org/access/tables/tbl0012.htm

First modify the code for your own purposes.

Second call it from your autoexec macro or preset start up
form on open event.

Third probably need it as an option on your main form (menu)
or your menu bar.

Fourth you will need a copy of the front end mde on each
users pc.

Fifth take a look at the FE updater on Tony Toews site:
http://www.granite.ab.ca/access/autofe.htm

Sixth you might think about having a single standard back
end containing your non-dynamic reference tables then the
100 or so project mdb's with only project unique stuff in.

Seventh you need to think about whether it is a good idea to
have the 100 seperate projects in different mdb's or one
single one. There are pro's and con's for both. Seperate
ones are often used because of size or physical location, a
single one is easier to manage/backup. And so on...

Good luck

A client has 100 or so projects. Each project is managed
by

[quoted text clipped - 18 lines]

the
.mde much easier than having to deal with 100 .mdb's.

 

[Robert B via AccessMonster.com]

Nick ... got it all working beautifully. It was a bit simpler than expected
because I didn't need to include the file search capability ... merely a
means to select a site from a list displayed in a list box.

Again, many thanks ...

Bob Boyden

 

[Nick Coe \(UK\)]

Good stuff

You're welcome.

Good luck.

--
Nick Coe (UK)
Available - Will work for money
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Robert B via AccessMonster.com typed: