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