Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / January 2006

Tip: Looking for answers? Try searching our database.

sharing backend on NAS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jesper F - 27 Dec 2005 17:45 GMT
I'm thinking of getting a Network Attached Storage such as a Synology:
http://www.synology.com/enu/products/diskstation/DS-101g_plus/index.php?page=ove
rview.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
david@epsomdotcomdotau - 28 Dec 2005 01:53 GMT
> 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)

> I'm thinking of getting a Network Attached Storage such as a Synology:

http://www.synology.com/enu/products/diskstation/DS-101g_plus/index.php?page=ove
rview.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 - 01 Jan 2006 17:58 GMT
The specification page
http://www.synology.com/enu/products/diskstation/DS-101j/index.php?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.

Signature

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

>> Is this possible?
>
[quoted text clipped - 17 lines]
>>
>> Jesper
Tony Toews - 09 Jan 2006 00:53 GMT
>I'm thinking of getting a Network Attached Storage such as a Synology:
>http://www.synology.com/enu/products/diskstation/DS-101g_plus/index.php?page=ove
rview.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
Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.