Re: FM Pro 6: lost many records.



Fergus McMenemie <fergus@xxxxxxxxxxxxxxxx> wrote:

I have a site running a filemaker pro 6 database which serves about 6
users on various networked macs running os9 and os x. This has proved
itself to be an extremely reliable application, over the years. Recently
a more active pattern of usage has developed with a lot more data entry.

However, something went wrong and many hours worth of data entry was
lost. I am at a loss to explain what went wrong. Magagment has lost a
lot of confidence in the system. The only thing I can think of was two
users, activity editing records, were both using the same password. Is
there any problem with this?

There shouldn't be.

There is a second possibility, I dont have filemaker server. In theory
a user on the disk server opens FM pro first and others then connect to
the running copy of the DB. But I suspect that in some cases it is being
opened by others via a file shared disk. Is this likely to cause
problems?

Yes! Two copies of FileMaker Pro directly accessing the same database
file(s) from a shared location can easily cause corruption of the
database.

The only safe way to have shared access to a database (if you don't
trust your users) is to put the database files in a location which is
only accessible to the one user who is supposed to be hosting the
database, and for everyone else to access it via FileMaker's database
sharing.

There is no problem in this case with you using FileMaker Pro to share
the database.

FileMaker Server is required for a greater number of users, and adds
some benefits such as being able to back up the database cleanly.

--
David Empson
dempson@xxxxxxxxxxxxx
.



Relevant Pages

  • Re: FM8: Logging in as Guest on IWP
    ... What I am talking about is using a web browser to access a database hosted ... In all prior versions, when IWP access was enabled for the Guest account, ... In FileMaker Pro 8, a forms-based authentication screen *always* appears ...
    (comp.databases.filemaker)
  • Re: publishing on the web with filemaker pro via a local network
    ... i would like publish on the web a filemaker pro database which is on a given computer on my local network ... but neither "no database available" nor the list of available databases, neither with icab nor with safari, when i connect via apache, ... Also in your config section for filemaker on the database concerned you need to turn on sharing and stipulate port 591. ...
    (comp.databases.filemaker)
  • Re: Potential Convert requires a Test
    ... are smoothly blended into TreePad? ... What problems do you have with Filemaker Pro? ... It's obvious what his problem is, snit: Windows XP. ... Since I seldom use a database of any kind (the last I heard, ...
    (comp.sys.mac.advocacy)
  • Re: access and mount drive remotely
    ... I don't actually want to control the Mac, just want to be able to access and edit my Filemaker Pro databases from home. ... I want to work with the database and save changes to it from home. ... We have a cable modem at work with a static IP address with a Linksys router connected to it. ... Install vnc server on the host machine & set up a strong password for access. ...
    (comp.publish.prepress)
  • Re: Similar Programs - MS ACCESS
    ... Three database packages that come to mind when discussing competitors to ... Filemaker Pro, Alpha Five, and Lotus Approach. ... Filemaker Pro has to offer in the way of development language, ...
    (comp.databases.ms-access)