Database Splitter Error

[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

 

[mdav2]

I would try doing this:

1) create copy of your database
2) create 2 versions of the database both with the same information but called different names. EG. program.mdb, data.mdb.
3) delete all the tables in the program.mdb
4) delete all the queries, forms, macros, modules in the data.mdb
5) import the tables, as a link, into the program.mdb

Alternatively, export all the table to new database, delete the original tables and import them back as a link.

 

[1starr]

Thanks, It worked.