Split failed

[Paul]

Hi,
I have an Access 2000 application, I tried to split to
front & back end with Database Splitter wizard, but got
error message "You tried to assign the null value to a
variable that is not a Variant data type". How to fix the
problem? Which table cause it?
Thanks a lot in advance.

 

[Roger Carlson]

You don't need the database splitter. You can do it yourself.

1) Make TWO copies of your database
2) Name them so you can tell the Front-end from the Back-end. I usually add
a FE to the Front-end and BE to the back end, but you can do whatever.
3) Delete all the Tables from FE
4) Delete all the queries, forms, reports, macros, and modules from BE
5) In your FE, use Files > Get External Data > Link Tables... to find your
BE and select and link all tables.
6) Compact both FE and BE

That's all the Database Splitter does really.