TSQL

Inserting a record in SQL Server and retrieving key ID.

There are many ways to insert records and retrieve that records key value, this approach will probably be among the quickest since all of the processing occurs on the server, not in Access. The technique uses ADODB recordsets to fetch records from SQL Server. CODE: Private Function CreateDatabaseRec [...]

Inserting a record in SQL Server and retrieving key ID.2010-08-03T16:55:16-05:00

Tips for designing SQL Server tables for Microsoft Access

We LOVE using SQL Server with Access! I frequently mention that SQL Server Express was the best thing to happen for Access, the two combined have the best 1-2 punch in the industry. I encourage you to explore using both technologies, or better yet, hire us to do the legwork. Here are some table desi [...]

Tips for designing SQL Server tables for Microsoft Access2016-12-22T03:39:18-05:00
FREE CONSULT
close slider