6 Reasons why you should always use Access with SQL Server
If you’re having a hard time convincing management to use Access with SQL Server, then use this post as ammunition to get your point across: Reason #1: Security I’ve walked into situations where new clients are storing their customer’s credit card info, (including the three digits on the back), along with their billing address, home address [...]
Web training session January 26th live from Chicago!
I’ll be presenting at this month’s Chicago Access User’s Group. (www.CAUG.com) It will be broadcast-ed live via the web as I present my newest topic: Access Kung Fu – Tap into your inner VBA Sensei We will discuss three topics, TempVars, Enums and Classes. TempVars are a great way to store global variables in your [...]
How to save your SharePoint password in Windows
A poster asked me a wonderful question: “How do I get Access [linked to SharePoint] to remember my login credentials so I don’t have to login everytime?” The answer to the question isn’t simple as it should be and hence, I felt an article on the subject would be helpful for those who want to [...]
Create temp tables in Access from SQL Server tables
If you’ve ever asked Access to do a join between a local Access table and SQL Server table (which is called a heterogeneous join) you may have experienced first hand how slow it can be to process results. The situation could be vastly superior if you can afford to download the SQL table as a temporary [...]
