Developer Download: Report Selection Techniques

Two different examples of a pop-up report selection criteria form. This technique is great for allowing the user to choose which records will appear on a report, without using parameter queries. Other report techniques (like hiding and showing report sections) are shown also. Access MDBs and PowerPoint presentation, 800k.

http://www.jstreettech.com/files/Report-Record-Selection-Techniques.zip

Access Developers Conference in Vienna, Austria

Access in Vienna is only 2 weeks away! If you haven’t registered yet, be sure to do it soon!

For more details visit http://jstreettech.com/accessday.aspx

Developer Download: Access-SQL Server Optimization

The Best of Both Worlds: Access-SQL Server Optimization

http://www.jstreettech.com/files/Best-of-Both-Worlds.zip

Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of SQL Server while retaining the techniques you have learned in Access. PowerPoint, 379K.

Developer Downloads: Access Security Basics

Access Security Basics: http://www.jstreettech.com/files/AccessSecurityBasics.pps

Access User Level Security (ULS) has been deprecated for the ACCDB file format, but many people are still using ULS for their legacy Access MDB applications. Here is a PowerPoint slide deck that Armen Stein, President of J Street and Access MVP, has presented to Access user groups. It describes various approaches for securing an Access database with ULS, with some common mistakes that developers often make and tips to avoid them. PowerPoint file, 139k.

J Street Case Study: Bellevue Botanical Garden

We design and create a LOT of databases for a variety of clients and we end up with some really interesting projects!

One of these is the database for Bellevue Botanical Garden.  We built a custom database allows everyone to search and explore their garden online!  Check out the Case Study here.

J Street Developer Download: Access Security Basics

Access Security Basics
Access User Level Security (ULS) has been deprecated for the ACCDB file format, but many people are still using ULS for their legacy Access MDB applications. Here is a PowerPoint slide deck that Armen Stein, President of J Street and Access MVP, has presented to Access user groups. It describes various approaches for securing an Access database with ULS, with some common mistakes that developers often make and tips to avoid them. PowerPoint file, 139k.

J Street Buzz – The Lottery Problem

The latest edition of the J Street Buzz is out!

 

J Street Buzz – The Lottery Problem

Developer Download: The Best of Both Worlds: Access-SQL Server Optimization

The Best of Both Worlds: Access-SQL Server Optimization:
http://www.jstreettech.com/files/Best-of-Both-Worlds.zip
Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of SQL Server while retaining the techniques you have learned in Access. PowerPoint, 379K.

Fake “FTC investigation” email making the rounds again

https://www.consumer.ftc.gov/blog/fake-ftc-investigation-email-making-rounds-again

Happy New Year!

A new year means new beginnings!

Need help making your business as efficient and effective as it can be with a new database for your data? Need help updating your existing system?

Contact us – we can help!