Recent content by ND Pard

I recently inherited a .ADP file that is the front-end of a 2012 SQL Server database. The program managers want me to add a field to a table and to create a new report. When I open the .ADP file, the following message appears: "Read-Only This database has been opened read-only. You can only...

Tiger955, I appreciate your response. It appears you are using DAO instead of ADO. From what I have read, it said if you are going to use DAO to transfer any significant amount of records into the SQL Server table, plan in taking a coffee break (or two) while you wait. They strongly recommend...

Rx, I am looking for a faster way to transfer data from a Access 2010 database to a SQL Server 2008 R2. The number of records varies; this is a daily task and has had upto 60,000 records and as little as 300 records. These records are our daily transactions; all of the daily transactions...

I am working with MS Access 2010 and SQL Server 2008 R2. Currently, I use .ADPs and VBA to append data into the SQL Database table(s). I understand that in Office 2013, "ADPs are Dead!". I am looking for best practice Access VBA examples that append data from an Access table into a SQL Table...