BUG: RDS 2.0 Client Cannot SubmitChanges to RDS 1.5 Server

ID: Q198531

The information in this article applies to:
  • Microsoft Data Access Components versions 1.5, 2.0, 2.1 SP2

SYMPTOMS

When submitting changes using the SubmitChanges of the RDS.DataControl or the RDSServer.DataFactory the user may see the following error message:

[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open the file 'C:\WINDOWS\system32'. It is already opened exclusively by another user, or you need permission to view its data.
NOTE: The above error is for Access databases ONLY. The problem may occur with other databases, with different error messages.

Also note: This problem only occurs on the SubmitChanges. Querying the database does not cause the above error. If you are receiving an error querying a database, see the "References" section for additional articles that may help.


CAUSE

One cause of this problem is the client has RDS 2.0 installed while the server has RDS 1.5 installed. There may be other causes to this error message. This problem may also occur if permissions are not correctly set, see the following article for more information:

Q183060


RESOLUTION

Upgrade the Server to the latest version of RDS. The most current version of RDS should be able to handle clients of previous versions. It is not guaranteed that newer clients can connect to older servers, however.


STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

To reproduce this behavior, you need access to two computers, a server and a client.
  1. Using the Windows NT Option Pack, install both IIS 4.0 and MDAC 1.5 on the server. Do a complete install of both items (make sure all options are checked.) The Option Pack can be found at:
    http://www.microsoft.com/ntserver/


  2. Install Internet Explorer 4.0 sp1 or greater on the client computer. Install Microsoft Data Access Components version 2.0 on the client computer. This can be found at:
    http://www.microsoft.com/data


  3. Start Internet Explorer on the server and navigate to the following page:
    http://YOURSERVERNAMEHERE/msadc/samples/adctest.asp


  4. Run the query and change some data in the grid. After you change the data, click on 'Save Changes.' The data should save and the grid should refresh without a problem.


  5. Start Internet Explorer on the client and navigate to the same page:
    (http://YOURSERVERNAMEHERE/msadc/samples/adctest.asp)


  6. Repeat step four. This time when you select Save Changes you will receive the error listed in the "Symptoms" section of the article.


  7. Install Microsoft Data Access Components on the server and repeat steps 3 to 6. You should receive no errors updating your data.



REFERENCES

This problem may also occur if permissions are not correctly set, see the following article for more information.

Q183060
Query the Knowledge Base for the following keywords: "RDS and Permissions" to get the latest permissions information on RDS.

© Microsoft Corporation 1998, All Rights Reserved.
Contributions by Jonathan Johnson, Microsoft Corporation

Additional query words: kbDSupport kbdse

Keywords : kbDatabase kbMDAC kbGrpVBDB kbGrpMDAC kbDSupport kbADO210sp2 kbMDAC210SP2bug
Version : WINDOWS:1.5,2.0,2.1 SP2
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: November 18, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.