Access crashes when updating a stored procedure

[8leggeddj]

Hello,

I am having a problem when using access xp as a frontend for sql server
2000.
I have been trying to update a number of stored procedures (Just simple
adding fields etc) which results in access crashing with event ID 1000 and
1001.
Does anyone have any ideas as to what could be the problem?

Thanks in advance..

[Steve Jorgensen]

On Mon, 11 Oct 2004 17:17:54 +0100, "8leggeddj" <[e-mail]> wrote:

Hello,

I am having a problem when using access xp as a frontend for sql server
2000.
I have been trying to update a number of stored procedures (Just simple
adding fields etc) which results in access crashing with event ID 1000 and
1001.
Does anyone have any ideas as to what could be the problem?

Thanks in advance..

Access could have corrupted metadata stored in the extended attributes of the
stored procedure. Try copying the SQL from the stored procedure, deleting the
procedure, and creating it again. Paste the SQL back in to recover the old
procedure definition (whic will not include the old extended attributes).

[8leggeddj]

Thanks for the advice. I have done this in the past when things go wrong,
unfortunately this time Access crashes again when I try to save the new
stored procedure.

"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:sg********************************@4ax.com...

On Mon, 11 Oct 2004 17:17:54 +0100, "8leggeddj" <[e-mail]> wrote:

Hello,

I am having a problem when using access xp as a frontend for sql server
2000.
I have been trying to update a number of stored procedures (Just simple
adding fields etc) which results in access crashing with event ID 1000 and
1001.
Does anyone have any ideas as to what could be the problem?

Thanks in advance..

Access could have corrupted metadata stored in the extended attributes of
the
stored procedure. Try copying the SQL from the stored procedure, deleting
the
procedure, and creating it again. Paste the SQL back in to recover the
old
procedure definition (whic will not include the old extended attributes).

[8leggeddj]

Thanks for your help, I have tried this in the past when things have gone
astray. However on trying this Access crashes when I try to save the new
stored procedure.

"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:sg********************************@4ax.com...

On Mon, 11 Oct 2004 17:17:54 +0100, "8leggeddj" <[e-mail]> wrote:

Hello,

I am having a problem when using access xp as a frontend for sql server
2000.
I have been trying to update a number of stored procedures (Just simple
adding fields etc) which results in access crashing with event ID 1000 and
1001.
Does anyone have any ideas as to what could be the problem?

Thanks in advance..

Access could have corrupted metadata stored in the extended attributes of
the
stored procedure. Try copying the SQL from the stored procedure, deleting
the
procedure, and creating it again. Paste the SQL back in to recover the
old
procedure definition (whic will not include the old extended attributes).