Category Archives: Access

Strategies for Managing Spreadmarts

Business users are empowered by knowledge—and knowledge comes, in part, from having access to accurate and timely information. It is generally up to the information technology (IT) department to supply this information. But it doesn’t always work out that way. … Continue reading

Posted in Access, SQL Server | Tagged , , | Comments Off on Strategies for Managing Spreadmarts

Building your own app without any coding

I am interested in trying out these IDE that are targeted towards non-programmers. I think that Microsoft Access is easily one of the most productive tools ever built.. And it was targeted towards non programmers. I detest Access as a … Continue reading

Posted in Access, SQL Server, Visual Basic | Tagged , , | Comments Off on Building your own app without any coding

my favorite Windows API calls in VB

When a VBA solution falls short of your needs, there’s probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work. Office developers rely heavily on … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on my favorite Windows API calls in VB

Picture of me!!

Just a quick picture of Aaron Kempf.

Posted in Access, ADP, Funny, Internet Explorer, picture of me, SQL Server, Uncategorized, Web Development | Tagged | Comments Off on Picture of me!!

Microsoft restores transfer rights for retail Office 2013 copies

Looks like Microsoft caved on office 2013 licensing, now if we could get them to restore sql server compatibility in Microsoft access 2013, then maybe I would consider it. Until then, I will avoid office 2013 like the plague. http://www.zdnet.com/microsoft-restores-transfer-rights-for-retail-office-2013-copies-7000012200/

Posted in Access, SQL Server | Tagged | Comments Off on Microsoft restores transfer rights for retail Office 2013 copies

VSTO Add-ins for Access?

I still don’t understand why this isn’t fully supported. Is Visio and Project _REALLY_ more popular than MS Access? I don’t think so!?!?!   Well here’s a work around, looking forward to trying this out!   http://blogs.msdn.com/b/andreww/archive/2008/02/19/vsto-add-ins-for-access.aspx   Armed with … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on VSTO Add-ins for Access?

http://www.wired.com/wiredenterprise/2012/10/salesforce-oracle/

I detest Oracle, it is a halfwit database for morons. My first job outta college, I had six Oracle dev/dba at this HP funded startup, and they couldn’t do simple ecommerce. I just think that Microsoft olap owns the market, … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on http://www.wired.com/wiredenterprise/2012/10/salesforce-oracle/

Office Store is open!

This is sad though.. I’m sure that Microsoft will focus on Powerpoint, Word, Excel.. and Ignore the best product in the MS Office suite– Microsoft Access rocks! http://www.zdnet.com/microsoft-opens-the-office-stores-doors-7000002257/

Posted in Access, SQL Server | Tagged | Comments Off on Office Store is open!

Microsoft Access 2012 Wish-List

I ran into this on the internet.. I think that it’s funny.. because I think that Access Data Projects include all 5 of these features already: Q: New Feature 1 – Recording Macros A: I use SQL Profiler for this!!! … Continue reading

Posted in Access, SQL Server, Visual Basic | Tagged | 1 Comment

Don't rewrite old code 'just becase it's old'

http://www.joelonsoftware.com/articles/fog0000000069.html             Joel on Software Things You Should Never Do, Part I by Joel Spolsky Thursday, April 06, 2000 Netscape 6.0 is finally going into its first public beta. There never was a version 5.0. The last major release, version … Continue reading

Posted in Access, Internet Explorer, SQL Server | Tagged | Comments Off on Don't rewrite old code 'just becase it's old'