You’ve probably worked it out now but it does sound like Excel being a trial version is the issue.

Hi batigolnguyen, I went away and learnt about dbms, sql, my sql, adodb, odbc and my head is still spinning! Anyway I got connections working to: -…

Yup that’s right but I’m learning! I’ve learnt the access database has to be a project ‘.adp’ file, not a mdb. It seems to connect to the database bu…

Hi batigolnguyen, It works for me! well sort of, it falls over at tableadapter.fill dataset “staff” –the error message is… – Runtime error: dotNet …

Hi denisT, you seem to the man in the know. I’m ok at maxscript (I thought!) but want to get into databases, specifically ms access. I’ve trawled the …