Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UNC for split db object reference (Access 2K, Win 2KPro, SQL Server 2K)

    I have an Access db that serves as a front end to SQL Server for some info and does further processing of the SQL Server data in Access itself. Since the db is being shared by many users in a department and everyone says it's the thing to do, I split the db. UNFORTUNATELY, this was a *bad* idea, at least as far as I can tell. The wizard creates a backend db and splits stuff using the DRIVE letter reference to point to the database/tables. Is there a way to have this not happen? that is, use a UNC path?

    In the meantime I de-split the db so that users who happen to have the backend db on a share drive other than G:// aren't prevented from using their db.

    TIA!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UNC for split db object reference (Access 2K, Win 2KPro, SQL Server 2K

    If you only use SQL Server tables, you don't need to split the Access database into a frontend and backend. The SQL Server database is the backend.

    By the way, you can specify a UNC path to an Access backend database:
    Open the front end.
    Select Tools | Database Utilities | Linked Table Manager.
    Click Select All, tick the check box "Always prompt for new location", then click OK.
    Specify the UNC path to the backend.
    Click Open.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UNC for split db object reference (Access 2K, Win 2KPro, SQL Server 2K

    ok, but I was doing the split stuff for the additional tables and data generated internally in Access on the info pulled from SQL Server, so I thought that would be a 'best practices' thing to do. as for the option to prompt for a new location, I was wondering if that was the place to go for setting up a UNC path. I was going to check that out but something else came up <img src=/S/fire.gif border=0 alt=fire width=15 height=15>

    for now, I'll just leave it the way it is...

Posting Permissions

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