lpyne

About Susan Pyne

I started with the firm as a Sales Assistant and over the years worked my way up to Senior Access developer, I’m certified on Power BI, with more certifications coming. I'm also the chapter coordinator for AccessUserGroups.org, a worldwide organization of Access virtual chapters that meet each month online to discuss a range of topics in different languages. I LOVE working with Access and learning new technologies!

Preview Documents in Microsoft Access Form

Preview Documents in Microsoft Access Form Project Scope We recently added a document center to a project which allows users to attach documents such as pdf, word, txt and images to a project.  In addition they will have an automatic process set up to read incoming emails and save the email attachme [...]

2021-06-25T03:59:25-05:00October 6th, 2020|

Alternative Solution to DCount and DLookup with MS SQL Server Backend

Alternative Solution to DCount and DLookup with MS SQL Server Backend   One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables.  We recently worked on migrating a pure Access solution to SQL server and encountered delays on the load [...]

2021-06-11T05:05:57-05:00July 23rd, 2020|

Search Microsoft SQL Server Database for Stored Data

Search Microsoft SQL Server Database for Stored Data   Have you ever had to decipher a database and identify which column has the data you need? I recently had to work with extracting data from a SQL database to use in Microsoft Access and Power BI, unfortunately the naming structure of the dat [...]

2021-06-25T07:30:03-05:00June 19th, 2020|

Access with Microsoft SQL Server – Import Large Datasets Using SSIS

Access with Microsoft SQL Server – Import Large Datasets Using SSIS Dying with an Access Insert Query If you’ve ever tried to insert a large amount of records into SQL Server using an Access insert query, (15,000 records or more), you’re in for a long wait, were talking coffee break time here, (from [...]

2021-06-11T05:43:49-05:00February 7th, 2019|

Using SQL Views to Add/Edit Data in Microsoft Access

Using SQL Views to Add/Edit Data in Microsoft Access This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. Wi [...]

2022-01-07T08:59:56-06:00September 25th, 2018|

Text or Numeric Field – A Simple SQL Method to Switch Data Type

Text or Numeric Field – A Simple SQL Method to Switch Data Type I recently worked on a project where our client is selling a product throughout the USA built on Access with SQL Server, it works by importing data into SQL and then analyzing it with Access reports. Unfortunately each customer may have [...]

2021-06-11T06:10:54-05:00June 26th, 2018|

Unanswered Questions About MS SQL Server Security and Access Control

Unanswered Questions About MS SQL Server Security and Access Control For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude [...]

2021-06-11T07:32:51-05:00November 15th, 2016|

Ten Ways Your Data Project is Going to Fail

Ten Ways Your Data Project is Going to Fail Data science continues to generate excitement and yet real-world results can often disappoint business stakeholders. How can we mitigate risk and ensure results match expectations? For more information go here. [...]

2021-06-11T07:33:41-05:00November 15th, 2016|

The Evolution and Future of Microsoft Access

The Evolution and Future of Microsoft Access Mark your calendar for next Tuesday October 11th at 6.30pm central time! AccessUserGroups.org was founded by Access MVPs Juan Soto and Ben Clothier in order to foster virtual Access user groups nationwide.  This month the meeting of SQL Server with Access [...]

2021-06-11T07:35:14-05:00October 4th, 2016|

In Depth Discussion of the Microsoft SQL Server Migration Assistant

In Depth Discussion of the Microsoft SQL Server Migration Assistant AccessUserGroups.org TUESDAY, MARCH 10th @ 6.30pm CDT This month Juan Soto, Microsoft Access MVP,  will be presenting at talking about how to install SSMA, configure it’s use, doing your first upload to SQL Server and how to leverag [...]

2022-04-12T04:47:13-05:00March 7th, 2015|
Go to Top