.exe doesn´t run on other workstation

[Mischamel]

Hi,

 

I created a on Datasets and MS Jet 4.0(Access 2002) basing .exe on my workstation. But it shall also be used on other workstations. The Access2002 Db is on a Netfolder, as well as the .exe.

So I put the .NET Framework on the other machine and released the .exe and the belonging .dlls.

After all this, the programm starts and most functions work properly, except the most important :

 

The application throws an errmsg like this:

'Couldn´t start DB-Server' @ the following line :

Dim oAccess As New Access.Application()

 

I guess the system wants the runtime library of Access ?? But I don´t have it or are there any other possibilities than the runtime lib.

 

P.S. The other workstations don´t have Access intalled.

 

Some good ideas out there ??

[techmanbd]

From answers I have had before about a similar question, YOu don't need access on your workstations, but MDAC 2.7 or higher

 

YOu can download it from here.

 

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

[Robby]

When you create an instance of 'Access.Application', you DO need Access installed on each machine.

 

Why are you creating an 'Access.Application' object, are you running macros, forms or reports in Access?

[Mischamel]

Reports and Makros are executed or called . The errmsg is caused, before amakro is being executed.

 

The DB is on a netfolder and the .exe too. Isn´t there another (cheaper) possibility to let this applic. run other machines, than installing Access on all machines ???

[Robby]

Nope, no cheaper solution.

 

The error comes as soon as an istance is created of the Access object.

[Robby]

techmanbd, I don't think you understand, he is calling reports in Access this has nothing to do with connection to a database.

 

[edit]techmanbd, I guess you deleted your post [/edit]

[Mischamel]

But why do I include a reference to Access.dll, reference to it only if Access 2002 is installed, obviously. I see.

But for other revolutionary tips, that might bypass an AccessInstallation 8-) I would be very apreciated, as you might suppose.

 

Thanks so far ... You did a good Job