Access databases can only be used with the same version of Access that
there were created in . Access is not forward nor backwards compatible
with different versions. You are using a shell command to open the
database which will use the version of Access that is installed on your
PC and if it doesn't match the version of the Database on the next work
it will not work.

The better method is to connect with the database using the ADO method
which will work across different version of Access. there are plenty of
references on the network on how to do this. He is one article

'VB Tutorials - SQL for Beginners' (http://tinyurl.com/6hulo)


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

Microsoft Office Help