469,957 Members | 2,670 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,957 developers. It's quick & easy.

Access crashes when updating a stored procedure

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..
Jul 20 '05 #1
3 1500
On Mon, 11 Oct 2004 17:17:54 +0100, "8leggeddj" <me@home.com> 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).
Jul 20 '05 #2
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" <me@home.com> 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).

Jul 20 '05 #3
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" <me@home.com> 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).

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.