I am trying to create a database connection with Sharepoint Designer 2007 to an access 2007 database. I can't figure the right syntax. I already found the website that shows the connection string but none are working. http://www.connectionstrings.com/access-2007
My Database resides on a shared folder that my server and my computer have access:
The test database "david123.accdb" has only one table called table1 and the database has no security setup ( I basically created a new database , created a table and saved it has data.accdb)
When I go to sharepoint Designer I click :
-Connect to a Database ...
-Use custom connection String > edit
-then I tried OLEDB and ODBC
-typed the following in Connection string:
;Persist Security Info=False;
but I get an error that says:
"Server Error: an error occured while retrieving the list databases from........"
Can someone explain me or show me the right method?