ellandrd
asked on
save pass through query
i have created a pass through query and it works fine, but each time i close and reopen access and try running query, i have to go through the process of selecting the pass through query again.
is there a way to save this?
the pass through runs a MS SQL command...
is there a way to save this?
the pass through runs a MS SQL command...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
what have u got?
yes, but it dont stay...
yes, but it dont stay...
ASKER
ok i must be doing something wrong
can somebody tell me how to create one probably? im trying to run a stored procedure from MS SQL server 2000.
can somebody tell me how to create one probably? im trying to run a stored procedure from MS SQL server 2000.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok i dont understand?
where does this code go? in a new marco? how can i execute it? i connect to the Ms access db by PHP using ODBC.
will this code run when i connect?
where does this code go? in a new marco? how can i execute it? i connect to the Ms access db by PHP using ODBC.
will this code run when i connect?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is it still not working?
yes i got it created and it seems to save now,
yes i got it created and it seems to save now,
ASKER