Yes, this is certainly possible. However you need to play by the
rules, and they say that tables go in a back-end database on the
server, and clients have all other objects, and linked tables.
You can research your error message at microsoft.com, for example
http://support.microsoft.com/kb/248967
-Tom.