Access
Access detective – find differences in databases
Website For over two decades, Total Access Detective has supported every major Microsoft Access version adding many enhancements along the way: Original Release and Major Updates by Microsoft Access Version Access Version Introduced Product Name Product Version Major Releases Upgrade from Another Version Upgrade in Same Version Access 2.0 Jun 1995 Total Access Detective 2.0 […]
MS Access Converter – Issue Checker
Microsoft Access: Applications and Utilities Provided by Allen Browne, June 2006. Last updated: 8 May 2010 Database Issue Checker Utility This free utility (160 KB zipped) reports on potential issues with the structure of Access databases. It makes no changes to the databases you examine. The utility is intended for developers to check their application during design, […]
Best way to do Access search or find
Best way to do a search and result database form is using a filter. See FMC Supporter database as an example. that Angie did. Also see under the infoage backup folder Angie’s goodies scripts.
How to Lock Down that .accdr!
How to Lock Down that .accdr! Mark EdwardsPresident/Chief Architect at VBA Office Solutions, LLC With all the issues surrounding Access app security like a Navigation Pane that won’t stay hidden, or being able to change the extension on a .accdr file name to .accde or .accdb to crack it open, etc., I’ve been busting my […]
Winconnect RDP alternative – remote access software
Can buy Winconnect and use on main server for small numbers of users, is good alternative to use instead of separate Terminal Server where cost is an issue. http://www.thinsoftinc.com/index.aspx DA Mike Chadis referred to this software
Access VBA trick
1. How to ‘hide’ 0 as the chart label, format the label as custom $#,##0_);($#,##0);
Suppressing Zeros in chart labels
The Problem: Susan’s issue is that not every data point is represented by her sales reps. Here, you’ll notice that Kim has no Service Contracts for the month selected. This not only causes the data label to show ($0), but it also muddles the placement of the Service Contract data label. The Solution: An […]
Share Access in web browser / Access database hosting
Access Hosting $29 per user per month USD. Can run in HTML5 browser $49/month. EQL Data (web browser) You pay a fixed rate every month: no hidden charges. $49/month for 1 user at a time. $245/month for 5 concurrent users. $490/month for 10 concurrent users. Microsoft Sharepoint Online $4 per user per month USD also part of Office 365 $7.70 per user pe rmonth USD – 1 month […]