ASP "switch to record" VB error

[FishThrower]

Hey all,

I am creating a ASP web site, and im running it on a SQL Server 2000 backend, and im using Dreamweaver MX 2004

When i add a "Move to Specific Record" server behavior to one of my hyperlinks I get the following error when I load up the web site



Microsoft VBScript compilation error '800a0411'

Name redefined

/index.asp, line 195

Dim MM_rs
----^



Line 195 is


Dim MM_rs




Is this because im using SQL Server? Is it a permission problem?, I have setup my SQL user account to have full access to the table and database

Thanks for the help

-Rhys

EDIT: im just updating my web server, theres loads of Windows updates
EDIT2: updated it but still got the problem :(

[buntine]

Delete that line. It means that the variable in question has already been defined, or (dim)ensioned.

Regards.