|
|
-
|
|
There are a number of reasons to write data to the registry such as saving the settings
preferred by an individual user to storing an activation key or a demo version expiration
date. But before we can save any values to the registry we must have a registry
key to hold the infor......
|
|
-
|
|
Even though Access is the best rapid development tool for databases I have ever
used, some things can be drudgery. Take form controls for example. Access names
the controls on a form the same as the control source. This makes it easy to have
errors. You may try to use the name o......
|
|
-
|
|
The free Code Tracker™ Beta Add-in for Microsoft Access® has been upgraded to Version 1.0 and can be used in Access 2002, 2003, and 2007. It is a free download.
The Code Tracker™ 1.0 Add-in records the use of every procedure in your database. You can see how and when your co......
|
|
-
|
|
A free mdb edition of the Code Tracker™ for Microsoft Access® is now available for
those who cannot use an Add-in. This Code Tracker mdb edition was developed to help
someone whose company policies and practices would not allow them to install an
Add-in. You can downlo......
|
|
-
|
|
Learning to develop Microsoft Access Cloud applications using SQL Azure as a back end is new territory. Although there are many similarities to developing an Access application that uses a hosted SQL Server database, there are also a number of differences that can trip you up unless you are aware of......
|
|
-
|
|
In this article we will demonstrate how you can use a Pass-through query in Access with VBA code to create SQL Azure Logins. Microsoft Access can then use the Login and Password to gain access to SQL Azure Tables, Views, and Stored Procedures. We will create a Login using SQL in Access similar to th......
|
|
-
|
|
Why do we need a SQL Azure Database User Account? An Access Database cannot access SQL Azure Objects such as Tables, Views, or Stored Procedures without one. That is, unless you use your SQL Azure Administrator account which would be living very dangerously if you were distributing your database to ......
|
|
-
|
|
One of the best things about SQL Azure is how easy it is to manage User security. In this article we will show you how you can use Microsoft Access to add individual Users to Database Roles which makes managing User security much easier.
The Benefits of Using Flexible Database Roles
If you grant......
|
|
-
|
|
I was shocked. I had heard that Constants and Variables could be seen by opening an accde or mde file with a hex editor but when I opened my file I was stunned to see so much of my data, objects, and code in plain text. I am not an Access Security expert, but I decided to take on the challenge of th......
|
|
-
|
|
I have not posted here for a while because I have been very busy with a major software project. I am pleased to announce that I have released a Free Beta Access Database Application for small to mid-sized Churches. It is called Church Management Software Solutions. You can read more about it here an......
|
|