Is it possible in FM Server to ask the other users to log out of a particular database so that I can go in and modify Define Fields / Define Relationships etc, whilst the other databases are still open?

Cheers in advance

NIck

Yes, you can do this with the FileMaker Server Admin plugin installed on any FileMaker client. If you are using FileMaker 5 or greater with the admin plugin installed, you can go directly to the Define Fields function on a hosted DB, and it will tell you there are users connected and allow you to ask / force the users to disconnect.

You can always define relationships on hosted files if the keys already exist.

When I try to access Define Fields it comes up with an error message stating:

"This command cannot be used with a shared file. To use this command make sure you are the only user of "Candidates3"

Any ideas?

Nick

Are your files hosted on FileMaker server 5 or 5.5?

Is the Admin Plug installed and activated on the FileMaker client you are using?

It sounds like the plug-in is not installed or activated.

You need to get the Admin plugin from the FileMaker Server CD. Place it in the FileMakersystem folder.

You should then be able to disconnect users to open the Define Fields dialog.

The plug-in is installed and activated but still no joy

FYI Files are hosted on FM Server 5.5. I'm using FM5.0v1

Regards

Nick

Ah, you need to update to FM5.0v3 (free)

Here is the detail of the updater that you are intersted in.

FileMaker Pro 5.0v3

March 2000

FileMaker Inc. announces the release of the FileMaker Pro 5.0v3 updater. This updater offers several features and fixes some of which are listed below.

Application features:

1) A key feature in this updater is the ability to now access Define Fields in databases being hosted from FileMaker Server 5.

To work with field definitions in a database hosted by FileMaker Server, you must have exclusive access to the database. When you have exclusive access, no other guests are connected to the database.

If you have full access privileges and are the sole guest of a database hosted from FileMaker Server 5, you can access the Define Fields dialog box directly from the guest machine. You no longer have to close the database in FileMaker Server and reopen it locally in FileMaker Pro 5.

I have found that defining fields from a guest machine on a database hosted by OS X will break relationships from time to time. But shutting down server and defining fields from FMPro on server machine and then re-opening server works okay.

Thanks a lot Trevorg

Cheers

Nick