fbpx

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 [...]

Preview Documents in Microsoft Access Form2021-06-25T03:59:25-05:00

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 [...]

Alternative Solution to DCount and DLookup with MS SQL Server Backend2021-06-11T05:05:57-05:00

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 [...]

Search Microsoft SQL Server Database for Stored Data2021-06-25T07:30:03-05:00

Using Microsoft Access with Power BI

Using Microsoft Access with Power BI We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com s [...]

Using Microsoft Access with Power BI2021-06-11T05:30:39-05:00

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 [...]

Access with Microsoft SQL Server – Import Large Datasets Using SSIS2021-06-11T05:43:49-05:00

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 [...]

Using SQL Views to Add/Edit Data in Microsoft Access2021-06-11T05:46:25-05:00

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 [...]

Text or Numeric Field – A Simple SQL Method to Switch Data Type2021-06-11T06:10:54-05:00

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 [...]

Unanswered Questions About MS SQL Server Security and Access Control2021-06-11T07:32:51-05:00

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. [...]

Ten Ways Your Data Project is Going to Fail2021-06-11T07:33:41-05:00

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 [...]

The Evolution and Future of Microsoft Access2021-06-11T07:35:14-05:00

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 [...]

In Depth Discussion of the Microsoft SQL Server Migration Assistant2021-06-11T07:53:03-05:00
Go to Top