ADO, multiuser, MS Access

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

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Simon Elliott Thu, 07 Apr 2005 12:06

#757

Author: Simon Elliott
Date: Thu, 07 Apr 2005 12:06

11 lines
1239 bytes

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?

-- 
Simon Elliott    http://www.ctsn.co.uk

Re: ADO, multiuser, MS Access

#760

Author: 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.

Re: ADO, multiuser, MS Access

#761

Author: Simon Elliott
Date: Thu, 07 Apr 2005 19:46

25 lines
1833 bytes

On 07/04/2005, Matt Jacobs 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.

Thanks for this. The initial implementation will only have half a dozen
users with only one at a time needing write access. (If this increases
then since I'm using ADO it shouldn't be a big deal to port to SQL
server.)

What's the best way to determine how to set up the ADO connect string? 

-- 
Simon Elliott    http://www.ctsn.co.uk

Re: ADO, multiuser, MS Access

#763

Author: Simon Elliott
Date: Thu, 07 Apr 2005 22:27

12 lines
1152 bytes

On 07/04/2005, I wrote:

> What's the best way to determine how to set up the ADO connect
> string?

A quick search revealed this useful resource:

http://www.carlprothman.net/Default.aspx?tabid=81


-- 
Simon Elliott    http://www.ctsn.co.uk

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads