Rockville guy here with a SQL Server question

I am an IT guy in Rockville, Maryland and have a custom programming question that has to do with database management. I am trying to integrate a Microsoft Access database with a SQL Server 2008 64 bit database. The SQL Server system doesn’t seem to connect to Access. Do you have any ideas about what could be the problem?

Joe in Rockville, Maryland