Re: Multi user VB6 Access Backend Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ChrisM (hidden_at_AskMeIfYouWantIt.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 09:21:48 -0000

It's interesting to read about everyones experiences, it would seem that on
balance it should work OK (If I'm lucky?!).
No-one has actually answered my original question yet, although by reading
between the lines, I sounds as if I should go for the MDB containing the
tables on the server, and a copy of the MDB containg the queries on each
machine that will be running the software.
Could someone please confirm that this is the best way to go.

Thanks,

ChrisM

"ChrisM" <hidden@AskMeIfYouWantIt.com> wrote in message
news:eYu1gdv9DHA.1428@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a VB6 application which has to use an MS Access database as a back
> end.
>
> I'm not really used to using Access as a back-end. Usually use SQL Server.
>
> Anyway,
> I have split the back-end Access into 2 parts, all the data: 'Tables
> Database', and the queries: 'Queries Database'
>
> If I want to make this multi-user, obviously the 'Tables Database' will
> reside on the server, but should each user have their own copy of the
> 'Queries Database' on their PC, as well as a copy of my application, or
can
> each copy of the application refer to one instance of the 'Queries
Database'
> (ie a copy on the server).
>
> Thanks,
>
> ChrisM
>
>

Relevant Pages

  • Re: ASP and Access Database queries
    ... http://www.bellfield-barna.com/ is running on an Apache server running ... which doesn't support ASP and Access. ... My Access database is situated in my office. ... I have an Access database where I would like ...
    (microsoft.public.frontpage.programming)
  • SUMMARY: V440 small DATABASE SERVER
    ... apprehensive about how few disks you're using. ... PICK variant database, so your mileage with my "advice" may vary. ... the App is tuned to not do crazy IO (queries tuned), ... We had a small extranet server running a fairly classic "3-tier" client ...
    (SunManagers)
  • Re: ASP and Access Database queries
    ... than give me some ideas why the FP Wizard is not fing my database? ... http://www.bellfield-barna.com/ is running on an Apache server running ... My Access database is situated in my office. ... I have an Access database where I would like to ...
    (microsoft.public.frontpage.programming)
  • Re: Performance Improvements: Hardware vs. DB Design
    ... > I recently designed & developed a data warehouse for a client of ours. ... > database with a substantial amount of data, ... I think many companies are inclined to add more server ... the queries, revise the indexes if necessary, and verify the reporting ...
    (microsoft.public.sqlserver.server)
  • Re: Limiting the number of records returned in DAO recordset
    ... environment queries that are only returning 200 records can be ... unbelievably slow at times (today it varied between 4 and 78 seconds ... I think a server based db should be faster but I also want it so as to ... A database server will not necessarily be "faster" than a local database if ...
    (microsoft.public.vb.database)