Copy ODBC table links to new build of Access XP>

[Mark Hammer]

I have four linked tables, connected via ODBC to SQL_Server data source. I
make those links at my client site. Now I'd like to copy them into a new
build, at my office where I don't have access to the SQL Server BE.

When I try to import or link or copy/paste them, I'm told that "ODBC
connection failed."

Is there a way to copy these links into a new build, in the absence of the
BE?

TIA,

Mark Hammer
Lake Oswego, Oregon, U.S.

 

[Rick Brandt]

I have four linked tables, connected via ODBC to SQL_Server data
source. I make those links at my client site. Now I'd like to copy
them into a new build, at my office where I don't have access to the
SQL Server BE.
When I try to import or link or copy/paste them, I'm told that "ODBC
connection failed."

Is there a way to copy these links into a new build, in the absence
of the BE?

To what end? They won't be usable even if you copy them. If this is for
Testing you could import the tables instead of linking to them.

 

[Mark Hammer]

Rick,

I have imported some test data.

I'd like to be able to email my client a new front end without the need to
re-establish the links to the BE each time. Not a big deal, I know, but it
would be slick if I could do it.

--Mark Hammer

 

[Rick Brandt]

Rick,

I have imported some test data.

I'd like to be able to email my client a new front end without the need to
re-establish the links to the BE each time. Not a big deal, I know, but it
would be slick if I could do it.

You could include code at startup that creates the links.

 

[Duane Hookom]

Mark,
You might want to check out the code at Doug Steele's web page on linking
without creating a DSN http://www.accessmvp.com/djsteele/DSNLessLinks.html.

 

[Mark Hammer]

Thanks, Duane and Rick.

--Mark