Splitting Access 2000

[Trollina]

I have a medium sized Access 2000 database that has been split into
front end/back end. I need some help understanding what to do when I
add new tables to the database that I want on the network but linked
to the front end for all the users. Do I have to re-split the
database to do this - or is there a way to link without doing this.

I think I must be missing some fundamental point on this. Can anyone
help.

Thanks.

Lois

[Joan Wild]

Trollina wrote:

I have a medium sized Access 2000 database that has been split into
front end/back end. I need some help understanding what to do when I
add new tables to the database that I want on the network but linked
to the front end for all the users. Do I have to re-split the
database to do this - or is there a way to link without doing this.

I think I must be missing some fundamental point on this. Can anyone
help.

Open the backend and add the tables/relationships. Compact it.

Open your copy of the frontend, and link to the new tables (File, Get
External Data, Link Tables). Make other modifications to the frontend as
needed.

Compact the frontend. Distribute the frontend to your users - just
overwrite their existing frontend.

There are a number of ways you can automate distributing the frontend.

Use a batch file to copy the frontend from the server
or
http://www.databasejournal.com/featu...le.php/3286111
or
http://www.granite.ab.ca/access/autofe.htm

--
Joan Wild
Microsoft Access MVP

[Knud Rogilds]

Either right click in the database window and chose "Link Tables" or use
File | Use External Data | Link tables. Pick the back-end db and chose your
new tables.

[David W. Fenton]

tr******@shaw.ca (Trollina) wrote in
news:b1**************************@posting.google.c om:

I have a medium sized Access 2000 database that has been split
into front end/back end. I need some help understanding what to
do when I add new tables to the database that I want on the
network but linked to the front end for all the users. Do I have
to re-split the database to do this - or is there a way to link
without doing this.

I think I must be missing some fundamental point on this. Can
anyone help.

Adding new tables surely means that you'll need to distribute a new
front end, since the forms and reports based on those new tables
won't work without them.

So, in your new front end, just link to the new tables in the back
end and distribute it normally.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Knud Rogilds]

Either right click in the database window and chose "Link Tables" or use
File | Use External Data | Link tables. Pick the back-end db and chose your
new tables.