Prev: Church Database - stevie pimps agan
Next: header full line but page 2 rows
From: DaveFrag on 24 Feb 2010 16:24
Is there a way to select the specific tables you want to split for sharing
across a network while other tables will remain local to each users system?
I specifically want to keep a version control table local to the system
rather than having it split with the other tables.
From: Dennis on 24 Feb 2010 17:30
Dave,

You can export individual tables from Tables windows. Right click on the
individual table and export it to the approrpriate backend.

The other option you have to to export everything and setup the links. Then
you can delete the local link to the approproate table and import just the
selected table(s) form the back end. I don't know how many tables you have
so I don't know which would be the fastest.

Good luck.

Dennis
From: DaveFrag on 25 Feb 2010 09:16
I appreciate your suggestion and did export the one table to my existing
back-end although how do I now link that table to the front-end so that it
knows that it's a linked table like the others?

"Dennis" wrote:

> Dave,
>
> You can export individual tables from Tables windows. Right click on the
> individual table and export it to the approrpriate backend.
>
> The other option you have to to export everything and setup the links. Then
> you can delete the local link to the approproate table and import just the
> selected table(s) form the back end. I don't know how many tables you have
> so I don't know which would be the fastest.
>
> Good luck.
>
> Dennis
From: BruceM via AccessMonster.com on 25 Feb 2010 15:27
In Access 2003 (and 2000, I expect, and maybe earlier versions), Tools >>
Database Utilities >> Linked Table Manager. I think it will be clear enough
once you get there. For Access 2007, I'm afraid I do not know offhand.


DaveFrag wrote:
>I appreciate your suggestion and did export the one table to my existing
>back-end although how do I now link that table to the front-end so that it
>knows that it's a linked table like the others?
>
>> Dave,
>>
>[quoted text clipped - 9 lines]
>>
>> Dennis

--
Message posted via http://www.accessmonster.com

From: Armen Stein on 28 Feb 2010 01:18
On Thu, 25 Feb 2010 20:27:34 GMT, "BruceM via AccessMonster.com"
<u54429(a)uwe> wrote:

>In Access 2003 (and 2000, I expect, and maybe earlier versions), Tools >>
>Database Utilities >> Linked Table Manager. I think it will be clear enough
>once you get there. For Access 2007, I'm afraid I do not know offhand.

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q. It's much nicer than Linked Table
Manager.

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

It doesn't touch local tables, so you are free to use them for your
version control technique. We use local tables for things like that
too.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 | 
Pages: 1
Prev: Church Database - stevie pimps agan
Next: header full line but page 2 rows