I'm not an expert. Helping a school with FMP 7 and server 7, upgraded
recently from FMP6 and server 5 (it's a Mac system, for what that's
worth). I'm sure the behavior I'm experiencing is due to idiocy on my
part, but if people could show me what I'm doing wrong I'd be VERY
appreciative!

I copied the files before messing with them, by opening a connection to
the server (not through FM) and dragging them to my desktop. This
seemed to give me current copies on my laptop.

Then I signed onto the server through FM, as a client (full
privileges), and changed some records. Then I wanted to revert to the
original file. I dragged the original from my desktop to the server
window, and it seemed to replace the one on the server.

What's happening now is this: I sign on again as a client, and the
(changed) file still opens. When I try to delete the changed records,
I can select 'delete' and I get the warning dialog, but nothing else
happens. If I add a new record, I can delete it. But I can't delete
any of the existing records.

So, if I open the file through FM, the changed records (that I wanted
to delete) are there. But if I open the file by double-clicking it in
the server window on my desktop (and ignoring the shared-file warning
dialog box), the original file opens (without the changes)!

One difference is that when opened through FM, I have "filename
(server)" in the window heading. When opened directly, only "filename"
is there.

I've tried to determine if both the filepaths are _really_ to the file
on the server, but I'm not sure how to do that positively. Visually it
seems as though they are, but I know that can be tricky, like cached
browser files...

any help would be very appreciated.

In article <1121366550.407818.128790 (AT) g14g2000cwa (DOT) googlegroups.com>,
ls (AT) jillo (DOT) com says...
1) Make sure the file you want hosted on the server is on the server.

2) Round up every other copy of the file on your PC (or Mac) or which
you can 'see' from your PC (or Mac) and zip/stuff/rar it so that it can
no longer be directly seen in the filesystem.

3) Try working with the file again.

good luck

Server is OS X? Proba bly you have not shout down FileMaker Server: open
FileMaker Server Admin connect to the server and close all file or close
FileMaker Server.
Adriano B.

Many thanks to those who wrote helpful replies to my problem... I've
figured out what was happening, and reporting it in case it is useful
to anyone.

The main issue was that records could no longer be deleted from the
main database file. I discovered that when the files were converted
from FMP6 to FMP7, there was a relationship with an external file that
broke and was not detected. This external file was set to delete
records when a related record in the main file was deleted. I guess
that basic concept was being retained even while the actual
relationship was broken, so a record in the main file couldn't delete
because it looked for related records in the external file, and
couldn't verify because the relationship was broken.

I love the changes with FMP7, but the odd breaks and stuff that happen
when converting from older versions are a problem, I think. There is
no indication in the relationship window for when a relationship is
broken, and if you have a complex fileset it would take a lot of
tedious work to check everything manually.

Anyway, I'm happy now.
Thanks again.

lansingoogle wrote: