[AccessD] relations in which database

Hi Marcel

The main disadvantage is that it won't work.
As Charles wrote, relations have to reside in the backend.

Sometimes relations increase speed.

If Excel users should access the BE, relations can make this safe. If
not, create queries they can and must use.

If you need to adjust relations, open the BE exclusively and perform
the changes and close.

/gustav


> I am stugling with the following. In our current situation I have a FE and a
> BE database. The relationships are currently stored in the BE database. Now
> the question is why not put them in the FE database and just leave the plain
> tables in the be database.

> Advantages should be
> - performance in multiuser env.
> - more control over the database because with each update you can change,
> add a relationship
> - peoplo who want to access the database through excel, and so on have more
> trouble in comprending the database.
> - field updates, new tables are easily to create instead of using 3rd party
> backend updaters

> Are there disadvantages???