Linking tables dynamically?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is there a way to link tables in Access dynamically? The prod and development servers can't speak to each other (yet) where I work and I'd like a way to change the full path depending on where I am with a simple click, instead of having to relink every single table when I move the front end from the prod server to the development server.
I'm already doing this for the references I have in VB code (opening an outside application from VB), I stored my possible paths in a table and activate the right one depending on where I am, then use DLookup to retrieve the path, thus removing the need to change the code itself every time. Is there a way to do this for the linked tables?
Thanks!
 
Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web"

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


audreybmorin said:
Hi,
Is there a way to link tables in Access dynamically? The prod and
Click to expand...
development servers can't speak to each other (yet) where I work and I'd
like a way to change the full path depending on where I am with a simple
click, instead of having to relink every single table when I move the front
end from the prod server to the development server.
I'm already doing this for the references I have in VB code (opening an
Click to expand...
outside application from VB), I stored my possible paths in a table and
activate the right one depending on where I am, then use DLookup to retrieve
the path, thus removing the need to change the code itself every time. Is
there a way to do this for the linked tables?
 
Back
Top