Invalid Use of Null - Upsizing

[Pongetti]

Hello, trying to upsize my Access db to SQL Server 2000. I keep getting the
message "Invalid Use of Null".

-This message comes up immdediately after clicking next after entering my
password. It doesn't even take a few seconds as if it's connecting to
something, it just comes up immediately.
-I tried creating a new database with one simple table in it and got the
same error
-I tried linking a table to the SQL server with an ODBC connection and it
seems to work fine.

This all suggests to me that it isn't a problem with the database, but
either a problem with Access in general or my server. Anybody have any idea
what this means and how to fix it?

Thank you.

 

[Tom van Stiphout]

On Mon, 25 Feb 2008 20:51:00 -0800, Pongetti

I understand this error occurs WHILE you are upsizing. If so, it
appears your installation of Access is corrupt.
Install the latest service packs. Use Help > Repair. Reinstall.

-Tom.

 

[Tom van Stiphout]

On Tue, 26 Feb 2008 07:16:43 -0700, Tom van Stiphout

You're not upsizing from a database that doesn't compile, right? Code
window > Debug > Compile.

-Tom.