Access95 ->Access2000 DAO???

[aegon2002]

Hello,

I'm trying to convert an access95 application to Access2000(A2k). According to the whitepaper from microsoft A2k uses only DAO3.60. My access95 application uses Dao3.0.
Before converting I have to set the Access95 reference to DAO 360. But....my application won't compile. It does not know rs.update ("This argument is not optional&quot. I declared an rs as recordset and I tried dim rs as dao.recordset. No Nothing... When I return the reference to 3.0 all compiles quite well.
I don't know why this happens and I don't know how to solve it. Who knows???

I tried to solve it to just convert the 95 application by opening it within A2k. When I convert I get compilation errors. Just removing , updating and adding some references solves the compilation errors. However I lost some code!!!

strSQL = "[VERZ_NAAM] LIKE '" & UCase(strNaam) & "*' OR [VERZ_NAAM] LIKE '" & LCase(strNaam) & "*'"

has changed to:

strSQL = "[VERZ_NAAM]='" & strNaam & "'"

How could this happen and what's the problem, but more important how can I solve it???

Greetz,
Marcel

 

[thornmastr]

In my opinion the easiest way is to convert to A97 and then to A2000. The following information, which is not frm me, may solve your problem. I’ve never done it, but try it,perhaps it will solve your problem.

Do not go through A97 to convert from A95 to A2k:
- Just open the database in A95, compile and compact.
- Then open Access 2000, and:
Tools | Database Utilities | Convert.

After conversion:
- make sure everything is in order, and compile.
- remove spurious references including ADO. In module:
Tools | References.
- make sure there are no "Missing references".
- Go through your code and:
replace with
------- ----
As Database As DAO.Database
As Recordset As DAO.Recordset

If you can, keep your copy of A95 on your computer for
the time being. This will allow you to massage your old
A95 database further if you have problems. To do this:

- Uninstall any components from Office 95 you don't need
e.g. Word, Excel, ...

- Install Access 2k, choosing a Custom installation, and
specifying a folder different to the one where A95 is
installed.

A2k is quite good at letting you know if there are any
problems after conversion.

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[aegon2002]

I could try to convert to 97 and then to 2000. Good tip. thnx

I already tried explicitly dim rs as dao.rs AND dim db as dao.database. Also removed references to ado etc.
I already tried everything you wrote. I have two pc's (one with 95 and one with 2000)

I installed A2k on a clean pc (without restarting!!). Conversion went well !!! Restarting the pc and the conversion goes wrong.!!!???
*%%^$#@

pffffffff. I thing cut and paste is becoming the nearest solution?.....

 

[aegon2002]

TATATATATATA,

It works!! Simple but brilliant.
Convert the 95 database to 97 and to A2k and everything is OK. My tester is now testing the functionality but it seems perfect...

Thnx a lot
_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+_+

"May the source be with you my friend"