Editing Multiple instances of the same database?

I have a database that I designed for the production floor of my
company. One of the problems that I have encountered is that 2 or more
users will try to access the database to enter information at the same
time. It has caused a lot of problems with the stability of the
database lately. Is this possible in Access? I know that multiple
users can view database information at the same time, but can multiple
users also edit? Thanks in advance.

-Ryan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

re: Editing Multiple instances of the same database?

Is the database split into frontend/backend? Does each station have
its own copy of the FE?

If that is the case then there should be few problems with multiple
users viewing and modifying data.

What do you mean by stability?

- Jim

On 04 Nov 2003 22:51:10 GMT, Ryan Muller <rpm88_saxman@hotmail.com>
wrote:
[color=blue]
>I have a database that I designed for the production floor of my
>company. One of the problems that I have encountered is that 2 or more
>users will try to access the database to enter information at the same
>time. It has caused a lot of problems with the stability of the
>database lately. Is this possible in Access? I know that multiple
>users can view database information at the same time, but can multiple
>users also edit? Thanks in advance.
>
>-Ryan
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it![/color]

re: Editing Multiple instances of the same database?

What do you mean by front end and back end?

-Ryan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

re: Editing Multiple instances of the same database?

That is why you're having problems!

Briefly, the back-end (BE) database contains all of the tables, but none of
the queries, forms, reports, macros or modules. The front-end (FE) database
contains all of the queries, forms, reports, macros & modules, and >>links
to<< the tables in the BE. There is a single copy of the BE, on the server.
Each user has their own copy of the FE. This is the proper setup for
achieving reliable multi-user operation.

Google for those terms in this newsgroup, or around the web. There will
doubtless be gazillions of hits.

HTH,
TC


"Ryan Muller" <rpm88_saxman@hotmail.com> wrote in message
news:3fa8552b$0$194$75868355@news.frii.net...[color=blue]
> What do you mean by front end and back end?
>
> -Ryan
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]