access upsize problem

I am trying to upsize an access 2000 application to MSDE. I get an error 14,
invalid connection. I have read sever al articles in the MS KB but have not
found out what to do. I have WinXP, Office Pro 2000. I am trying to put the
MSDE server on the same machine as the access front end. I would appreciate
reference to a 'cookbook' article about how to make the upsize work. Thanks
I'm not sure what you've read or haven't read, but there isn't a
straightforward approach to getting the upsizing wizard to work,
especially with Access 2000, which was released *before* SQLS 2000,
and thus has many incompatibilities, including different date ranges
for datetime data types. I'd recommend upgrading to Access 2003 if you
want things to work smoothly even after you move the data over. Access
and SQLS are completely different, have data type incompatibilities,
and radically different functionality at the engine level. A straight
port of an Access mdb rarely works well if the application is at all
complex, as most business apps are by definition. It's important to
understand at the outset that the two engines are NOT interchangeable,
and that it is going to take a certain amount of work on your part
(depending on the complexity of your app) to get it working correctly
on MSDE.
The upsizing wizard was written for the lowest common denominator to
handle as many cases as possible by translating all text and memo
fields as unicode, and all validation rules (at least, the ones it can
figure out) as triggers. In cases where there is no exact translation,
entire tables get skipped. I'd recommend creating the structure in SQL
Server and then loading the data, which you can do using DTS or even
Access queries (linking to the empty SQLS tables from the mdb).
--Mary
On Thu, 21 Oct 2004 15:37:23 GMT, "Hugh N. Ross"
<bytewise@.optonline.net> wrote:

>I am trying to upsize an access 2000 application to MSDE. I get an error 14,
>invalid connection. I have read sever al articles in the MS KB but have not
>found out what to do. I have WinXP, Office Pro 2000. I am trying to put the
>MSDE server on the same machine as the access front end. I would appreciate
>reference to a 'cookbook' article about how to make the upsize work. Thanks
>