Record not deleting

[psy]

I am not sure if this is the correct forum, but here goes. We are using FMP v5.0 on a PC (Win98 soon to upgrade to Win2000). We open a database and attempt to delete a record from it. The window appears to confirm the deletion, but after you click OK, an error appears. The error is that the record can not be deleted because the file can not be found and a file name is listed. It is not the name of the file that we are using. The filename in the error message is not found anywhere on the PC. If we change the name of the file to reflect the name of the file listed in the error message, then the record will delete just fine. The records will only delete if the file is named a certain name. We do not want to leave the name as the filename listed in the error message. We would like to rename the file to something else and still be able to delete records. We have tried renaming the file, saving the file under a defferent name. I believe that the file was origianlly created on a Mac and then transferred to the PC. We do not have the original Mac files. Does anyone have an idea why the file can not be renamed and the records deleted? Is there a way to recreate the database without having to manually re-enter all of the records?

Thanks.

[cannes]

hello

- make an export of all data/ all fields

- create a new file from scratch. i would use the same field names as used in the

old file.

- then you can import the exported data into the new (still empty) file

- by using the same field names in both databases it will be more easy for you

to get the right data into the right field

for example:

field "name" becomes "name" in the new db

"zip" becomes "zip"

"country" becomes "country"

etc.

this works on mac

i hope it helps

mimmo

[Vaughan]

Does the file have a relationship that links to the now missing file? The rerlationship might be trying to delete related records.