Split Database - Use Make Table Query in which part?

[RNelson]

Do I use a Make Table Query in the "regular" part of a
split database, or the .be?

 

[Michel Walsh]

Hi,


If the table has to be accessed by every one using the database, on the
back-end, if the table is just for that particular user, probably it is
better to do it in the front end. In other words, the back-end is the common
play ground, the front-end is just for the user, the "local", or private,
stuff.


Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,


If the table has to be accessed by every one using the database, on the
back-end, if the table is just for that particular user, probably it is
better to do it in the front end. In other words, the back-end is the common
play ground, the front-end is just for the user, the "local", or private,
stuff.


Hoping it may help,
Vanderghast, Access MVP