[RESOLVED] MS Access Forms Deployment Problem

[kaZm]

I have a program I created in vb6 that is using an access database(ADO).
I am working on an xp pro machine using access 2003...
I have used PDW in vb6 to bundle the setup app.

The program takes the user input and stores it in the database. There is a button that opens an access form allowing the user to view reports.


When I install the program on another computer, the access form does not show up when I click. Access opens, but it does not open to the form.

The program works with the database when I add information from the program to the db tables.
And I can open the database through access and view the form I created for the reports.

Here is what the setup.lst file says:

[Bootstrap]
SetupTitle=Install
SetupText=Copying Files, please stand by.
CabFile=Nemer.CAB
Spawn=Setup1.exe
Uninstal=st6unst.exe
TmpDir=msftqws.pdw
Cabs=1

[Bootstrap Files]
[email protected],$(WinSysPathSysFile),,,7/15/00 12:00:00 AM,101888,6.0.84.50
[email protected],$(WinSysPathSysFile),$(DLLSelfRegister),,5/31/98 12:00:00 AM,22288,4.71.1460.1
[email protected],$(WinSysPathSysFile),,,3/8/99 12:00:00 AM,147728,2.40.4275.1
[email protected],$(WinSysPathSysFile),$(DLLSelfRegister),,3/8/99 12:00:00 AM,164112,5.0.4275.1
[email protected],$(WinSysPathSysFile),$(DLLSelfRegister),,4/12/00 12:00:00 AM,598288,2.40.4275.1
[email protected],$(WinSysPathSysFile),$(TLBRegister),,6/3/99 12:00:00 AM,17920,2.40.4275.1
[email protected],$(WinSysPathSysFile),$(DLLSelfRegister),,2/23/04 12:00:00 AM,1386496,6.0.97.82

[IconGroups]
Group0=Nemer
PrivateGroup0=-1
Parent0=$(Programs)

[Nemer]
Icon1="Nemer.exe"
Title1=Nemer
StartIn1=$(AppPath)

[Setup]
Title=Nemer
DefaultDir=$(ProgramFiles)\Nemer
AppExe=Nemer.exe
AppToUninstall=Nemer.exe

[Setup1 Files]
[email protected],$(AppPath),,,6/16/05 9:14:24 AM,1208320,0.0.0.0
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),3/9/04 12:00:00 AM,416528,6.7.0.9782
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),3/9/04 12:00:00 AM,662288,6.1.97.82
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),7/14/04 4:27:12 PM,1081616,6.1.97.82
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),7/14/04 4:26:46 PM,152848,6.1.97.82
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),5/22/00 6:58:00 PM,1009336,6.0.88.4
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),8/4/04 7:00:00 AM,151552,5.6.0.8820
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),2/23/04 12:00:00 AM,119808,6.1.97.82
[email protected],$(WinSysPath),$(DLLSelfRegister),$(Shared),2/23/04 12:00:00 AM,78848,6.1.97.82
[email protected],$(WinSysPath),,$(Shared),8/4/04 7:00:00 AM,81920,2.81.1117.0
[email protected],$(AppPath),,,6/16/05 9:43:40 AM,135168,1.0.0.0

I would appreciate if anyone knows what the problem could be.

Thanks

[Hack]

If you are using VB6, then why are you using an Access Form?

[kaZm]

Its because I have a lot of reports in access created from queries according to whatever dates the user inputs into an access form.

There was another person that created the reports and the form before I was asked to make an application to interface the database.

I just created some code to open the form up from vb.

Here is the code I am using.

Private Sub ViewReport()
    Const strLcFORM_NAME As String = "frmReports"
    
    Dim strLvSendKeys As String
    Set udfMvAccess = New Access.Application
    udfMvAccess.OpenCurrentDatabase (App.Path & "\db1.mdb")
    udfMvAccess.DoCmd.OpenForm strLcFORM_NAME, acNormal, , , , acWindowMaximize
    udfMvAccess.Visible = True
End Sub

Then I just call this from a command button or a drop down menu..

As I stated earlier, I can add records to the database but I cannot view the form on another computer. From my development machine, it works fine.

Thanks

[kaZm]

Here is the database if anyone want to check it out.
There is a single form that I want to open and view.
After using PDW and transferring it to a client computer,
the form does not open.

Hoping someone can figure this one out

[kaZm]

Because I was developing my application with access 2003, the installer was adding msacc.olb which is not compatible with any access database other than 2003 at this time (until a newer version of access becomes available).

I had to install access 2000 on my development machine and create the package using msacc9.olb

This enabled the program to open forms and/or reports in access 2000 and up.

I don't believe that it would work with access 97 because I am pretty sure that access 97 uses a different olb file.