Connect Sharepoint Designer to Access 2007 Database

Connecting SharePoint to a Access DB is really not supported or practical because of the "double hop" issue.

To get around this, place your access database locally on the SharePoint server.

thanks for your response, I really thought we could do that. that;s weird.
so how do I connect if it's locally (let's says under my c drive)?

I guess it depends on what you are trying to do.

My recommendation to put the access database locally on the SharePoint server was to overcome the double hop issue and was in context with setting up a (Dundas Charts) web part to pull data from the access db.

Well, what I am trying to do is create a webpart view of data stored in my Access database. I know I can create a linked list but I don't want to do that because my database is pretty big, and I only want 2-3 fields from a table .
So what I am trying to accomplish is to display those 2 fields on sharepoint by creating a new database connection.

I just tried to move the database to a local folder on the sharepoint server and I get the same error:
Data Source=D:\New Folder\David123.accdb;Persist Security Info=False;Provider=Microsoft.ACE.OLEDB.12.0

How big or how many rows is the table? Linking the Access Database to a SharePoint list might be the best solution. I have users doing this with 50K records. As long as you create nice filtered views, it shouldn't be too big of a problem.

If you want to use the Data View Web Part, you'll probably have to run SharePoint Designer locally on the SharePoint Server, since if you run it locally from your workstation you can't properly reference the access db. If you somehow manage to reference it correctly, when you deploy it, your users won't be able to reference it properly.

Looks like you need to add one additional step to have SharePoint "trust" access.

https://www.experts-exchange.com/questions/22035689/Connecting-Sharepoint-to-existing-Access-Database.html

I might have found a solution using SQL I am testing right now , I will let you know

I am actually testing with SQL Link Server, It seems to work but a little slow. I will post a final answer by the end of the week

Well, I understand that this question needs to be deleted or closed. I would say to close it and assign the point to quihong since he was right in my question , sharepoint can 't connect directly to an Access dabase.
I would like also to add the following that might help other resolve the same issue that I had.

I opened a case with Microsoft to find a solution to my problem and basically the best solution they had is to use a Sql Server to parse the data to sharepoint. I setup a linked server to an access database , then I created a blanK database in Sql and create a view to pull data from access. this way Shaerpoint can pull the view from the blank database.
they also gave me those following lins for different options , may someone will find those links helpful
Thanks
David

Office Access 2007 and SQL Server
http://technet.microsoft.com/en-us/library/cc178973.aspx

Create an Access project
http://office.microsoft.com/en-us/access/HA101679531033.aspx

Connect an Access project to a Microsoft SQL Server database (ADP)
http://office.microsoft.com/en-us/access/HP052745861033.aspx

Migration Case Studies - White Papers.
http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

How to create an SQL pass-through query in Access
http://support.microsoft.com/kb/303968

Move Access data to a SQL Server database by using the Upsizing Wizard
http://office.microsoft.com/en-us/access/HA102755371033.aspx

Thanks guihong, but you did actually answer the question, we can't connect sharepoint to Access database direclty ..too bad
performance using SQL is not the best , but for my purpose it works