Jump to content
Sign in to follow this  
Oldsneekers

?This file is not modifyable

Recommended Posts

FM server 9 hosting files.

on the host I also have FM9 advanced in case I have to do some tweeking.

Problem is: after compacting a file using FM9Advanced (while FM9Server is quit) the file is accessable and modifiable in FM9 Advanced but when I switch to the FM9Server and access the file from a guest (which has it's own copy of FM9Adv with different license), I can't manipulate inside the relationship window and I can't edit records. I haven't tested all functions but these. When I put back the pre compacted copy of the file into the FM9Server data file, all is well. This occurs with all compacted copies of various files. I end up putting the original back and trashing the compacted file.

I do rename the original file before substituting the compacted file.

How can I compact files periodically and still have them hosted in FM9Server and accessabe and modifiable from hosts?

Thanks to the teaming millions.

OS

Share this post


Link to post
Share on other sites

Sounds like the permissions on the compacted file are wrong for FM Server.

Use the FMS Admin Assistant to UPLOAD the file back to the server - this will set the permissions correctly

Share this post


Link to post
Share on other sites

This is an OS permissions issue.

Second, what do you mean exactly when you say "compacting" the files? if you are using the so-called file maintenance options to do this, that is not a good idea.

Steven

Share this post


Link to post
Share on other sites

By compacting, I mean the command under File>Save a copy as> Type of copy> compacted.

I have been told, by those more experienced than I, that this is good to do every so often with large files.

The only other way I see to "optimize the system" is to "Optimize" with a disc utility but that is a bit more time consuming.

Any other suggests for keeping the disc tidy and the files fast? If this 'compacting' is not a good idea, why? I understood it removes unneeded disc space.

Thanks.

OS

Share this post


Link to post
Share on other sites

By compacting, I mean the command under File>Save a copy as> Type of copy> compacted.

This is OK to do. It's the file maintenance compact that is not a good idea[color:red] and should never be used on a file suspected of being damaged.. That feature has, very happily, been removed in FileMaker Pro 10.

The only other way I see to "optimize the system" is to "Optimize" with a disc utility but that is a bit more time consuming.

Do not run disk optimization utilities on FileMaker Server drives that have files on them. Remove the FileMaker Pro files first, then optimize the drive, and then return the files to the drive. If the optimization fails for some reason, the bits of your FileMaker files can be scrambled three ways to Sunday.

Steven

Share this post


Link to post
Share on other sites

About permissions with FM server

I am trying to compact my files in FMServer9. I have FMAdv10 on the server as well as FM Server9.

Using FmAdv I compact the file. Change the OriginalName_Copy to the OriginalName and place it on the Desk top. I renamed the precompacted original file ( by adding _PreC to the file name) in FMServers Database folder so that my solution knows what file to access. I turn off FMAdv and turn on FMServer and use the upload function to upload it. Now I get the message "Permissions Denied".

OK now I figure I have to use FMServer to "remove" the file before compacting and renaming but want to know if I "remove" it using FMServer will it be exploded into quantum bits or teleported into a parallel universe or will I find it in another folder?

Is there anything else I need to know to keep my 6 file, separation model solution running smoothly and bug free?

Many thanks.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.