Run an Access Stored Procedure using ADO 1

[mikemcginty]

I can run an MS Access stored procedure by creating an access object and using .opendatabase, however this always wants me to enter a database login (which has user level security).

I already have a connection to the database via ADO which the user has already logged in.

Is there a way I can run a stored procedure using my existing ADO connection and not have the user have to type a loging each time the stored procedure is run?

thanks

 

[Craig0201]

You'll get a better answer by asking in an Access forum.

Craig

 

[Chiaua]

If you use a Delphi's ADOConection change the LoginPrompt to false.
It just ask you the login one time.