FileMaker Pro and FileMaker Pro Advanced produce files of exactlyl the same format. Either can open the same databases--either locally or when hosted from a server. The hosted files can be hosted by FileMaker Pro, FileMaker Pro Advanced, FileMaker Server or FileMaker Server Advanced and it will make no difference.
Filemaker versions 7 through 11 have the same file format so any version of filemaker in that range can open/access files created by another copy in the version range--but features specific to a newer version will not be functional when opening the file with an older version.
FileMaker Pro Advanced is a very import version to use, but only for developers. For a general user, it offers no features not found in FileMaker Pro. I recommend that all developers get a copy of advanced as the debugger, data viewer, design report features will save them hours of effort and the custom menus, custom functions features provide design options not available in FileMaker Pro. (But those features, once added to the file work just fine when opened with FileMaker Pro.