| Author |
Is Access multi-user by default ?
|
|
| Chris Thorpe 2005-04-26, 8:25 pm |
| Is Access multi-user or is there a specific version that is multi-user ?
Thanks
Chris
| |
| Rick Brandt 2005-04-26, 8:25 pm |
| "Chris Thorpe" <chris4t@airmail.net> wrote in message
news:116tf9n649h6790
@corp.supernews.com...
> Is Access multi-user or is there a specific version that is multi-user ?
> Thanks
> Chris
It is multi-user capable out of the box. There are certain practices that are
highly recommended when having multiple users, but there is nothing different
about Access or the file required.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
| |
| Chris Thorpe 2005-04-26, 8:25 pm |
| Thanks for the quick response
Where would I find the best practices ?
I have a client that is having problems with the program crashing their
system when more than one user is accessing it at the same time...
It is not on a server, peer to peer network with shares
Thanks
Chris
"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:4cAbe.1321$461.14@newssvr11.news.prodigy.com...
> "Chris Thorpe" <chris4t@airmail.net> wrote in message
> news:116tf9n649h6790
@corp.supernews.com...
>
> It is multi-user capable out of the box. There are certain practices that
are
> highly recommended when having multiple users, but there is nothing
different
> about Access or the file required.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
| |
| Rick Brandt 2005-04-26, 8:25 pm |
| > "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
> news:4cAbe.1321$461.14@newssvr11.news.prodigy.com...
> are
> different
>
>"Chris Thorpe" <chris4t@airmail.net> wrote in message
> news:116tko7cv2o9r02
@corp.supernews.com...
> Thanks for the quick response
> Where would I find the best practices ?
> I have a client that is having problems with the program crashing their
> system when more than one user is accessing it at the same time...
> It is not on a server, peer to peer network with shares
The most basic step is to split the app into a "tables only" file and another
file with everything else. The second file contains links to the tables in the
first. The data file is the one that is shared over the network while each user
has his own locally stored copy of the front end file. Having multiple users
simultaneously in the same monolithic file leads to file corruptions and this
might be what your client is seeing.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
| |
| Larry Linson 2005-04-27, 3:24 am |
| "Chris Thorpe" wrote
> Where would I find the best practices ?
> I have a client that is having problems
> with the program crashing their system
> when more than one user is accessing it
> at the same time... It is not on a server,
> peer to peer network with shares
In addition to Rick's very accurate admonition about splitting the database
and giving each user a copy of the front end, there's an introductory
presentation on Access in a Multiuser Environment that I did for my user
group that you can download from http://appdevissues.tripod.com. It will
identify topics that I thought worthwhile to discuss, and a bit more. The
best collection of detailed information and links on the subject of Access
in the multiuser environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.
Larry Linson
Microsoft Access MVP
| |
| Chris Thorpe 2005-04-27, 1:24 pm |
| Larry
Where is the introductory presentation on Access ?
Looked under downloads on your site
Chris
"Larry Linson" <bouncer@localhost.not> wrote in message
news:ewtAt$tSFHA.2916@TK2MSFTNGP15.phx.gbl...
> "Chris Thorpe" wrote
>
>
> In addition to Rick's very accurate admonition about splitting the
database
> and giving each user a copy of the front end, there's an introductory
> presentation on Access in a Multiuser Environment that I did for my user
> group that you can download from http://appdevissues.tripod.com. It will
> identify topics that I thought worthwhile to discuss, and a bit more. The
> best collection of detailed information and links on the subject of Access
> in the multiuser environment is at MVP Tony Toews' site,
> http://www.granite.ab.ca/accsmstr.htm.
>
> Larry Linson
> Microsoft Access MVP
>
>
|
|
|
|