Error with splitting (1 Viewer)

[tmyers]

I am trying to split my application, so that my coworkers can start testing and getting used to how it will function, but whenever I try to split it, I get an error saying "some table" cant be recognized or is corrupt.

I have done a compact and repair and that did not correct the issue. It seems the issue is that every table that has something in it causes the error. Most of the tables I can wipe clean, but some would be pretty agonizing to have to put all the data back in.

Any idea what is causing this?

 

[Minty]

That sounds very strange. It's happening on every table?
What happens if you try and import all the tables into a brand new empty database?

 

[tmyers]

Same issue. If the tables have data, the split fails.

I just successfully split it by exporting all tables with permanent data to excel files, then once the split was completed, imported them back in. It is just weird that it is doing that and I am really curious as to why.

 

[Minty]

Take a backup before doing anything.

Another route is to simply copy your entire database, in windows explorer. Call it NewFrontend
Delete all the tables.
Link all the tables back from your existing working copy.
You now have a front end database.

You can now safely delete all the objects except the tables in the linked file, and you now have a backend database.