The first thing to check when code doesn't work in A2007 is the Trust
settings. Click the Office button in the upper left, go to Access Options,
then
to the Trust Center and make sure that the file where your db is located
is in the list of trusted locations. If it's not you can add it from there.