trying to run this command from a sql server stored procedure.
msaccess.exe /ro "\\gdcfs01\public\Software Services\UniTracker\EMail\email.adp" /x processDailyEmails
Thanks for any help.
trying to run this command from a sql server stored procedure.
msaccess.exe /ro "\\gdcfs01\public\Software Services\UniTracker\EMail\email.adp" /x processDailyEmails
Thanks for any help.
Last edited by June7; 02-28-2012 at 03:40 PM. Reason: moderator edit of typo
Why doesn't it work - error message, wrong results, nothing?
Appears to be a SQL Server issue, not Access. You might have better luck in a SQL Server forum.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
What would the syntax be? I want to run it from a stored procedure within SQL server
You want Access to run a procedure that is saved in SQL Server? Sorry, don't know anything about that. Google: Access run SQL Server stored procedure. Maybe this will help http://www.databasejournal.com/featu...oft-Access.htm
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.