SaveRecord: The Command or Action "SaveRecord" isn't available now

[surya]

Hi,

I get this runtime error on a button click, in a converted application (from
ACCESS 97 to 2003). It works fine in the 97 application.

The application closes down after the message box.

Can some body please help.


Thanks in advance.

Surya

 

[Jeff Boyce]

It may be that the A'97 application was not fully compiled before
conversion.

Try opening the A'97 version, using A'97, and running Debug | Compile ...
from the VBA window.

After making a backup copy, run Compact & Repair.

Now try converting to A'03.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[surya]

Jeff,

My application uses a mdb database file.

I trued recompiling both the application & the database in Access 97, but I
could not find the Compile & Debug option.

However, I compacted & repaired both the database & application and then
converted.

1017 could not find the field description etc

The error still persists in 2003, but not in 97.

regards,
surya
What i found is that while conversion of the Database file, 34 errors were
logged in a table by name Conversion Errors.

http://www.thescripts.com/forum/thread208703.html

 

[Jeff Boyce]

Are any of those 34 errors relevant?

Open a code module, select Debug, then select Compile.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[surya]

Hi Jeff,

Thanx for the suggestions.
But the Debug option did not appear for the original application (97 version).

It however gave the debug option, but not the compile all modules...for the
data file.

Can you suggest a reason for this?

regards,
Surya

 

[Jeff Boyce]

One possibility might be that the front-end portion of your application is
an ".mde" file, not an ".mdb" file. And the "data file" (I assume you mean
the back-end) is still an .mdb file.

If you have an .mde file, you will not be able to modify it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[surya]

No, Jeff. I checked it and both are .MDE files.
Do you think, the menus are disabled because of any permissions for the
users of the work group files?

please help.

regards,
Surya

 

[Jeff Boyce]

You just confirmed that the front-end is an MDE. You will not be able to
update it.

You will need the MDB file from which it was created if you wish to make
changes.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[surya]

Jeff, i am very sorry.
I mis-typed it. They are actually both .MDB files.

Please suggest. Its urgent.

regards,
Surya

 

[Jeff Boyce]

I've covered the possibilities I'm aware of. Perhaps another newsgroup
reader can offer ideas.

If you were not aware of this, participation in these newsgroups is
voluntary, both for folks asking and answering questions.

I'd recommend that you start another thread/question and see who (else)
responds with their ideas...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[surya]

Hi Jeff,
Thanks any way for the help.
I'll try in another thread.

regards,
Surya

 

[Joan Wild]

Just because the file has a MDB extension doesn't necessarily mean it isn't
a MDE (filenames can be changed).

Is the design button enabled when you select a form in the database window?

You mention (or at least suggested) that the database is secured. It's
possible that the user you are logged in as doesn't have permission to
modify the design.