Post reply

Copying tables into Access from SQL Server 2005

  • October 24, 2007 at 6:07 am

    #70438

    We have just migrated from an Informix database to SQL Server 2005 and I am running into problems when trying to retrieve data into MS Access from the database. It appears to be caused by the record locking on SQL Server which prevents Access from copying the required information. I needs to be able to use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" from within Access in order to copy the records as I am not bothered about those being edited but just want a snap shot of the table as is.

    Any help would be greatly appreciated.

  • October 24, 2007 at 6:23 am

    #744905

    use dts/export wizard to extract data into sql. Try for 1 main table initially. if this is working fine.. then implement the similiar method for all the tables.

    On top of it, the sql data type will not work in access db. How have you handled for the same ?

    For e.g:- for currency in sql u would have used either money / smallmoney

    But in access it is possible to use only by means of currency...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply