Split database - the search key was not found in any record

[AndreB]

Hi, I'm trying to split an access database but keep getting "the search key was not found in any record". Does anyone know what that means and how to resolve it?



Thanks

[RuralGuy]

Can you compile your db? <ALT>F11>Debug>Compile

[AndreB]

I think so. <ALT> F11->Debug->Compile finished without any error or messages.

[AndreB]

But tried splitting the db again, and got the same "the search key was not found in any record"... I could really use some help. Has anyone seen this before?

[RuralGuy]

Try *importing* everything into a fresh new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[AndreB]

Hi RG, just tried importing everything (there's only one table I'm trying to split actually) into a new db, and tried to split again...it gave the same error.

[RuralGuy]

Hmmm...I wonder if it could be a Vista issue? You know that splitting a db manually is actually simple right? Make a copy of the db and then one has the table(s) and one has *everything* else and then link the table(s) back in with the Linked Table manager.

[AndreB]

Yes, I know. Just noticed something weird though...I believe it might have something to do with the size of the table I'm trying to split. The original table had about 3 million records, I cut it down to 2.8 million and tried splitting the db, and it worked fine...

[RuralGuy]

Access needs additional room to split the db so the manual process may be the answer here.

[AndreB]

Got it, will do it the manual way then. Thanks!

[RuralGuy]

It is only a one time operation so manually should be just fine. There is a 2GB limit to Access so you will need to be watchful of this restriction. Splitting will give you quite a bit more room since it is forms (especially with graphics) that consumes a lot of space. Are you ready to use the Thread Tools and mark this thread as Solved?