converting Access database to SQL Server 2000

• casciano

  Grasshopper

  Points: 13

  More actions

  August 13, 2001 at 9:45 am

  #157779

  after converting an Access 2000 database to Sql Server 2000,

  is it possible to look at this database in Access 2000 ??

• MikeTomkies

  Hall of Fame

  Points: 3185

  More actions

  August 13, 2001 at 9:58 am

  #417582

  You shoul be able to if you create an odbc to database.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  August 13, 2001 at 10:50 am

  #417588

  You can link tables in Access to the same tables in SQL.

  Steve Jones

  steve@dkranch.net

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 13, 2001 at 4:41 pm

  #417601

  You can also work with SQL more directly if you open Access in "project" mode. You have access to triggers, sp's, etc.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter