Problem resolved thanks... FYI I changed the access table name from database
to something else and then changed the code in VBA from database to the new
name and hey presto.

I can only assume that the "database" name was causing a conflict as a
reserved name or something to that effect


"joel" wrote:


Is the version of Excel and Access the same?

Try creating a new workbook and put the macro into the workbook. There
is a hidden version number in the worksheet that is associated with the
version of excel that was used to create the sheet. This version number
doesn't get updated. So a worksheet that was created in excel 2003
still has 2003 when used with 2007. Access does get updated and is not
two way compatible in that Access 2003 can read a database that was
updated to 2007. An Access 2007 can't read a database in Access 2003.
One possibility is the version of Access and version of Excel are not
compatible.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=154397

Microsoft Office Help

.