Thursday, January 31, 2008

Click Here For Chapter

Want to find out a little bit about Access 2007

Martin Reid has a free book chapter telling you about what is new in Access 2007. Not a bad way to read about this topic. Better still is to find a newish PC (that doesn't matter if the old version of Access gets trashed) and install a new version of Access 2007 and upgrade your favourite database. Anyway this book chapter reads and prints well. Given that service pack one is out, there should be no more excuses about not trying Access 2007.

Click here for Access 2007 Book by Martin Reid

Thursday, January 24, 2008

Steve Schapel: Real World Access Story No. 30

Steve Schapel from NZ has joined the MVP's that are contributing to my new MaxOut Access newsletter. Here is a sample article from a huge series of Access Real World stories at Steves Blog. In this article you will learn how Access is used to generate XML feeds for posting UK Stamp Duty information.

Join Our MaxOut Weekly Newsletter Here

Thursday, January 17, 2008

Closing Down Databases With The Workbench

Here is one of the questions and answers from the Workbench FAQ page.

We purchased the Workbench at the request of one of our developers.
He thought he had the ability to close open databases, or kick the users off of it, but I don’t see that ability. Am I missing something here?

It is in the Workbench, you need to add a bit of code and a form to each database.
Read MoreHere

You may have the Admin button turned off, it can be turned on in the Options form by pressing the options button. See figure 2 on this page.
Read more here

Tuesday, January 01, 2008

Shift Key

Hi Garry

Any tips on preventing a user from getting to the database window by holding down the SHIFT key when opening a database?

Robert
--

Allow Bypass Key

http://msdn2.microsoft.com/en-us/library/aa200349.aspx

Easy to do in my workbench
http://www.vb123.com/workbench/help/version.htm#Startup

--

Many thanks for such a prompt and helpful response.

Robert