Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2910

Re: Unable to Convert an FMP8 Database to FMP16

Show all headers | View raw

On 2017-10-10 23:13:56 +0000, Charles H. Sampson said:
> Charles H. Sampson <csampson@inetworld.net> wrote:
>> Howard Schlossberg <howard@nospam.fmprosolutions.com> wrote:
>>> On 8/16/2017 3:35 AM, Charles H. Sampson wrote:
>>>> Howard Schlossberg <howard@nospam.fmprosolutions.com> wrote:
>>>>> On 8/15/2017 10:54 AM, Charles H. Sampson wrote:
>>>>>> I'm having trouble converting a database from FMP8 to FMP16. FMP16 says
>>>>>> it appears that the database is damaged. I'm currently using this
>>>>>> database several times a week, with behavior that I expect.
>>>>>> 
>>>>>> Any suggestions? I've thought about export-import but that could be
>>>>>> fraught with problems.
>>>>> 
>>>>> Try saving a copy of the file as compacted and see if that will work in
>>>>> 16.  Otherwise, try doing a recovery of the file and then open that in
>>>>> 16.
>>>> 
>>>> By "compacted" do you mean the finder's compress command (zip)? If not
>>>> that, what?
>>>> 
>>>> I see that there is a Recover command but there's not a word about it in
>>>> my Pogue book. At least there's nothing about it in the index. I'll
>>>> experiment with this when I can. I'm going on a long trip that will
>>>> prevent any more work on this for a month.
>>> 
>>> On the file menu, if you go to Save As, you have the choice between
>>> saving a copy, a clone, or compacted.  Compacted copies manipulate the
>>> file structure in a way that MAY make it operable in 16 without error.
>> 
>> Thanks, Howard. I'll try that as soon as possible.
> 
> I'm back after a lot of time off doing other things. I tried all
> combinations of recovered, compacted, and cloned on the problem
> database. I got four versions that FMP16 was able to convert. Now I need
> to do sanity checks to see if what I have is good.
> 
> The file that's giving me all the trouble was an import from Reflex
> Plus, which handled many-to-many relationships. I did a clumsy job of
> creating an FMP7 database that had the same structure, caused in part by
> the fact that FMP7 doesn't do many-to-many relationships and missing the
> stuff in the Pogue book addressing this, which is very short. My
> question is, does FMP16 handle many-to-many relationships directly,
> without the use of intermediate tables? If so, I'll get a new copy of
> the Pogue book (maybe).

FileMaker Pro does "many-to-many", even way back with early versions 
(may require an intermediary Table), but it really depends on why, how 
and what you want to achieve.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Unable to Convert an FMP8 Database to FMP16 csampson@inetworld.net (Charles H. Sampson) - 2017-08-15 10:54 -0700
  Re: Unable to Convert an FMP8 Database to FMP16 Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-08-15 12:17 -0700
    Re: Unable to Convert an FMP8 Database to FMP16 csampson@inetworld.net (Charles H. Sampson) - 2017-08-16 03:35 -0700
      Re: Unable to Convert an FMP8 Database to FMP16 Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-08-16 08:13 -0700
        Re: Unable to Convert an FMP8 Database to FMP16 csampson@inetworld.net (Charles H. Sampson) - 2017-08-16 12:42 -0700
          Re: Unable to Convert an FMP8 Database to FMP16 csampson@inetworld.net (Charles H. Sampson) - 2017-10-10 16:13 -0700
            Re: Unable to Convert an FMP8 Database to FMP16 Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-10-11 13:26 +1300
            Re: Unable to Convert an FMP8 Database to FMP16 Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2017-10-10 17:29 -0700
  Re: Unable to Convert an FMP8 Database to FMP16 Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-08-16 09:00 +1200
    Re: Unable to Convert an FMP8 Database to FMP16 csampson@inetworld.net (Charles H. Sampson) - 2017-08-16 03:35 -0700

csiph-web