Results 1 to 6 of 6

Thread: Split Database

  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split Database

    I am using Access97 on Windows 98 and my computer is the server for our local network. I just split my database into two databases - one with all my queries, forms and reports linking to the other database with all the tables. When a remote station tries to open my database they get an error message saying that it can't find the database with the tables. How do I map the remote stations to be able to access both of my databases?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Database

    you need to universal path the back end
    servernamefoldersyourdatabase.mdb
    in your linked table manager

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Database

    Thanks for your reply, Jerry. How do I do this?

  4. #4
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Database

    You can't use Mapped drives. Rather, link to the database via your Network Neighborhood. The resulting path should look more like this: OnyxDataDatabase, and not like this: Oatabase. (Onyx is my server's name.)

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Database

    in your front end database click on tools then add-ins then linked table manager
    from here you can set the path to the server for every table you have

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Database

    Thanks for all the help!

Posting Permissions

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