Using SharePoint - you can publish = effectively host the Access d/b within
SharePoint - without having to do a lot of work.

* The database structure - is transformed into SharePoint lists + views, etc

* The data from the database - is stored in a SP - content database (i.e. on SQL
Server)

It effectively makes you old Access database - a SQL-server-based database
application.

Pitfall - not everything from your custom Access database design will convert
automatically to a SharePoint hosted Access web application

Here are a couple of useful links

MOSS 2007
office.microsoft.com/.../publish-a-database-to-a-sharepoint\
-site-HA010131469.aspx<http://www.linkedin.com/redirect?url=http%3A%2F%2Foffice%\
2Emicrosoft%2Ecom%2Fen-us%2Faccess-help%2Fpublish-a-database-to-a-sharepoint-sit\
e-HA010131469%2Easpx&urlhash=tc2Z&_t=tracking_disc>

SP 2010
office.microsoft.com/.../build-and-publish-web-databases-RZ\
101874502.aspx<http://www.linkedin.com/redirect?url=http%3A%2F%2Foffice%2Emicros\
oft%2Ecom%2Fen-us%2Faccess-help%2Fbuild-and-publish-web-databases-RZ101874502%2E\
aspx&urlhash=V0Al&_t=tracking_disc>

Thanks for the info and the links. I read about "moving" an access database to
the sharepoint site. Problem is that I need the database at home, with full
access functionality. It is very large anyway. However, I want to sync certain
bits of information to sharepoint pages.

I can create a linked table in access and create two update queries to update to
and from the sharepoint list. Is there another way such as this, or does anyone
know of a premade access code or addin that will do this?

For your case, the Access Database appears to be

* an external data source (to your SharePoint system)

* so use SharePoint's external data connector functionality

o MOSS - Business Data Catalog

o SP2010 - Business Connectivity Services

No, I am only using wss3............