Access 2003

[TJBernard]

Ran into a major issue today with MS Access 2003, or at least the .ADP projects.

I have a .ADP database that has a Stored Procedure as its record source. Once the user selects from the first drop down list box, many of the fields on the form are automatically filled out, and then the record is saved by using...

DoCmd.RunCommand acCmdSaveRecord

This works just fine in MS Access 2000.

With the very same file (the 2000 version) and also on a Converted version, I am receiving an error through MS Access 2003.

As soon as the acCmdSaveRecord code is run I receive the following error...

Run time error '16389'

Reserved Error

[End] [Debug] [Help]

I then select [Debug] and it takes me to the acCmdSaveRecord line of code.

In the code window, when I click [>] to run the code, I get the error...

Run time error '2046'

The Command or Action 'SaveRecord' is not available now.

[End] [Debug] [Help]

Has anyone run into this, and if so is there an easy work around?

Thank you,

T.J. Bernard

 

[TJBernard]

I have also found the "RecordsetClone" method does not appear to work in MS Access 2003.

I have a text box that displays the record count of a form. The code for the text box is...

="Record " & [CurrentRecord] & " of " & [RecordsetClone].[RecordCount]

It works just fine in MS Access 2000, and on the same file it shows "FileName#" in MS Access 2003.

I stripped the code down to just ="Test " & [RecordsetClone].[RecordCount] and I still get "FileName#".

What a nightmare as we work towards rolling out MS Access 2003.

Thank you,

T.J.

 

[TJBernard]

I just wanted to post another follow up problem with MS Access 2003.

I have the same database file that displays the record number and record count of the form in a text box. This works perfectly in MS Access 2000, but when the same file (or a 2003 converted file) opens the database it no longer works.

The part that is blowing up is the "RecordsetClone.Recordcount" portion.

The control source for the text box is:

="Record " & [CurrentRecord] & " of " & [RecordsetClone].[RecordCount]

Which works just fine in MS Access 2000, but displays "#Name?" in MS Access 2003. I stripped down to where it is only

="test " & [RecordsetClone].[RecordCount] and I still receive "#Name?" in MS Access 2003.

If anyone has any ideas, let me know. The 2003 conversion/roll out has been a nightmare here so far.

Thank you,

T.J. Bernard