Hi Yash, Thanks for your help.
I changed the dsn name to username-recordstore . When I asked for the dsn support asked me where the db was and I gave them this clickonwebsites.com/recordstore.mdb should the dns name be username-clickonwebsites.com/recordstore.mdb ?
Also, in the odbc settings...