Problem after upsizing database to ms sql server 2000

[Guest]

Dear Experts

I have my database(access 2002 format), it was working fine all the forms, but after I upsized to Microsoft SQL 2000, some of my forms are not working, like I have one form that i used DAO to query data from my table, but now(after upsized), it could not run anymore(display error)

So could you tell me how to solve the above problem

Thank you
Sothearith Chanty
Phnom Penh, Cambodia.

 

[Brendan Reynolds]

Are you using an MDB with ODBC linked tables, or an ADP?

--
Brendan Reynolds (MVP)

"Problem after upsizing database to mssql"

Dear Experts,

I have my database(access 2002 format), it was working fine all the forms,

but after I upsized to Microsoft SQL 2000, some of my forms are not working,
like I have one form that i used DAO to query data from my table, but
now(after upsized), it could not run anymore(display error).

 

[Guest]

hello

i am having the same problem that Sothearith Chanty, and I
can answer you that I am using an ADP file.
So what is the problem with the DAO?
thanks

 

[Brendan Reynolds]

The problem is that ADPs use ADO, not DAO. (You can use DAO within an ADP to
work with external MDBs, but not with the ADP itself.) An MDB using DAO is
likely to have numerous references to CurrentDb, which in an MDB returns a
reference to the current DAO.Database object. In an ADP, CurrentDb returns
Nothing, as there is no DAO.Database object in an ADP. Any subsequent
reference to properties of the Database object will, therefore, fail.

In any non-trivial application, there are likely to be many other changes
required as well. Many queries and expressions will no longer work after
conversion of an MDB to an ADP. Conversion from an MDB to an ADP is not a
point-and-click process - depending on the experience of the developer and
the complexity of the application, it may be anything from a few days work
to infeasible.

You'll need to either re-write the code using ADO instead of DAO, or use an
MDB with ODBC linked tables instead, in which case most of your old code,
queries and expressions will continue to work as before.