Is there a way to duplicate a linked table locally with only a front end
in [Getting Started]
|
Prev: Trying to use my database on a different pc
Next: Is there a way to duplicate a linked table locally with onlya front end
From: Isis on 21 Jun 2008 11:04 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
From: bhicks11 via AccessMonster.com on 21 Jun 2008 14:37 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 Isis wrote: >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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200806/1
From: John W. Vinson on 22 Jun 2008 18:26
On 21 Jun 2008 15:04:02 GMT, Isis <isissoft(a)NOSPAMbtinternet.com> wrote: >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 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. -- John W. Vinson [MVP] |