VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000
VB6 Application expecting Access 2000 VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
Go Back  Xtreme Visual Basic Talk > > > VB6 Application expecting Access 2000


Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2013, 04:30 PM
RuralTurtle's Avatar
RuralTurtle RuralTurtle is offline
Regular
 
Join Date: Sep 2005
Posts: 77
Default VB6 Application expecting Access 2000


Hello all. One of our developers wrote an application in Visual Basic 6 that relies on Access 2000 being present on the PC in order to execute queries on the database and print Access reports. I have been tasked with creating an installation for this app, but I am told I cannot expect the end-user to have Access 2000 present.

Question: What can I redistribute via InstallShield to make this work? Is there a redistributable version to package with it? Some other merge module? Is there a way to deploy said without clobbering a newer version of Access on the user's box?

Any help would be most gratefully accepted on this project. Thanks much.
Reply With Quote
  #2  
Old 08-22-2013, 05:06 PM
Gruff's Avatar
GruffVB6 Application expecting Access 2000 Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

VB6 can read and write to an access database file (.mdb) without Microsoft Access being installed. You simply use the ADODB object to open a connection to the file and work with it. The Microsoft Access program does not need to be on the target computer.
You can add the .mdb file to your deployment. No big deal.

If the end user uses a newer version of the Access program to open the .mdb it might
be upgraded to the newer version and cause it not be usable by your app.
Never experienced this but I can see how it might be possible.

Hopefully this is the way your app is doing things. There is another route I would not recommend that Automates the Microsoft Access program from VB. If this is what they are doing then all bets are off.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #3  
Old 08-22-2013, 06:41 PM
dilettante's Avatar
dilettanteVB6 Application expecting Access 2000 dilettante is offline
Underclocked lifestyle

Forum Leader
* Guru *
 
Join Date: Feb 2005
Location: Michigan, USA
Posts: 4,524
Default

Quote:
Originally Posted by Gruff View Post
There is another route I would not recommend that Automates the Microsoft Access program from VB. If this is what they are doing then all bets are off.
I agree. This is a technique better left to one-off throwaway tools for patching around a problem. Since the technique can be so erratic it really isn't acceptable out of the hands of the person who wrote it.

Most of the time a better answer would have been to acquire Office Developer Edition which could make standalone MDEs which could be deployed along with the Access Runtime. I think that went away around when Office 2003 came out, hoping to push programmers into .Net and VSTA (later VSTO).


As I read the question that's what he has though, which means he's stuck. There is no way to use the redistributable Access Runtime with a VB6 program even if you could find a download anywhere for it anymore.

Everybody wants cheap programmers... until one leaves you with damaged goods like this.
Reply With Quote
  #4  
Old 08-23-2013, 02:01 PM
RuralTurtle's Avatar
RuralTurtle RuralTurtle is offline
Regular
 
Join Date: Sep 2005
Posts: 77
Default

Quote:
Originally Posted by Gruff View Post
There is another route I would not recommend that Automates the Microsoft Access program from VB. If this is what they are doing then all bets are off.
From what I have seen of his code, this appears to be what has been done; at least in parts of the program. Specifically, executing queries and printing of saved Access reports.

Question: If I have to send this back to him, is there a way to handle the two aforementioned tasks without automating an existing installation of Access? I don't have it in front of me, but I believe executing queries shouldn't be a problem. As to printing stored reports, I have no idea, and hope someone can shed some light on that.

Thank you both for the replies. Know it is appreciated.
Reply With Quote
  #5  
Old 08-23-2013, 04:07 PM
Gruff's Avatar
GruffVB6 Application expecting Access 2000 Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

If everyone has a seat of the same version of Access as the developer then you just install your VB program and the Access mdb file. Done. Otherwise queries are not difficult in VB6. Running access reports without access. Ain't happening. Some people use Crystal reports, but that of course requires Crystal to be installed on every machine.

It has been many years since I created a data report in VB6.

Dilettante, didn't vb6 have a simple data report function sort of like crystal?
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #6  
Old 08-23-2013, 07:10 PM
dilettante's Avatar
dilettanteVB6 Application expecting Access 2000 dilettante is offline
Underclocked lifestyle

Forum Leader
* Guru *
 
Join Date: Feb 2005
Location: Michigan, USA
Posts: 4,524
Default

There is a simple DataReport module type with a designer that might look familiar to somebody who has created Access Reports. It is great for what it's for, which is reporting hierarchical tablular data with headers/footers and aggregation lines. Beyond that there isn't any flexibility to speak of though and that limits the kinds of reporting you can do with it.

It is most useful bound to an ADO Recordset (flat or hierachical) or a Data Source class. Since many programmers have never worked with the Data Shaping Provider or wrote a Data Source class they don't know how to report using anything but flat Recordsets.

Converting an Access Report means a rewrite, since there isn't any converter.

Automating an Access instance from VB6 should provide a way to invoke a Report. Some 3rd party reporting packages for use in VB6 might have offered some sort of converter from an Access Report to their own.


I don't think there is much you can salvage here except any existing data and maybe specs to use in writing an entire program in VB, VB.Net, C#, Java, or whatever.


A quicker router might be to strip away the VB6 "shell" program and convert to an all-Access solution. Then upgrade to Access 2007 or later which should have the Developer Tools functionality built in (may require Office Pro, Ultimate, or Enterprise).

Then look at Deploy an Access 2007 application.

You could do the same in Office 2000 but it required Developer Edition. The odds of finding that and still getting Service Packs to repair bugs and security holes in it... well long odds at this point.
Reply With Quote
  #7  
Old 08-23-2013, 07:16 PM
dilettante's Avatar
dilettanteVB6 Application expecting Access 2000 dilettante is offline
Underclocked lifestyle

Forum Leader
* Guru *
 
Join Date: Feb 2005
Location: Michigan, USA
Posts: 4,524
Default

Here is the Office 2003 equivalent article:

Obtain and deploy the Access 2003 runtime

However getting hold of the pieces and parts required at this late date is almost as hard as for O2K.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000 VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000 VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
 
VB6 Application expecting Access 2000
VB6 Application expecting Access 2000
 
-->