A client of mine abandoned a project about three months after going live which he now wants to resurrect. I copied the whole project back to my computer and something very simple that worked before is now not working. I'm getting the good old "Too few parameters. Expected 1" error. The line in question is:<BR>Set SpecialsRset = Connect.Execute("SELECT * FROM ProductDetail Where Specials = -1") I looked through the FAQ's, searched the forums and can't find the reason. The one thing that is different is that I'm using Access 2000 as opposed to Access97 as before. So, as simple as this is, I am turning here for a solution. Help would be appreciated.