Access 2002
- 201279 Upsizing Wizard in Access 2002, Access 2003 or Access 2007 database results in message when attempting to upsize to SQL Server 2008
Access 2007
Showing posts with label microsoft access. Show all posts
Showing posts with label microsoft access. Show all posts
Friday, September 03, 2010
Important Access Updates
Latest KB Articles courtesy of KB Alertz:
Access 2002
Access 2002
Monday, June 21, 2010
Monday, October 05, 2009
Wednesday, July 22, 2009
Useful VBA Code for Office Applications
The following recent blog posts provide some very useful code:
The following recent blog posts provide some very useful code:
- From VBA Tips & Tricks How to save a Word 2007 document as a PDF
- From Daily Access Tips A generic form data validation function. The sample code calls the function from the form's VBA module's OpenForm event. You could streamline the call by using a no-module form where the function is assigned to the OnOpen Event in the form's properties dialog: =SetValidatorEventHandlers(Me)
Thursday, July 09, 2009
New Web 2.0 Switchboard for MS Access
I have just relased a great new Web 2.0 Switchboard for MS Access offering all the rich functionality of a Web 2.0 gui without OCXs or DLLs - using only native Access controls:
Saturday, July 04, 2009
Latest Access KB Articles
Courtesy of KBAlertz.com:
Access 2000
Courtesy of KBAlertz.com:
Access 2000
971815 No Data Appears on Data Access Pages opened in Internet Explorer 8.0
Access 2002969403 Description of the update for Access 2002 (Vbe6.msp): April 27, 2009
Access 2003972557 Description of the Access 2003 hotfix package (Msaccess.msp): June 30, 2009
Access 2007968245 Description of the Access 2007 hotfix package (Ace.msp, Mso.msp): February 24, 2009
970233 Description of the Access 2007 hotfix package (Access.msp): April 30, 2009969406 Description of the Access 2007 hotfix package (Access-nl-nl.msp): April 30, 2009
970727 Not all 2007 Office SP1 .msp files in the MSE package are installed if you apply the package on a computer that has the February 2009, March 2009, or April 2009 public update or the February 2009 cumulative update installed968861 Description of the Access 2007 hotfix package (Ace.msp): April 30, 2009
969613 MS09-027: Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: June 9, 2009
971859 Description of the Access 2007 hotfix package (Ace.msp): June 30, 2009972558 Performance is slow when you click fields, tab between fields, or scroll down through fields in Datasheet view in Access 2007
972570 Description of the Access 2007 hotfix package (Access.msp, Mso.msp): June 30, 2009972347 Description of the Access 2007 hotfix package (Access.msp): June 30, 2009
Monday, May 25, 2009
Glenn Lloyd Access MVP Blogs
I have come across two blogs by Access MVP Glenn Lloyd, which offer very useful guidance on MS Office and Access:
I have come across two blogs by Access MVP Glenn Lloyd, which offer very useful guidance on MS Office and Access:
- Argee's Access Blog A new blog where Glenn is progressively building a sample Access database. This offers budding Access users and developers the opportunity to progressively follow an expert developer build a business application.
- Argee's Office Help Blog In this blog, Glenn has since 2007 been posting a series of tips and tricks for Office users. The articles are comprehensive and fully supported with explanatory graphics.
Thursday, April 30, 2009
Free Access Tools from Access MVP Bob Larson
Check out Bob's web site for a cool collection of free Access tools and other useful Access tutorials and resources: btabdevelopment.com.
Check out Bob's web site for a cool collection of free Access tools and other useful Access tutorials and resources: btabdevelopment.com.
Friday, February 27, 2009
Latest Access KB Articles
Courtesy of KBAlertz.com:
Access 2007
Courtesy of KBAlertz.com:
Access 2007
- 958786 Description of the Access 2007 hotfix package (Ace.msp): October 28, 2008
- 957690 Description of the Access 2007 hotfix package (Access.msp): October 28, 2008
- 958695 Description of the 2007 Office hotfix package (Stslist.msp): October 28, 2008
- 958846 Error message when you try to create a new database in Access 2007: "Template could not be instantiated"
- 957241 Description of the update for Access 2007 Help: November 11, 2008
- 960307 Description of the Access 2007 hotfix package (Access.msp): December 16, 2008
- 967699 Description of the Microsoft Office Access 2007 hotfix package (Ace.msp): February 24, 2009
- 962214 Description of the Office Access 2007 hotfix package (Access.msp): February 24, 2009
- 958884 Description of the Access 2003 post-Service Pack 3 hotfix package (Msaccess.msp): October 28, 2008
- 960420 Description of the Access 2003 hotfix package (Vbe6.msp): December 16, 2008
- 960319 Description of the Access 2003 hotfix package (Msaccess.msp): December 16, 2008
- 962917 Description of the Office 2003 hotfix package (Stslist.msp): February 24, 2009
Wednesday, October 29, 2008
Access in the Cloud: Beta Testers Required
The Microsoft Sync Framework and SQL Services team are working on a new framework that allows Access developers to store their application and data in a Web 2.0 cloud using SQL Server Data Services, and they are looking for beta testers.
The initiative was announced yesterday at PDC and is code-named Huron, a set of synchronization processes built atop of the sync functionality in SQL Data Services’ cloud database and the Microsoft Sync Framework to provide business database sharing, and offers a a "simple" way to scale data to large numbers of users while not parting from the investment made in current technologies. It also enables users to subscribe and then edit the data locally in the format of their choice whether that is Office Access, SQL Server Express or SQL Server Compact and then push changes into SQL Data Services.
More details are available here on the Access Team Blog.
The Microsoft Sync Framework and SQL Services team are working on a new framework that allows Access developers to store their application and data in a Web 2.0 cloud using SQL Server Data Services, and they are looking for beta testers.
The initiative was announced yesterday at PDC and is code-named Huron, a set of synchronization processes built atop of the sync functionality in SQL Data Services’ cloud database and the Microsoft Sync Framework to provide business database sharing, and offers a a "simple" way to scale data to large numbers of users while not parting from the investment made in current technologies. It also enables users to subscribe and then edit the data locally in the format of their choice whether that is Office Access, SQL Server Express or SQL Server Compact and then push changes into SQL Data Services.
More details are available here on the Access Team Blog.
Thursday, October 16, 2008
Latest Access KB Articles
Courtesy of KBAlertz.com:
Access 2007
Courtesy of KBAlertz.com:
Access 2007
- 952699 Description of the Access 2007 hotfix package: May 23, 2008
- 954570 Description of the Access 2007 hotfix package: June 24, 2008
- 956054 Description of the Access 2007 hotfix package: August 26, 2008
- 956838 Description of the Access 2007 hotfix package: August 26, 2008
- 951944 MS08-055: Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: September 9, 2008
- 954326 MS08-052: Description of the security update for GDI+ for the 2007 Office system: September 9, 2008
- 956054 Description of the Access 2007 hotfix package: August 26, 2008
- 956838 Description of the Access 2007 hotfix package: August 26, 2008
Access 2000-2003
- 955179 Microsoft Security Advisory: Vulnerability in Snapshot Viewer for Microsoft Access could allow remote code execution
- 954193 Description of the Jet 4.0 Database Engine cumulative hotfix package for Windows XP SP2 and SP3, Windows Server 2003 SP1 and SP2, Windows Vista, Windows Vista SP1, and Windows Server 2008: July 2, 2008
- 955441 MS08-041: Description of the security update for Access Snapshot Viewer 2000: August 12, 2008
- 955617 MS08-041: Vulnerability in the ActiveX Control for the Snapshot Viewer for Microsoft Access could allow remote code execution
- 955440 MS08-041: Description of the security update for Access Snapshot Viewer 2002: August 12, 2008
- 955439 MS08-041: Description of the security update for Access Snapshot Viewer 2003: August 12, 2008
- 956722 Description of the Access 2003 hotfix package: August 20, 2008
- 954593 MS08-052: Vulnerabilities in GDI+ could allow remote code execution
- 956722 Description of the Access 2003 hotfix package: August 20, 2008
- 954478 MS08-052: Description of the security update for GDI+ for Office 2003: September 9, 2008
- 953404 MS08-055: Description of the security update for Office 2003: September 9, 2008
- 956131 Description of the Office 2003 hotfix package: August 20, 2008
- 956575 Description of the Office 2003 hotfix package: August 7, 2008
- 954192 Only the first 12,000 tables appear in the Link Tables dialog box in Microsoft Access 2000, Microsoft Access 2002, or Microsoft Office Access 2003
- 957198 MS08-041: Description of the security update for Access Snapshot Viewer: August 12, 2008
Tuesday, October 14, 2008
Security Update for Access Snapshot Viewer 2003 (KB957198)
A security vulnerability exists in the Snapshot Viewer that could allow arbitrary code to run when you open a maliciously modified web page or document. This update resolves that vulnerability:
A security vulnerability exists in the Snapshot Viewer that could allow arbitrary code to run when you open a maliciously modified web page or document. This update resolves that vulnerability:
| File Name: | access2003-kb957198-fullfile-x86-glb.exe |
| Version: | 1.0 |
| KB Article: | KB957198 |
| Date Published: | 10/14/2008 |
| Language: | English |
| Download Size: | 1.1 MB |
Wednesday, September 24, 2008
New v4.0 of SQL Server Migration Assistant 2005 for MS Access
Microsoft SQL Server Migration Assistant (SSMA) 2005 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. SSMA for Access supports Access 97 - Access 2007 databases.
Tuesday, September 16, 2008
Access 2003 and 2007 Hot Fixes
Hot fixes are now available for the following Microsoft Access issues:
Access 2003
- An Access 2003 project (.adp) stops responding when in table Datasheet view, you delete all child rows from a parent row and then delete the parent row. This issue applies only to an Access 2003 project.
- A database in .mdb format in Access 2003 SP3 stops responding when you try to delete a parent record from a table in Datasheet view and the Datasheet view uses a sub-datasheet that is expanded to show the related child records.
http://support.microsoft.com/kb/956722
Access 2007
- In Access 2007, you create a query that does not contain a parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
- When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
- After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
- You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
- You have a printer that has a staple feature. When you print an object in multiple copies in Access 2007, all the copies are stapled as one unit. However, you expect that each copy is stapled individually.
Sunday, August 31, 2008
2007 Office Resource Kit Technical Library in Compiled Help format
This downloadable CHM file (3.5mb) is a copy of content in the 2007 Office Resource Kit technical library. The CHM is current as of 29 August 2009.
This downloadable CHM file (3.5mb) is a copy of content in the 2007 Office Resource Kit technical library. The CHM is current as of 29 August 2009.
Tuesday, August 26, 2008
Untangle MS Access Relations with Ezy Documenter Premium
One of the great features of MS Access is the interactive Table Relations Window, where you graphically create and review table joins. But once the joins start to multiply, the relations window becomes unwieldy, and understanding the joins is like untangling a hopelessly tangled ball of string. This is the relations window that greets you when you open the Access 2007 Northwind sample database:
click to zoom...
You can try moving tables around in an effort to get a better perspective, but perversely it appears even more tangled:
click to zoom...
My Ezy Documenter Premium Access add-in to the rescue! With the Table Relationships Report you can in one mouse-click easily review and automatically document even the most complex table relations - click on the screenshot to zoom:
click to zoom...
This report is only one of a number of reports that this Access Add-In produces:
click to zoom...
Check it out - only US$39.95 - demo available
One of the great features of MS Access is the interactive Table Relations Window, where you graphically create and review table joins. But once the joins start to multiply, the relations window becomes unwieldy, and understanding the joins is like untangling a hopelessly tangled ball of string. This is the relations window that greets you when you open the Access 2007 Northwind sample database:
click to zoom...
You can try moving tables around in an effort to get a better perspective, but perversely it appears even more tangled:
click to zoom...
My Ezy Documenter Premium Access add-in to the rescue! With the Table Relationships Report you can in one mouse-click easily review and automatically document even the most complex table relations - click on the screenshot to zoom:
click to zoom...
This report is only one of a number of reports that this Access Add-In produces:
click to zoom...
Check it out - only US$39.95 - demo available
Neat Office Toolbar Tricks
There is always something you can learn about MS Office. In a post today on her Tech Republic blog, Susan Harkins reveals two really neat tricks to quickly copy or move a toolbar button in any Office 97 to Office 2003 application
There is always something you can learn about MS Office. In a post today on her Tech Republic blog, Susan Harkins reveals two really neat tricks to quickly copy or move a toolbar button in any Office 97 to Office 2003 application
Monday, August 25, 2008
New Excel Chart Wizard
Microsoft Office Labs has developed the Chart Advisor: a prototype add-in that provides an alternate approach for creating charts in Excel 2007 and uses an advanced rules engine to scan your data and, based on predefined rules, displays charts according to score.
Top scoring charts are generated charts, ranked, and displayed as thumbnails in a dialog for preview and tweaking by filtering data and how it is mapped.
I have asked for an Access version.
Microsoft Office Labs has developed the Chart Advisor: a prototype add-in that provides an alternate approach for creating charts in Excel 2007 and uses an advanced rules engine to scan your data and, based on predefined rules, displays charts according to score.
Top scoring charts are generated charts, ranked, and displayed as thumbnails in a dialog for preview and tweaking by filtering data and how it is mapped.
I have asked for an Access version.
Thursday, June 19, 2008
Using Access with SQL Server: Panel Discussion from TechEd 2008
Check out this TechEd panel discussion: Are we there yet? Successfully navigating the bumpy road from Access to SQL Server.
The discussion is described as follows:
“Use SQL Server, not Access”, is advice commonly handed out when the Jet database engine outgrows its usefulness. However, that’s often easier said than done. Each database application is unique; some may have salvageable components, whereas others may need to be redesigned and rebuilt from scratch. In addition, there are substantial differences between the Jet and SQL Server database engines that can make a straight port unworkable in many situations. This panel discusses criteria for deciding whether to migrate data from Access to SQL Server, and for determining the optimal migration path once the decision is made. The panelists will share their real-world expertise to help you determine a successful strategy that best suits your business needs. With Mary Chipman, Armen Stein, Luke Chung, Paul Sheriff, and Stephen Forte."
Subscribe to:
Comments (Atom)