to split or not to split?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peanut1 - 30 Jun 2006 18:07 GMT

I have a shared Access 2003 database. It resides on a server, which is
accessed by 2 people besides mysel-, they use vpn and remote desktop to get
to the database on the server. In the database is a function for users that
can trigger an Outlook (email on the server) to a contact(s) in the database.

Currently database is not split into front end/back end. I want to know if
i split the database, where does the front end go for the remote users? on
their laptop? or on the server drive that the database is currently on? and
is there a way to configure this so that the database will trigger their own
personal email on their laptops instead of the email on the server?

Reply to this Message

Douglas J. Steele - 30 Jun 2006 19:19 GMT

While it's possible to have the front-end on the server, it's far better to
have it on each user's hard drive. It reduces network traffic.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a shared Access 2003 database. It resides on a server, which is
> accessed by 2 people besides mysel-, they use vpn and remote desktop to
[quoted text clipped - 12 lines]
> own
> personal email on their laptops instead of the email on the server?

Reply to this Message