By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,759 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,759 IT Pros & Developers. It's quick & easy.

Access crashes when updating a stored procedure

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.