AnsweredAssumed Answered

Concurrent access to SQL Server tables from a Filemaker 10 Pro Advanced application

Question asked by bhatiav2@mail.nih.gov on Jun 10, 2009
Latest reply on Jun 11, 2009 by FluffyBear

Title

Concurrent access to SQL Server tables from a Filemaker 10 Pro Advanced application

Post

We have an environment where we have a number of Info Path applications accessing SQL Server 2005 tables. We are in the process of designing a number of Filemaker applications that would also like to store their data in SQL Server 2005 tables. The question we have is should the two applications have their own sets of tables or can they share the same set of tables. Both these applications will be accessed by a small volume of users during the day. The underlying concern being concurrent access and locks that might impact the integrity of the data. We would love to hear from users who might have had similar challenges and how they resolved these issues.   

Outcomes