MS Access Multiuser - sharing backend on NAS

Author

sharing backend on NAS

Jesper F

2005-12-27, 1:24 pm

I'm thinking of getting a Network Attached Storage such as a Synology:
http://www.synology.com/enu/product...e=overview.html
to share the backend of a FE-BE database with 2-5 users.
Is this possible? How fast must the transfer rates be for it to be reliable?
I know WAN is too slow but what transfer rates are sufficient?

Jesper

2005-12-27, 8:25 pm

> Is this possible?

Probably not.

The storage needs to support the database primitives (Get Record,
Put Record, Read Lock Record, Write Lock Record etc) as well as
the simple file operations.

But I can't read German. You would have to try it to see.

(david)

"Jesper F" <askfortheemail@ask.com> wrote in message
news:eOUhx1wCGHA.140@TK2MSFTNGP12.phx.gbl...
> I'm thinking of getting a Network Attached Storage such as a Synology:
>
http://www.synology.com/enu/product...e=overview.html
> to share the backend of a FE-BE database with 2-5 users.
> Is this possible? How fast must the transfer rates be for it to be
reliable?
> I know WAN is too slow but what transfer rates are sufficient?
>
>
> Jesper
>
>

Sylvain Lafontaine

2006-01-01, 1:24 pm

The specification page
http://www.synology.com/enu/product...?page=spec.html
say that it offers support for Microsoft Network CIFS; so you should be good
with Access.

However, before buying, you should know that these devices come without a
hard disk; which must be purchased separately.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

< david@epsomdotcomdot
au> wrote in message
news:ufDC1F1CGHA.2320@TK2MSFTNGP12.phx.gbl...
>
> Probably not.
>
> The storage needs to support the database primitives (Get Record,
> Put Record, Read Lock Record, Write Lock Record etc) as well as
> the simple file operations.
>
> But I can't read German. You would have to try it to see.
>
> (david)
>
> "Jesper F" <askfortheemail@ask.com> wrote in message
> news:eOUhx1wCGHA.140@TK2MSFTNGP12.phx.gbl...
> http://www.synology.com/enu/product...e=overview.html
> reliable?
>
>

Tony Toews

2006-01-08, 8:24 pm

"Jesper F" <askfortheemail@ask.com> wrote:

>I'm thinking of getting a Network Attached Storage such as a Synology:
>http://www.synology.com/enu/product...e=overview.html
>to share the backend of a FE-BE database with 2-5 users.
>Is this possible?

I'd be a little concerned about anything other than a server as tested
by Microsoft. It may work or not. Also for 2-5 users you could
just about use a Pentium 400 as a server.

The problem is that MS uses "phantom locks" in a non standard method.
So it may work well and may not. The following discussion is in
reference to Samba. Note that Novell does handle Access well. Well,
except for some versions and the OpLocks problem.

Samba, the Unix component which provides Windows networking services,
has been written to the documented specs and yet sometimes doesn't
work well. For many people this has worked quite well but others have
had lots of troubles.

ACC2000: Microsoft Access and Untested Networks - 209161
http://support.microsoft.com/?kbid=209161

I think ACC: Microsoft Jet Utilities Available [Q176670]
http://support.microsoft.com/?kbid=176670 has some detailed info on
"phantom locks" in the "Understanding Microsoft Jet Locking" white
paper,

There is an introduction on SAMBA at
http://us1.samba.org/samba/docs/SambaIntro.html. It info on mapping
Windows drives to Linux directories.

Someone stated somewhere, some when:
-Use Samba >2.2.7 and copy the backend to this share
-Read/write-permisssion for the users
-Install the frontend on every pc an connect the tables
-Read the doc readme2k.txt in the samba-share of the linux-box

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Sponsored Links