Re: ADO, multiuser, MS Access

Article View: borland.public.cppbuilder.database.ado

Article #760

Back to borland.public.cppbuilder.database.ado Previous Next

#760

From: Matt Jacobs
Date: Thu, 07 Apr 2005 17:21

15 lines
1650 bytes

"Simon Elliott" <Simon at ctsn.co.uk> wrote:

>All my previous BCB ADO apps have either been single user with an MS
>Access database residing on the same PC as the user, or have been
>multiuser with MS SQL Server.
>
>I now want to develop a multiuser BCB app with ADO, which will allow
>multiple users on multiple PCs to use a single MS Access database. Is
>this possible with ADO? Are there any restrictions on the PC where the
>MS Access database will reside?

You can share an Access database on a network. You may have to tweak
the network settings to get a robust implementation (especially server
caching), but it's doable. I would say 5-10 concurrent users is
probably okay.

Technical Details

Message-ID: <nrqa51d4s9gdjpvkv2bj58eoeu9jmde4rg@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!mpls-transit-01.news.qwest.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.nuthinbutnews.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <42551439@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,f6450d10fcf9b767
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Matt Jacobs <noyb@noyb.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ADO, multiuser,  MS Access
Date: Thu, 07 Apr 2005 10:21:10 -0700
Reply-To: __noyb@noyb.com
Message-ID: <nrqa51d4s9gdjpvkv2bj58eoeu9jmde4rg@4ax.com>
References: <42551439@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.23.153.114
X-Trace: newsgroups.borland.com 1112894458 24.23.153.114 (7 Apr 2005 10:20:58 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!mpls-transit-01.news.qwest.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.nuthinbutnews.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message