Splitting Database

[Lowner]

Good morning everyone,
I am trying to split my database but I get the following messages, 1.)
"Subscript out of Range" and 2.) Invalid Procedure Call or Argument." Any
idea on what it the cause and how to fix this. I Still get an
DAtabaseName_be.mdb file created.

 

[Allen Browne]

Here's Microsoft's suggestions on how to solve problems with the wizards:
http://support.microsoft.com/kb/303769
http://support.microsoft.com/kb/242218

 

[Jeff Boyce]

One possibility is that the code in your .mdb file is not fully-compiled.

Open a code module, click Debug, then Compile. If the compile fails, it
should give you error messages that can help you identify what needs to be
fixed. Once those are fixed, and the Compile works, try splitting again.

As an alternate approach, make a copy of the .mdb file you wish to split
(actually, make a backup first!). Now take the original and delete the
tables (this is why you made a backup!). Take the copy and delete
everything except the tables.

Reopen the original and use File | Get External ... | Link ... to point
to/link to the back-end tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lowner]

Yeah, that is how I ended up doing it, but I will still go back to the one I
saved and do as you recommened, just so that I can be better aware and
informed with those issues. Thanks

 

[Lowner]

Thanks, I will take a look at them, I am sure I will learn something.