Service

[vanillapod]

Hi i have an ms access database that checks for new records in an attached table and then, if a new record exists, creates / outputs a report and then deletes the record and waits for another one, i'm using it to allow web users to create / ms snapshot reports from a backend ms access database.

My question is can I get the database that checks for new records to run as a windows ervice? I know absolutely nothing about this so sorry if its a stupid question!

Cheers

 

[kjv1611]

You might be better off asking this sort of question in a Windows forum, or some sort of IT networking forum, or possiby a better guess would be some sort of Windows Server forum, if can't get any answers in the Windows Forum... possibly try searching "Forums" in the search options at top of page for "Windows Services" or similar??

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[kjv1611]

Don't know if this is much help, but I did check the Access VBA help file, and found this little bit...

Running Business Objects in Component Services


Business objects can be executable files (.exe) or dynamic-link libraries (.dll). The configuration you use to run the business object depends on whether the object is a .dll or .exe file:

Business objects created as .exe files can be called through DCOM. If these business objects are used through Internet Information Services (IIS), they are subject to additional marshaling of data, which will slow client performance.


Business objects created as .dll files can be used via IIS (and therefore HTTP). They can also be used over DCOM only via Component Services (or Microsoft Transaction Server, if you are using Windows NT). Business object DLLs will need to be registered on the IIS server computer to give you accessibility via IIS. (For steps on how to configure a DLL to run on DCOM, see the section, "Enabling a DLL to Run on DCOM.")
Note When business objects on the middle tier are implemented as Component Services components (using GetObjectContext, SetComplete, and SetAbort), they can use Component Services (or MTS, if you are using Windows NT) context objects to maintain their state across multiple client calls. This scenario is possible with DCOM, which is typically implemented between trusted clients and servers (an intranet). In this case, the RDS.DataSpace object and CreateObject method on the client side are replaced by the transaction context object and CreateInstance method (provided by the ITransactionContext interface), implemented by Component Services.

sounds like could give a little insight..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[vanillapod]

cheers kjv1611, sounds like its possible then, I'll keeping digging!

cheers again