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;"