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!

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 so that other employees can see the an [...]

Access with Power BI2019-09-08T20:26:01-05:00

Access with SQL Server – Import large datasets using a simple SSIS job.

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 a few minutes to 15). It may even cause your database to hang if th [...]

Access with SQL Server – Import large datasets using a simple SSIS job.2019-02-07T08:30:31-05:00

USING SQL VIEWS TO ADD/EDIT DATA IN 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. With relational databases and lookup tables you can eas [...]

USING SQL VIEWS TO ADD/EDIT DATA IN ACCESS2018-09-25T06:14:44-05:00

Text or Numeric Field – A simple 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 a primary key format as a long integer and others where it's a [...]

Text or Numeric Field – A simple method to switch data type.2018-06-26T19:49:56-05:00

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

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 about the value to any organisation of having database applications t [...]

Questions About SQL Server Security and Access Control You Were Too Shy to Ask2017-02-07T00:18:38-05:00

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 Fail2017-01-16T22:25:20-05:00

The Evolution and Future of 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 group will include an interview with Luke Ch [...]

The Evolution and Future of Access2016-10-05T19:36:13-05:00

In depth discussion of the 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 leverage SSMA in subsequent migrations. This is a must attend for anyone lo [...]

In depth discussion of the SQL Server Migration Assistant2016-08-08T20:57:16-05:00

Access User Group Webinars for December

Here are the details for 2 of our 5  Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participate. Interested in joining one of our virtual AUGs? We h [...]

Access User Group Webinars for December2014-12-03T00:04:14-05:00

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently

Ben Clothier, Access MVP and co-founder of the AccessUserGroups.org, will be presenting at this month's meeting for the SQL Server with Access Group. He will discuss working with XML data with an SQL Server backend. Earlier this year Ben posted a 2 part blog posts on this topic and this will be an u [...]

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently2014-10-04T06:55:13-05:00

SQL Server with Access Meeting

Please join Ben Clothier on Tuesday August 12th at 6.30pm CDT for our monthly meeting. We are excited to have monthly meetings to discuss Access with SQL Server topics! We meet every second Tuesday of the month at 6:30 PM Central Daylight Time (CDT). Topic: Managing large files with Access and SQL S [...]

SQL Server with Access Meeting2014-09-02T21:30:40-05:00