How to spilt database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy - 30 Jul 2003 11:09 GMT

I am using an access program which is shared among several users, but always
get fatal corruptions. I have read the solution of spliting the database,
and provide the frontend copy to each users.

But i want to know how to split the database?
Thanks.

Reply to this Message

Frank Konzal - 30 Jul 2003 12:10 GMT

You can use the database splitter in Access or do what I do. Copy the database
to final location - network drive. Delete everything but the tables in this
database which now makes it the BE. In your original database delete the
tables. Click File, Get External Data and Link - then point it to the BE and
link to all the tables. Done deal. Oh, big deal, make a copy for safety's sake
before all the above.

> I am using an access program which is shared among several users, but always
> get fatal corruptions. I have read the solution of spliting the database,
> and provide the frontend copy to each users.
>
> But i want to know how to split the database?
> Thanks.

Reply to this Message

Randall Arnold - 30 Jul 2003 19:33 GMT

Your way might be better, Frank. I created my first split database last
night and the links were hard-coded rather than relative. Moving both the
BE and front-end to another folder rendered it unusable. At least with
Table linking I have the option to recreate links if the files are moved. I
can't see where a split database allows one to do that.

Randall Arnold

> You can use the database splitter in Access or do what I do. Copy the database
> to final location - network drive. Delete everything but the tables in this
[quoted text clipped - 9 lines]
> > But i want to know how to split the database?
> > Thanks.

Reply to this Message