Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Peraphs my qst is stupid;-)
    Admit i have 5 pc client on same lan and all pc have a mdb in c:\app\mymdb.mdb
    Now... is possible to link all mdb from all pc to other one in a lan dir similar \\mylan\mydir\mymdb_master.mdb...
    and if one of rset on a pc client is updated, delete, ecc... update the same reset on lan dir mdb?

    Note:
    the mdb structure is exaclyy the same for mdb in pc and lan.

    Sorry for my english but one of this lounge understand sure my qst;-)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You should use a split database design, with a backend on the network containing the tables, and frontends on the individual PCs containing links to the tables in the backend, plus all queries, forms and reports.

    See for example WendellB's tutorial Why Split a Database?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='771693' date='22-Apr-2009 09:04']You should use a split database design, with a backend on the network containing the tables, and frontends on the individual PCs containing links to the tables in the backend, plus all queries, forms and reports.

    See for example WendellB's tutorial Why Split a Database?[/quote]

    NICE!!!!!!!!!!!!!!!!!!!!!!!!!!!
    But the time to update the server mdb increase or decrease in terms of the time to update the pc mdb or not?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    A split database is slightly slower than an unsplit one, but it works very well as long as the number of simultaneous users is not too high.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='sal21' post='771694' date='22-Apr-2009 01:15']NICE!!!!!!!!!!!!!!!!!!!!!!!!!!!
    But the time to update the server mdb increase or decrease in terms of the time to update the pc mdb or not?[/quote]
    As Hans indicated, it may be slightly slower, but in my experience it is almost never detectable by the end user. And if you have more than a few (2 or 3) users, the only practical way to manage a production database is to split it. And putting the front-end on the local workstation typcially makes it appear quicker to the user because forms and reports don't have to be pulled accross the network - with a Gbit LAN it wouldn't make much difference.
    Wendell

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='WendellB' post='771849' date='22-Apr-2009 22:29']As Hans indicated, it may be slightly slower, but in my experience it is almost never detectable by the end user. And if you have more than a few (2 or 3) users, the only practical way to manage a production database is to split it. And putting the front-end on the local workstation typcially makes it appear quicker to the user because forms and reports don't have to be pulled accross the network - with a Gbit LAN it wouldn't make much difference.[/quote]

    ok...
    but if i want see the content of table on all PC Client?
    In effect i want to create an interface from my pc to see all other rset of user mdb...

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use File | Get External Data | Link Tables... to link tables in another database. You can do this for each database, if you have permission to see it and open it from your PC.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •