I found it half in a sams book (TY database programming with vb6 and half in a forum(
http://www.utteraccess.com/forums/ac...ess562187.html): this works! (yipeeeee!!))
localconnection.Execute _
"CREATE TABLE imported(" & _
"trackid INT IDENTITY CONSTRAINT PKimported PRIMARY KEY," & _
"Artist VARCHAR(75)," & _
"title VARCHAR(75)," & _
"BPM INTEGER," & _
"Genre VARCHAR(50)," & _
"Track_Year INTEGER," & _
"Version VARCHAR(75)," & _
"Comment VARCHAR(75)," & _
"Album VARCHAR(75)," & _
"Karaoke VARCHAR(75))"
But hell did I get trouble for my sins. Books were in my loft. Halfway through recovering them the snowstorm and wind took the power out and getting my fat butt down in the dark was fun... suffering for fun....