Access Projects - Action Queries all come in as ALTER PROCEDURE

[BigJimSlade]

Hi, Big Jim here:

I used the upsize wizard to upload my Access XP database to SQL Server 7.0. Everything looks fine except that the action queries all came through as ALTER PROCEDURE stored procedures. Why would they come through as ALTER PROCEDURE and not just as stored procedures which perform the original query function(s)?

Any thoughts? Thanks in advance!

Big Jim

(I noticed that it only happens on the UPDATE queries, but I did not see this at first as 400 of my 450 queries in this particular database were UPDATEs)

 

[FoFa]

If you made a change on the Access side, the only way it could update the current existing SP is by dropping it and recreating it, or altering it.
My guess is this is how they handle changes to the SP's which tells SQL to look for one that already exists.

 

[BigJimSlade]

Thanks FOFA, but it is only the UPDATE queries that come in as ALTER PROCEDURE. I am guessing it is because the SQL is different for running an UPDATE statement in Access and SQL Server. I really have no idea.

Thanks again!

Big Jim