Converting MDB/MDE into a Service ??

[waldemar]

So I have this little cute MDE application that is supposed to run on the server verifying the Database every night for plausibility, data completeness and some other tasks (compact database, etc.)...

Quoting the Server/Network Guy: "Sorry, no I can't install Access on that Server/Workstation; how about you convert that MDE into a Service? Then it's no problem..."

Well I do NOT have a Developers Edition of Office (2000); so how do I create an NT Service out of an existing MDE Application?

 

[oharab]

You can't!
You couldn't even if you had the developers edition. What you could do is rewrite it using VB6. I'm not sure how you would turn it into a service as I know very little "real" VB, but I'm sure it's possible.

Ben ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[waldemar]

This guy said "There's Tools in the Internet that do the converting"...

 

[oharab]

he lied!
You cannot turn an access database into an executable file. Period.
I wish I could say otherwise, but that is the way it is. Your only option is to rewrite a VB front end onto your database.

B ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[waldemar]

Thanks oharab

 

[waldemar]

So this doesnt look all so difficult... converting some access vba database maintaining routines in vb6... I tested some code and it seems 1:1 portable...

Does anybody have expierence with this? I am unexperienced to vb6 and I have no idea to start with an "NT service", is this an "ActiveX-EXE"?? Where is the startup routine? main() ?? ... Do I need this?:

http://www.vbrad.com/pf.asp?p=http://vbrad.com/source/tip_service_vb.htm

Thanks
waldemar