Concurrent access to SQL Server tables from a Filemaker 10 Pro Advanced application
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.