Copy ODBC table links to new build of Access XP>

  • Thread starter Thread starter Mark Hammer
  • Start date Start date
M

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.
 
Mark said:
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?
Click to expand...

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.
 
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
 
Mark Hammer said:
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.
Click to expand...

You could include code at startup that creates the links.
 
Back
Top