copy linked tables local??

[sparkbyte]

Anyone have a way to copy linked tables to a local MDB from MS SQL Server? (preferrably without moving all data in the tables).

I need a way to create an empty copy of a Access Application, problem is that about a 3rd the tables are linked. Mostly on a SQL server and a few are in other Access databases.

How may I accomplish this?????




Thanks

John Fuhrman

 

[PWise]

use this code

SELECT [i]linkedtablename[/i].* INTO [i]localtablename[/i].* 
FROM [i]linkedtablename[/i].* 
WHERE 1<>1

 

[PWise]

This will make an empty copy of the linked table