MS Access and SQL Server concurrency? 
Author Message
 MS Access and SQL Server concurrency?

Does anyone have a good resource for concurrency in a client-server
application using an MS Access 2002 front-end and MS SQL Server 2000
back-end? Like a knowledge base article, MSDN article, or book? We need to
know about locking strategies with ADO. We'll be using unbound forms.

Thank you.



Sun, 15 May 2005 08:42:40 GMT  
 MS Access and SQL Server concurrency?


Quote:
> Does anyone have a good resource for concurrency in a client-server
> application using an MS Access 2002 front-end and MS SQL Server 2000
> back-end? Like a knowledge base article, MSDN article, or book? We
> need to know about locking strategies with ADO. We'll be using unbound
> forms.

I would recommend "Microsoft Access Developer's Guide to SQL Server" by
Mary Chipman and Andy Baron. It covers unbound Access apps with MSSQL
backend quite extensively, concurrency included.

--
(remove a 9 to reply by email)



Sun, 15 May 2005 09:10:23 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Executing MS SQL Server 2000 stored procs via MS Access 2000

2. Moving Oracle records to MS SQL Server using MS Access

3. Complicated Record Handling on MS Sql server and MS Accesses Databases

4. CA-Prog Analyst, MS SQL Server, Visual Basic and MS Access

5. Access to MS ACCES and MS SQL server

6. Application Development: MS-Access, Visual Basic, SQL Server, SQL Anywhere

7. MS Access 2002 vs VB.net as a front-end to SQL Server data

8. Q: Obtaining SQL Server Default Values While Adding Records in MS Access

9. Calling a SQL Server 2000 store procedure from MS-Access

10. Data Replication between SQL Server 7 and MS Access 97

11. Access Vs MS SQL Server

12. US-NY-New York City-Visual Basic-MS ACCESS-SQL Server-SYBASE-RDO

 

 
Powered by phpBB® Forum Software