|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new site built with
SharePoint Designer |
Is Your Database Corrupt ?
See all newsletters
Access Unlimited is an email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.
Produced by Garry Robinson (known below as "Ed") from Sydney, Australia.
This edition is primarily focused on encouraging the 4500 readers of this humble magazine to participate in a bit of blogging on a topic that I know will be of interest to most of you.
What would you like to see in the next version(s) of Microsoft Access ?
To whet your appetite, Peter Vogel invited Ed to write an editorial on “Access 2006”. This article has now surfaced as the free to read article in the August Edition of Smart Access. Read more at www.pinpub.com. I have also republished the same material at http://vb123.blogspot.com where you can do more than just read, you can post your comments and ideas (anonymously) along with many others already posted in the comments section.
After you chaps and gals have all added your little gems. Peter and I will organize your ideas, publish them in Smart Access and at http://vb123.com/access2006 and then send the list onto to Microsoft.
Remember the best way to improve your software is not to have a good idea but to have a list of good ideas. Same principle applies to Microsoft as it does to the humble backyard developer. Read and Add Your Comments Here
Ed
Latest Access Workbench Beta: 16-July-04
A new beta version of the workbench has been released. It includes
(1) You can select from Access 2003, 2002 or 2000 to open you Access 2002 or 2000 format databases. (2) There is now a facility to view and change the release version of the database. The release data and version number need to be stored in a table in the database. We provide the format for this with the registered copy. (3) The software includes a button to open backup databases in the backup folder. This is useful when you are looking for the original of that form that you just edited. You can also delete backup databases produced by the workbench from the backup tab in the workbench.
http://www.vb123.com/workbench
---- Advertisement ---
The Easy Access Database Directory is a non commercial enterprise, which offers a free directory service (including a free listing for anyone, whether they are a commercial business or just an enthusiast) in relation to Microsoft Access resources, which can be easily browsed by category or via key word searches.
Visit us today as http://www.directory-base.com/access/
GOOD READING
Find the
number of records effected by an SQL query in Access
http://www.techonthenet.com/access/modules/recordsaffected.htm
Discussions on DbEngine.Execute verses doCmd.runsql in Access
http://www.developersdex.com/vb/message.asp?p=2899&r=4320246
Ed Note: Can anyone verify the speed performance differences between the two approaches mentioned above ? If so email use the comments link on the side.
How to manage the SQL Server Desktop Engine (MSDE 2000) by using the OSQL utility Read more
Connect an InfoPath form to an Access database Read more
Remove
hidden data from Word 2002 or 2003 Add-In
Read More
Moving
The Temp and Master DB in SQL Server
http://www.databasejournal.com/features/mssql/article.php/3379901
Managing
Group policy in Windows
http://mcpmag.com/columns/article.asp?EditorialsID=745
Display
an Excel range in an Access listbox
http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm
I love
golf but not as much as this nutter who lost over 500 balls playing from one
side of Mongolia to the other.
http://www.pgatour.com/story/7530334
FMS Paper
on compiling and other things
http://www.fmsinc.com/tpapers/vbaint/
Upsize
Access Reports to SQL Server Reporting Services
http://www.databasejournal.com/features/msaccess/article.php/3373661
Send Faxes
with VB 6 and a Modem
http://www.freevbcode.com/ShowCode.Asp?ID=6685
Process a
group of queries as a batch (in MySQL)
http://www.databasejournal.com/features/mysql/article.php/3382171
The facts and figures of the copper exploration project in Mongolia that we provide database support for. The geology database is a 250 megabyte Access database with 100 tables. 32 of the tables are linked will referential integrity to the one master table. And it all works most are time!!! http://www.ivanhoe-mines.com/s/TurquoiseHill.asp
--- The end of this edition of Access Unlimited ---
So thanks for reading our popular newsletter. Feel free to make comments, copy the email to a friend or maybe even contribute to the next edition. And if you can, have a look at our software by using the Marketing section on the left hand side of this newsletter. If you really like this newsletter, why not purchase The Toolshed and you will get all the other newsletters and plenty more in a developer’s knowledge base tool with super searching facilities.
Garry
Robinson - Software Consultant and Author
PS Don’t
forget Garry’s book …
http://www.vb123.com/map/
Click on this button
to read the previous edition of Access Unlimited
Published 2004-08