Missing linked tables
I'm a SQL Server DBA and completely new to FM. I'm using FM Pro 10 Advanced.
I have an existing database, but when I open it I am told that a number of linked database files can't be found. How do I find out where it's expecting to find those files and how to I go about linking them to it?
I've been told that over time, some of the data in FM has become corrupt, and that part of the problem is that it is too big. The database is under 1GB, with approx 100,000 records, so I was wondering if there was a limit to what FM can support and if this is a known problem with FileMaker.
Any help that you can provide will be greatly appreciated.