I will be developing a program using visual studio 2008 with ms access 2007 as my database. What I only use is this type of connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;" but i was asked if it is possible to put the database in sharepoint and I haven't even tried it before. The case is like this, the program that i will do would be installed on some computer units of different branches of the company then the database should be accessible through sharepoint so that every users can access the most updated database.

Can somebody help me with this? What is the right connection string in vb.net for ms access 2007 database? Also, wouldn't it change the following codes after the connection string..i mean, the only thing that will change is this: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;"

Recommended Answers

All 2 Replies

This may help.

thanks but i've already seen that yesterday but the path/data source is in drive C:\..what if i used this: Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

The keyword "Database" specifies the SharePoint URL

The keyword "List" specifies the GUID value for the desired SharePoint list (list=table)

Querying without specifying any table name. Ie use "SELECT * FROM table" or "SELECT * FROM list" (same result from booth).

Sorry I can't test it now in visual studio or in sharepoint because I am still waiting for their IT specialist to install it in my unit but may i ask if you even know what will I place for theLIST..would it be the name of the database?or can I not include it anymore?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.