i have made a database in Access for a business, and the business now wants
to get rid of it because they say it will be too much hassel to put this onto
the network for everyone to use. please advise me how easy or difficult
Access is to put onto a Network, and explain how i would go about doing this.

"Laura Rawstron" <Laura (E-Mail Removed)> wrote in message
news:533637DD-EA3E-4778-8FC2-(E-Mail Removed)...
>i have made a database in Access for a business, and the business now wants
> to get rid of it because they say it will be too much hassel to put this
> onto
> the network for everyone to use. please advise me how easy or difficult
> Access is to put onto a Network, and explain how i would go about doing
> this.

You need to split the database into front/back ends, put the back end on the
server and give each user their own front end. No hassle at all really.
Search the help for "split database".

Remember though that there are security implications for your data in such
an environment that you would need to address, unless you want all and
sundry to be able to edit, add and delete data (and indeed the back end
file).

Regards,
Keith.
www.keithwilby.com

Depending on the number of users, it may be as simple as placing it on the
LAN and moving on. If you have more than a few users accessing the file at
one time, I'd probably create a front-end version of the database that
contains all the forms, queries, and reports, but no actual data. I'd put
the data only on the LAN and then link the front-ends to that data. This is
called 'splitting the database'.

In either case, very little work.

--
Rick B



"Laura Rawstron" <Laura (E-Mail Removed)> wrote in message
news:533637DD-EA3E-4778-8FC2-(E-Mail Removed)...
> i have made a database in Access for a business, and the business now
wants
> to get rid of it because they say it will be too much hassel to put this
onto
> the network for everyone to use. please advise me how easy or difficult
> Access is to put onto a Network, and explain how i would go about doing
this.

Thankyou Keith for your help. I have looked on your web site and i'm sure
that i should be able to master the art of Access database! Thanks Laura

"Keith" wrote:

> "Laura Rawstron" <Laura (E-Mail Removed)> wrote in message
> news:533637DD-EA3E-4778-8FC2-(E-Mail Removed)...
> >i have made a database in Access for a business, and the business now wants
> > to get rid of it because they say it will be too much hassel to put this
> > onto
> > the network for everyone to use. please advise me how easy or difficult
> > Access is to put onto a Network, and explain how i would go about doing
> > this.
>
> You need to split the database into front/back ends, put the back end on the
> server and give each user their own front end. No hassle at all really.
> Search the help for "split database".
>
> Remember though that there are security implications for your data in such
> an environment that you would need to address, unless you want all and
> sundry to be able to edit, add and delete data (and indeed the back end
> file).
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>