Database splitter problem

[Paul]

I hope someone can help me. I have a fairly simple
database, several tables, forms, and some VBA code behind
the forms. I want to split it, and I'm getting the
following two errors from the database splitter wizard
when I try to do that:

"Subscript out of range"

and

"Invalid Procedure Call or Argument"

Unfortunately, there are no HELP options associated with
those error messages -- just an OK button.

The code in the database compiles without any problem or
errors, so I'm not sure what the source of this problem
would be. Any pointers that would help me track it down
would be appreciated.

Thanks.

 

[Mike Labosh]

the forms. I want to split it, and I'm getting the

following two errors from the database splitter wizard
when I try to do that:

"Subscript out of range"

and

"Invalid Procedure Call or Argument"

It sounds like your Wizard is b0rken. You could run setup and uninstall the
wizards, reboot and then reinstall them.

Remember also, that splitting a database is relatively easy:

1. Create a new database
2. Import the tables from your original database
3. Close this database and open your original
4. Delete the tables and link them from the new ones

Another trick I like to use to keep users out of the tables-only-backend is
to put an autoexec macro in it that opens the forms database.

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!