Problem in Executable version

[creative1]

hi everyone
I am a student developer. I created setup of my project(VB 6 at frontend and Access as database) and uploaded in on my client system.
The problem is ... He perform a transection and save it successfully, Whe he tried to open report , it says no record found and they displays an error message.....invalid datasource.
However whenI install the same software in my pc, it works fine and prints reports too.. weired?

...My client haven't installed Access on his PC.
any help pls

[9815402440]

hi
it may a setup error
instal vb6 and msaccess on client pc . this will solve the probalm

regards
manpreet singh dhillon hoshiarpur

[code937]

when building the executable make sure you include any DLL's and bits the program says it needs, your client wont have them on his pc (especially if he hasnt got access) so you'll need to include them on the install as you have them on your pc because you have vb6 !

[rizwan6feb]

If installing the runtime files doesn't solve the problem then post your database connectivity code, it may help solve the problem

[creative1]

I asked my client to install Access and try this again. The thing is, if it saves transaction, why not generate reports?

Here is my database connectivity code.

Public Sub openconnection()
On Error GoTo connectionerror:
 
    Set Conn = New ADODB.Connection
    Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\database\PoPDBF.mdb;Persist Security Info=False"
    Exit Sub
connectionerror:
    MsgBox ("Unable to connect to the database! Critical Error..")
End Sub

[creative1]

Hello Everyone
the problem isn't solved yet, I am trying many things but can't find a why.

My client says follwoing are files prompted during installation:

C:\WINDOWS\system32\msvcrt.dll (the destination file is in use) Abort/Retry/Ignore

C\WINDOWS\system32\uxtheme.dll - message same as above

C:\WINDOWS\system32\msimg32.dll - message sames as above

I think he aborts all of them; not 100% sure though ;
what is right action for this?

He has installed Offfice 2003 but not Access

When he tries to start PoP(exe file of project after installation) - it tries to install Microsoft Office Standard Edition 2003 files and gives an Installation Error:File Not found; A required installation file SKU112.CAB could not be found. PLease insert MS Office Standard Edition from a CD.

He pointed it to the Support folder - no luck; He also pointed it at the MSO Cache on the hardrive and it seemed to install ( don't know if he did that right or not ?)

When setup is complete it does not install database; so I need to copy and paste it with exe file. To make exe file work.

Please Please help me; I am worried about this.

Thanks in advance
Farhana

[QVeen72]

Hi,

What are you using for Reports..? CR or DataReports. What version is ur Access..?
If CR, then you have to set the Data Location for all the Tables used in Report, or Place the Database in the Same Path / Folder as your Working Path Folder in your system..

Regards
Veena

[creative1]

I am using Access2003 and all reports are Datareports

[creative1]

I figured out the problem. I tought its good to tell you guys so it might help someone in future.

I used dataenviornment to create reports and I had hard coded address in Datalink properties of connection (c:/program files/..../database/database.mdb) I changed it to(./database/database.mdb) It solved my problem.

Thanks to all who tried to help me.
Farhana