Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2.0 ADK - compiled under Win 95 - installed on Win 3.x

Posted on 1998-05-19
3
Medium Priority
?
324 Views
Last Modified: 2008-02-01
Haven't used the MS Access Developers Toolkit for a long time now. Last time I used it I was compiling Access 2.0 databases while under Win 3.x and had no problem. Now I have just used it on a Win 95 machine to compile an Access 2.0 database which was used to install the runtime version on a users machine running Win 3.x. The user then received messages (when rebooting the machine) stating that a "later version of Windows was required". Discovered that a number of system files (e.g. COMPOBJ.DLL, VER.DLL) had been over-ridden by the files taken from the installation disks. By trial and error I was able to reconstruct the original files back onto the users machine , but this setup scenario MAY be becoming used more in the near future and my question is :
             (i) What files from a Win 95 setup could go onto onto the installation disks which would over-ride Win 3.x files
             (ii) Is there some patch (etc) to the V2.0 ADK which overcomes this problem.

Please note - the above configurations must be used in any reply as, (YES) there are still some people out there using Win 3.x machines.  
0
Comment
Question by:archery
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
sda earned 600 total points
ID: 1974106
There are 32 files that the setup wizard expects to find in the Windows\System directory on the PC in use to create setup files.  To create forward-compatible setups, create a directory under Windows called "OldWin" and copy the 32 files from another Win31 machine's sys dir. (which has the old version files).  Now, to tell the setup wizard where to find these old version files to use, (shift) open SETUPWIZ.MDB, open in design view the module called "zws_Setup", and go to the sub called "ListFiles".  Find the line that says "stSysDir = GetSystemDir()" and REPLACE with "stSysDir = C:\Windows\OldWin", or whatever you named the dir holding the old version files.  Save and close the module and file.

The 32 files are:

TL3DV2.DLL, BTRV200.DLL, COMPOBJ.DLL, CTL3D.DLL, DAO2016.DLL, DBNMP3.DLL, DRVSSRVR.HLP, MSABC200.DLL, MSAEXP20.DLL, MSAJT200.DLL, MSJETERR.DLL, MSJETINT.DLL, MSTOOLBR.DLL, ODBC.DLL, ODBCINST.DLL, ODBCINST.HLP, OLE2.DLL, OLE2.REG, OLE2CONV.DLL, OLE2DISP.DLL, OLE2NLS.DLL, OLE2PROX.DLL, PDX200.DLL, SCP.DLL, SDM.DLL, SQLSRVR.DLL, STDOLE.TLB, STORAGE.DLL, TYPELIB.DLL, VER.DLL, VSHARE.386, XBS200.DLL.

This method was spelled out in the Sep.'95 issue of the SmartAccess newsletter.  I have done this for some time now and haven't had any problems.
0
 
LVL 4

Author Comment

by:archery
ID: 1974107
Thanks for the brilliant (and timely) answer. It was exactly what I wanted and resolved a real problem for me. It was timely in as much as I was literally about to do a Network install over 20 machines (a mix of Win 3.x and '95) and was gravely concerned about the ramifications and/or having to tell my boss that I needed more time for investigation. I actually received your reply on the EXACT day I was to do the install, so .. "BRILLIANT"
It was a snap to setup & it has been successfully done now.
One further "ask" now - how to I subscribe (or other) to this SmartAccess newsletter. I currently subscribe to Access Advisor mag (et al), but am always on the lookout for more references.
Thanks again from a very happy "Down-Under Aussie"
P.S. I increased your points  
0
 
LVL 1

Expert Comment

by:sda
ID: 1974108
Thanks for the feedback.  Check out the SmartAccess newsletter at http://www.pinpub.com/access/.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question