Linking Tables

[Ripper]

I am installing a database for a customer on their server next week. I set
up the backend of the database and I know the path to the file. Is there a
way to manually type in the location of the back end or do I have to go to
the site and set it up there? I have 2 front ends one in access 2000 and the
other in 97.

 

[Tim Ferguson]

Is there a
way to manually type in the location of the back end or do I have to
go to the site and set it up there?

There are lots of versions of code that will reset a front end to point to
a back end. Start at Dev's site <http://www.mvps.org/access>

If you need to roll your own, start by checking help on the
DAO.TableDef.Connect property.

Hope that helps


Tim F