Post reply

Access 97 caused CPU reaches 100%

  • February 4, 2005 at 6:26 pm

    #66877

    Hi All,

    I have an Access 97 database running locally from sqlserver2k.  Everytime, Access opens, my sqlserver server's CPU reaches 100% and caused the performance decreased significantly.  If I closed the Access db, the server's performance came back normal.  How can I overcome that? Thanks

    Minh Vu

  • February 5, 2005 at 5:21 am

    #540812

    Access is famous for causing locking problems with SQL Server.

    Try creating a views for each of your SQL Server tables as

    SELECT [field1]....[fieldn]

    FROM dbo.YourTable WITH NOLOCK

    Then try connecting these to your MS Access app. You can rename the local attached name within MS Access so it appears that your table names are the same.

    LinkedIn Profile

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

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