Error Splitting Database

[1starr]

I have a number of mutiusers that access my database. I was attempting to split the database by using the tool wizard, but every attempt I have made returns an error. I truely don't know what this error message is referring to. The message reads as follows: "You tried to assign the Null value to a variable that is not a Variant data type." If you could give me any hints on why I am receiving this error and what I might need to do to resolve this problem.
Thank you

 

[moviestar]

Error splitting database

Hi there

I'm a newly registered user that's having exactly the same problem as 1starr was having way back in 2002, i.e. when I use the MS Access 2000 database splitter wizard, I get the error message "You tried to assign the NULL valule to a variable that is not a Variant data type". The database splitter wizard does create a new back end but this only contains 3 out of the 16 tables that are in the unsplit database.

Does anyone know what's going on and how I can try to fix the problem please.

 

[RuralGuy]

I believe the DatabaseSplitter is more sensitive than the compiler. You might try a /decompile and if that doesn't resolve it then import everything into an empty db with the Name Auto-Correct turned *OFF*.

You can also do it manually. Make a copy of the db and delete all the tables from the FrontEnd and all *but* the tables from the BackEnd. Then just link the tables to the FrontEnd.

 

[moviestar]

Thanks RG ... will try manually splitting the database.