Stored Proceedures without SQL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if you can run a 'stored proceedure' without SQL Server?

I have a Yes/No field that gets updated during the day and we would like to show a count of the whole field, if Yes, in a report. However, would prefer not to have Access calculating the running total on the users desktop, instead I would prefer the server (where the database is stored) to process it and have the total kept in another field for the report to publish.

Could a timed script be run on the server or better still, when the Yes/No field is updated, trigger the script to run on the server?
 
Access isn't a server-based application. Anything that happens in the
database (regardless of where it's physically located) has to be done from a
client. There's no reason that I can think of, though, to need to update
anything in advance. Do the calculation when you need the report, and that's
it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Neil Hiorns said:
Does anyone know if you can run a 'stored proceedure' without SQL Server?

I have a Yes/No field that gets updated during the day and we would like
Click to expand...
to show a count of the whole field, if Yes, in a report. However, would
prefer not to have Access calculating the running total on the users
desktop, instead I would prefer the server (where the database is stored) to
process it and have the total kept in another field for the report to
publish.
Could a timed script be run on the server or better still, when the Yes/No
Click to expand...
field is updated, trigger the script to run on the server?
 
Back
Top