July 11, 2005 at 9:22 am
I have a stored procedure I need to recreate in Access 2003.
Does anyone have any pointers.
It looks like there is a create procedure in access but I cont get it to work.
July 11, 2005 at 9:24 am
Procedures in access mdb files?? That's new (to me anyways). Are you sure it's not and access data project that is connected on the server?
July 11, 2005 at 9:27 am
I really am not sure. Access is new to me. I have not worked with Access much.
July 11, 2005 at 9:32 am
What is the filename of the db?
if it's .mdb then it's probabely an access db, else (adp), it's an access data project that is connected to an sql server.
To be sure, hit files/connexion/ his test connexion. If you don't get an error from this it's because you are connected to a server.
July 11, 2005 at 9:35 am
The file is access because its an MDB...
OK how about this. Is it possible to create a temporary table in access like in Sql.
In Sql we use the ##tbl_name. In access is there something similar?
July 11, 2005 at 9:50 am
I think you have to create a perm table and drop it manually. The syntaxe seems to be the same between sql server and access. Also have you considered making a perm table that would hold the temp data? This would lessen the overhead on the db.
Also the real question is why do you need a temp table?
July 11, 2005 at 9:54 am
Forgot to post this link for an all-access forum :
July 11, 2005 at 12:02 pm
I may not be an Access Monster but i can tell you that you can call sp in Sql Server through a MS Access (mdb) Pass-through query and it works very well
Cheers
* Noel
July 11, 2005 at 12:05 pm
He didn't specify he was using sql server for this project .
July 11, 2005 at 12:07 pm
I need to use access and recreate the SP that I have in SqlServer.
July 11, 2005 at 12:27 pm
To re-create a stored procedure you will be better off using QA. To call it use the MS Access Passthrough query type!
* Noel
July 11, 2005 at 12:28 pm
I assumed he meant that the SP was in SQL Server .... and I was right
* Noel
July 11, 2005 at 12:40 pm
Still that guessing game... do you think he understood what you meant or does he still need help?
July 11, 2005 at 12:52 pm
I hope that he knows that QA = Query analyzer
and
I hope that he can write : exec spname in the Passthrough query
and
I hope that he creates an ODBC DSN for th passthough to use
and... well after writing this much I am not sure if he knows
* Noel
July 12, 2005 at 1:36 am
I do not think it has yet been established if the original poster wants to recreate a SP type data manipulation in a standalone access db (if not why are they using an mdb file and not an adp). About the only way in Access to do this standalone is by a combination of queries and VB, since the SQL impentation in Access leaves a lot to be desired.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply