Article ID: 282390 - View products that this article applies to.
This article was previously published under Q282390
This article has been archived. It is offered "as is" and will no longer be updated.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986Moderate: Requires basic macro, coding, and interoperability skills.
(https://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
This article applies only to a Microsoft Access database (.mdb).
When you attempt to upsize your database, you may receive an error message similar to the following:
Server Error 134: The variable name '@Forms......' has already been declared. Variable names must be unique within a query batch or stored procedure.
Server Error 170: Line 7: Incorrect syntax near ')'.
This behavior can occur if queries in your database contain parameters that match through the first 30 characters. For example, the following query produces the error message:
Note that this query contains two parameters that match each other through the first 30 characters:
PARAMETERS [123456789012345678901234567890start] DateTime, [123456789012345678901234567890end] DateTime; SELECT item, date FROM Table1 WHERE date Between [123456789012345678901234567890start] And [123456789012345678901234567890end];
To resolve this issue, change the parameter names in such a way that they differ within the first 30 characters. For example, if your query contains the following two parameters
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
Steps to Reproduce the Problem
For more information about upsizing your database, click Microsoft Access Help on the Help menu, type upsize in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.