3045 File in use error on XP with SP2

[jeisch]

I am trying to open a recordset that uses SQL selecting data from an attached table in an Access97 database on a Novell server. I am running this in access97 on XP with SP2, and I get the error 3045 - file already in use. We have users on all different platforms running the front end application, including windows 95, NT, and XP with SP1, and they all work fine. When we try to run it in XP with service pack 2, we get this error. If I take the database from the server and put it on my C: drive, and then attach to it, it works fine.

I can go directly into the attached table by clicking on it, and then I can update it or do whatever I want without a problem. It's only when I try to access it through the code that I get this error.

Set db_Access = ws.Databases(0)

SQL = "Select * From Res_Security Where EMPLID = '999999'"

Set ds_Privileges = db_Access.OpenRecordset(SQL, DB_OPEN_DYNASET, DB_READONLY)

Any help would be greatly appreciated.

Thanks,
Jim