You can have your SQL like this, it won't help you, but will give your fingers a rest.

Code:
search = "SELECT band_name, album_name, genre, single/album, released, company, serial FROM cd_serial_numbers"
A syntax error in FROM clause is usually just a spelling mistake in your SQL.

What does the Debug.Print Search display when run?