Home > Archive > MS Access database support > April 2006 > A2003 - Now Single User









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author A2003 - Now Single User
Neville Abbott

2006-04-07, 1:31 pm

Since we converted our ACCESS 97 databases to ACESSS 2003 they have
become single user only. Does anybody have any idea why this should
have happened, and how it can be resolved?

salad

2006-04-07, 8:27 pm

Neville Abbott wrote:
> Since we converted our ACCESS 97 databases to ACESSS 2003 they have
> become single user only. Does anybody have any idea why this should
> have happened, and how it can be resolved?
>

What do you mean, single-user? Do other people get locked out because
someone has the application opened exclusively? If so, perhaps a
desktop icon has a /excl in it.
Larry Linson

2006-04-08, 3:27 am

"Neville Abbott" <nabbott@omf.org.uk> wrote in message
news:1144431542.963022.34510@g10g2000cwb.googlegroups.com...
> Since we converted our ACCESS 97 databases to ACESSS 2003 they have
> become single user only. Does anybody have any idea why this should
> have happened, and how it can be resolved?


Like Salad, I have to ask "What do you mean by single-user?"

If you mean that a user must have exclusive use to modify objects in design
view, that is the way Access works from Access 2000 on.

In Access 97 and earlier versions, multiple users could be logged in,
changing a database from design view. This worked "most of the time", but
could cause (unrepairable) corruption.

If you mean something else, please clarify.

Larry Linson
Microsoft Access MVP


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com