Access Web Backup Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have downloaded the backup wizard from the access web but whenever i
imported all objects into my app but when i try to open frmdatabases i get
the error message type mismatch (13). Has anyone else had this problem? Or
not what i can do to resolve it?

TIA
 
Edgar Thoemmes said:
Hi

I have downloaded the backup wizard from the access web but whenever i
imported all objects into my app but when i try to open frmdatabases
i get the error message type mismatch (13). Has anyone else had this
problem? Or not what i can do to resolve it?
Click to expand...

I'm not familiar with that wizard, but I think it's very likely that
this is the result of the old DAO vs. ADO reference problem. In your
database, open the VB Editor and click menu items Tools -> References...
In the References dialog, locate "Microsoft DAO 3.6 Object Library" and,
if there's no check mark in the box next to it, put one there. Then, if
you are not using the ADO (ActiveX Data Objects 2.x) Library reference
anywhere in your database, uncheck it. If you *are* using the ADO
reference, you'll have to keep it, but then you'll have to go through
the imported code and qualify the declarations (Dim statements) of the
following objects by prefixing them with "DAO.":

Connection
Error
Errors
Field
Fields
Parameter
Parameters
Property
Properties
Recordset

The one you're most likely to find and have to change is "Recordset",
which you would now declare as

Dim rs As DAO.Recordset
 
Back
Top