Is there a way to display data from an ms Access database

Short and sweet, put your data in MS SQL. ;)

All joking aside, you can add a SQL Datasource webpart to the page and if you have a connection string already that connects to that Access database you can paste that into the Connection string property.

Next you can create a new document type, that is a container only and will not have custom fields (second screen after you enter the info class info). After it's created, go to Transformations for that new doc type and add your item transformation for the repeater with the fields from your Access database.

Then go to your page where the SQL Datasource webpart is and add a basic repeater and set the datasource = to the datasource name you entered. Select a transformation and you'll be set.

Thank you. I will give it a try. For now, I just imported into a custom table. I don't want to keep updating it so I will either import the database to sql or try your suggestion. Thanks again.