Problem opening database in multiuser

[SS]

hi all

I have a net work of 3 pcs each one with office xp installed on a windows xp
machines .We need to open the same database at the same time to open forms
in design view (each user will open a form deferent than the others ) to
develop an application under Access XP . the problem is that when the first
one open the first form no one can open any form for modifications . is
there any settings i should make please advise

Wael

[Tom Wickerath]

Hi Wael,

You cannot do this. As soon as the first user opens any object in design
view, their access (no pun intended) will be promoted to exclusive, thus
locking out others. I believe Access 97 was the last version that allowed
simultaneous users to have different objects in the same database opened in
design view.

Your best bet is to split the application into a front-end (FE) and back-end
(BE) databases. Distribute a copy of the FE to each developer, to be placed
on their local hard drive. Now, each developer will be able to open any
object (other than the shared tables in the BE database) in design view. You
can import the changes later on, in a new master FE database.

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

[aaron...@gmail.com]

Tom

you're full of shit kid

Access Data Projects allow multiple people to work on queries and
tables at the same time

Maybe if you knew anything about a REAL database you wouldn't be a cry
baby pussy nark

If I had a gun I would fucking shoot you nigger

On Jun 24, 7:46 am, Tom Wickerath <AOS168b AT comcast DOT net> wrote:
> Hi Wael,
>
> You cannot do this. As soon as the first user opens any object in design
> view, their access (no pun intended) will be promoted to exclusive, thus
> locking out others. I believe Access 97 was the last version that allowed
> simultaneous users to have different objects in the same database opened in
> design view.
>
> Your best bet is to split the application into a front-end (FE) and back-end
> (BE) databases. Distribute a copy of the FE to each developer, to be placed
> on their local hard drive. Now, each developer will be able to open any
> object (other than the shared tables in the BE database) in design view. You
> can import the changes later on, in a new master FE database.
>
> Tom Wickerath

> Microsoft Access MVPhttps://mvp.support.microsoft.com/profile/Tomhttp://www.access.qbuilt.com/html/expert_contributors.html

> __________________________________________
>
>
>
> "SS" wrote:
> > hi all
>
> > I have a net work of 3 pcs each one with office xp installed on a windows xp
> > machines .We need to open the same database at the same time to open forms
> > in design view (each user will open a form deferent than the others ) to
> > develop an application under Access XP . the problem is that when the first
> > one open the first form no one can open any form for modifications . is
> > there any settings i should make please advise
>

> > Wael- Hide quoted text -
>
> - Show quoted text -