problem on opening Access in window service

David Weisz · Joined: 04 Oct 2007 Posts: 1

hi,
for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)'
fails to work on a 'window service' project
on a simple project (not service) it work's perfectly

does anyone knows why?

Archived from group: microsoft>public>vb>ole>automation

Tony Proctor · Joined: 04 Oct 2007 Posts: 1051

You didn't tell us the error, but it sounds like a permission problem. What
account is your service running under? If it's the default LocalSystem
account then this has less capabilities than a normal login account (e.g. no
network access). How have you implemented your Service? If you're not using
VB6 then you could be in the wrong newsgroup

Tony Proctor

"David Weisz" wrote in message@microsoft.com...
> hi,
> for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)'
> fails to work on a 'window service' project
> on a simple project (not service) it work's perfectly
>
> does anyone knows why?

David Weisz · Joined: 04 Oct 2007 Posts: 2

Thank you for the quick reply

I dont get any error message. the app just waits (not doing anything)
untill i close the access service (MSACCESS.EXE) through the window task
manager, and than the service stops

Yes, it is the default LocalSystem, and i can't change it to LocalService
because
the lines:
Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
Dim mdbFile As New Microsoft.Office.Interop.Access.Application

don't work that way (dont know why)

and like wrote before, it works perfectly in a simple project

Thx for your help

"Tony Proctor" wrote:

> You didn't tell us the error, but it sounds like a permission problem. What
> account is your service running under? If it's the default LocalSystem
> account then this has less capabilities than a normal login account (e.g. no
> network access). How have you implemented your Service? If you're not using
> VB6 then you could be in the wrong newsgroup
>
> Tony Proctor
>
> "David Weisz" wrote in message
> @microsoft.com...
> > hi,
> > for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)'
> > fails to work on a 'window service' project
> > on a simple project (not service) it work's perfectly
> >
> > does anyone knows why?
>
>
>

Tony Proctor · Joined: 04 Oct 2007 Posts: 1051

As I said David, this newsgroup is for "Classic VB" (VB6 and below). Look
for groups with dotnet in their name for VB.Net answers. I'm not being mean.
It's just that the languages are very different. For instance, it's
possible - but a lot more difficult - to write a Service in VB6. This was my
clue that you might have actually been using VB.Net

Tony Proctor

"David Weisz" wrote in message@microsoft.com...
> Thank you for the quick reply
>
> I dont get any error message. the app just waits (not doing anything)
> untill i close the access service (MSACCESS.EXE) through the window task
> manager, and than the service stops
>
> Yes, it is the default LocalSystem, and i can't change it to LocalService
> because
> the lines:
> Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
> Dim mdbFile As New Microsoft.Office.Interop.Access.Application
>
> don't work that way (dont know why)
>
> and like wrote before, it works perfectly in a simple project
>
> Thx for your help
>
> "Tony Proctor" wrote:
>
> > You didn't tell us the error, but it sounds like a permission problem.
What
> > account is your service running under? If it's the default LocalSystem
> > account then this has less capabilities than a normal login account
(e.g. no
> > network access). How have you implemented your Service? If you're not
using
> > VB6 then you could be in the wrong newsgroup
> >
> > Tony Proctor
> >
> > "David Weisz" wrote in message
> > @microsoft.com...
> > > hi,
> > > for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)'
> > > fails to work on a 'window service' project
> > > on a simple project (not service) it work's perfectly
> > >
> > > does anyone knows why?
> >
> >
> >

David Weisz · Joined: 04 Oct 2007 Posts: 2

OK, Thx

"Tony Proctor" wrote:

> As I said David, this newsgroup is for "Classic VB" (VB6 and below). Look
> for groups with dotnet in their name for VB.Net answers. I'm not being mean.
> It's just that the languages are very different. For instance, it's
> possible - but a lot more difficult - to write a Service in VB6. This was my
> clue that you might have actually been using VB.Net
>
> Tony Proctor
>
> "David Weisz" wrote in message
> @microsoft.com...
> > Thank you for the quick reply
> >
> > I dont get any error message. the app just waits (not doing anything)
> > untill i close the access service (MSACCESS.EXE) through the window task
> > manager, and than the service stops
> >
> > Yes, it is the default LocalSystem, and i can't change it to LocalService
> > because
> > the lines:
> > Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
> > Dim mdbFile As New Microsoft.Office.Interop.Access.Application
> >
> > don't work that way (dont know why)
> >
> > and like wrote before, it works perfectly in a simple project
> >
> > Thx for your help
> >
> > "Tony Proctor" wrote:
> >
> > > You didn't tell us the error, but it sounds like a permission problem.
> What
> > > account is your service running under? If it's the default LocalSystem
> > > account then this has less capabilities than a normal login account
> (e.g. no
> > > network access). How have you implemented your Service? If you're not
> using
> > > VB6 then you could be in the wrong newsgroup
> > >
> > > Tony Proctor
> > >
> > > "David Weisz" wrote in message
> > > @microsoft.com...
> > > > hi,
> > > > for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)'
> > > > fails to work on a 'window service' project
> > > > on a simple project (not service) it work's perfectly
> > > >
> > > > does anyone knows why?
> > >
> > >
> > >
>
>
>