Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ODBC SNAFU

Discussion in 'Information Technology' started by wnfisba, Jul 28, 2006.

Tags:
  1. wnfisba

    wnfisba
    Expand Collapse
    Guest

    We have an Access Database with an ODBC into our SQL Server Database. The
    ODBC is actually set-up to default to DataBase_1. Now, within a view that our
    Access Database uses from SQL Server, the view actually Selects from
    Database_2. Now the view selected from Database_1 goes over to Database_2.
    But the view in Database_2 actually goes back to Database_1. What is
    happening here is that we are changing columns within a storage area within
    Database_2.

    If my ODBS Default Database is to Database_1, will I ever be able to
    reference this view within Access that is within Database_1, but actually
    goes over to Database_2 within the same server that actually goes back to
    Database_1???

    How can I fix this within the ODBC??? Can I re-link Tables from different
    databases???

    God...I hope this isn't too confusing...

    Any help is GREATLY appreciated and Thanks in advance for your help.

    wnfisba
     

Share This Page