split database unable to find table location issue.

[ltvrdy]

Hello all -

I'm having a problem with a database that i had split. While creating teh database, i had it stored on my personal drive at work, but wanted to move it to the shared drive so the data could be stored there. this is to deal with cross site network connectivity issues that we encountered with another database here at work.

When splitting the database, i split it on my personal drive and then dragged the back end to the common drive. I realized my error, but when attempting to correct it, i somehow have two of the same file, and no back end?

I receive the error on the attached document when attempting to access any of the tables or information in either of the files, the "back end" that i placed on teh drive, and the "front end" that i have on my personal drive.

I also tried to relink the tables through the linked table manager, but receive the same error when attempting that.

Is there a way to recover from this? I had backed up my file by making a copy prior to splitting, but somewhere in this process, this became linked to these and is having the same issue. Is there a way to recover the old "unsplit" version? I cannot copy over all of teh tables, etc. because i get the same error as earlier.

I can attach a copy of my database for reference if that helps.

 

[gemma-the-husky]

you will need the data tables. if you have over written all your backups of the data, then you have lost the data. You could try some undelete programmes - but be aware that further use of the drive might damage any copy that could be recovered.

Was the data on your c: structure, or do you have a logical datadisk with a different drive letter. It will aid recovery if you do.

Do you even have the data structure to build the data files again?

 

[JHB]

Is there a way to recover from this? I had backed up my file by making a copy prior to splitting, but somewhere in this process, this became linked to these and is having the same issue. Is there a way to recover the old "unsplit" version? I cannot copy over all of teh tables, etc. because i get the same error as earlier.

I can attach a copy of my database for reference if that helps.

Try to attach the copy of the database you made before splitting the database.

 

[ltvrdy]

thanks gemma... That's what i was afraid of. i don't have a copy of the database prior to splitting it, somehow (probably due to my click happy fingers) it got connected to the split ones. Obviously this time, i'll be saving this to an external source/drive etc. so there is no way of the file being messed up by myself. thanks again for your quick responses.

 

[ltvrdy]

i've read in threads before that to upload a database, you have to compress the file into a zip folder but i tried to upload a zip file with my current database, but recieved an error that a security token was missing. Am i missing something?

 

[gemma-the-husky]

you should be able to upload a zip file which contains your dbs, but not an mdb directly. you may need a minimum number of posts first. possibly 10