In every module you need to include an error handler. At the top put this:
on error goto Handler
and then near the bottom put this:
exit sub
Handler:
msgbox err.description
resume next
That's a bare bones error handler. You can obviously do more with it to handle specific errors - the easiest way it set up a test like this:
Handler:
select case err.number
case 1
'do this
case 2
'do that
case else
end select
resume next
Linked tables are ok. If you want to use stored procs and views you can by adding a reference to the IDE to Microsoft ADO 2.6. Access wont help you, you have to open your own connections and do it all, no automatic binding either.
Maybe that will help some. Continue to post questions if you have problems. You might also want to look for an Access centric site too.
Andy
http://qa.sqlservercentral.com/columnists/awarren/