Is there a way to duplicate a linked table locally with only a front end

I

Isis

I have a FE DB, I want to add some Tables locally that are duplicates
(structure only) of linked tables in the BE (which I don't have) - can this
be done either in VB or is some other process - maybe there is a simple
'copy' ?

Thanks
 
J

John Spencer

I know of no way to do this if you don't have the backend available.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
B

bhicks11 via AccessMonster.com

If you know the properties of the tables you can redesign them. It may be
painful to go through all your forms, queries, etc. and try to figure out
what the fields are, make them, test, etc.

Bonnie

http://www.dataplus-svc.com
 
J

John W. Vinson

I have a FE DB, I want to add some Tables locally that are duplicates
(structure only) of linked tables in the BE (which I don't have) - can this
be done either in VB or is some other process - maybe there is a simple
'copy' ?

Thanks
Click to expand...

Ummm... run a MakeTable query based on the linked table maybe??

Or File... Get External Data... Import; import the table from the backend,
choosing the "structure only" option.
 
Top