Microsoft Project front end to SQL Server

G'day, I hope someone can help with this.
I have up-sized several of my currently-running MSAcces databases to run on
SQL Server 2000. In each case, the up-sizing wizard worked, with several
understandable errors.
In the code, I have often used CurrentDb to locate other text files
associated with the database. I get a run-time error wherever CurrentDb is
used.
In the help I am told to set a reference, I think, to the SQL Server type
library, or to DAO 3.6. Following the intructions, I have located a reference
to the DAO 3.6 type library, and it is checked.
I have also tried the other suggested solution of creating a reference
object, but I cannot figure out how to do this, either.
Please help if you can.
Regards, Terry
CurrentDB in DAO refers to the Jet engne, which is no longer present
in an Access project. You will need to rewrite significant portions of
your application to work with SQL Server, depending on what you need
to do. A straight port of an Access/Jet application never works
without significant alteration (unless it's extremely simple). If you
are working with text files and other local resources (not on the
server), I'd recommend using an mdb with linked tables rather than an
ADP. That gives you the flexibility of still being able to use DAO
against the Jet engine.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Tue, 7 Sep 2004 06:29:04 -0700, "mccer"
<mccer@.discussions.microsoft.com> wrote:

>G'day, I hope someone can help with this.
>I have up-sized several of my currently-running MSAcces databases to run on
>SQL Server 2000. In each case, the up-sizing wizard worked, with several
>understandable errors.
>In the code, I have often used CurrentDb to locate other text files
>associated with the database. I get a run-time error wherever CurrentDb is
>used.
>In the help I am told to set a reference, I think, to the SQL Server type
>library, or to DAO 3.6. Following the intructions, I have located a reference
>to the DAO 3.6 type library, and it is checked.
>I have also tried the other suggested solution of creating a reference
>object, but I cannot figure out how to do this, either.
>Please help if you can.
>Regards, Terry
sql