Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro fails, table relationships disappeared

Status
Not open for further replies.

rdholdford

Technical User
Apr 27, 2002
9
0
0
US
I have an Access 2003 database with about 10,000 records. On a network and used by several employees. The database has not been split. When attempting to amend or change data to one form, it won't accept changes and when I try to close the form I get a message saying "The command or action 'Save Record' isn't available now.
*May be read-only or unconverted db * the type of objec the action applies to isnt selected or active. >OK then the macro failed error "Action Failed error
Macro Name: close_session
Condition : True
Action Name: RunCommand
Arguments: 97
Other forms seem to accept data changes. All of my tables are visible in the relationship window but all of the relationships are gone. Also, the tables are no longer indexed. What happened? This db is for providing court reports on domestic violence offenders and court starts at 1pm. Thanks!!!
 
I'm getting a similar error. As you indicated the "saverecord" command is being used throughout and works fine except as part of the macro associated with this command buttons on this form.

Anyone with any ideas for resolution?

Thank you!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top