Uploading Access 2003 into SharePoint v2.0 ?

[dponce]

Can anyone share so insights as to anyone having successfully been able to upload an access database into SharePoint where the end users can alter, edit, deleted and save the information on the back end so that everyone else could see the changes made by others? The current SharePoint v2.0 allows me to upload a document and when I do it this way it will successfully take the whole database and even open it up in access but the problem we are having is the end users can make changes but the information just won't stay saved.

Please help with any suggestions. I have search Google extensively and there are only examples going from MS Access 2007 to SharePoint v3.0

[jaxjagfan]

Can anyone share so insights as to anyone having successfully been able to upload an access database into SharePoint where the end users can alter, edit, deleted and save the information on the back end so that everyone else could see the changes made by others? The current SharePoint v2.0 allows me to upload a document and when I do it this way it will successfully take the whole database and even open it up in access but the problem we are having is the end users can make changes but the information just won't stay saved.

Please help with any suggestions. I have search Google extensively and there are only examples going from MS Access 2007 to SharePoint v3.0

Sharepoint is great for "Document" sharing and versioning. I don't know that it would be the ideal place for my database. A lot of the SharePoint can interact with SQL Server - if that is the case then you would actually be storing your database in a database.

Make sure all of the users have read/write access to the SharePoint folder and that all linked objects contain the full UNC (I.E. \\myserver\myfolder\mydb.mdb) If you have linked ODBC tables, all users and/or groups have to have access to the ODBC source (SQL Server, Oracle, etc) as well. The security for the ODBC is seperate from Sharepoint.

[dponce]

Thx again for you help jaxjagfan, I can see you are indeed a valuable asset to this forum and I am sure myself and others appreciate your time and efforts invested.

I was ensured that every end user had read/write access to the SharePoint folder. This can be seen by each end user only. They tell me that they can read, write, edit, delete info on the database but when they close it and reopen it the information that was just entered or edited is no longer there. This is all new to me;

UNC (I.E. \\myserver\myfolder\mydb.mdb) If you have linked ODBC tables, all users and/or groups have to have access to the ODBC source (SQL Server, Oracle, etc) as well. The security for the ODBC is seperate from Sharepoint.

Would you be willing to help me get thru this?

[jaxjagfan]

Thx again for you help jaxjagfan, I can see you are indeed a valuable asset to this forum and I am sure myself and others appreciate your time and efforts invested.

I was ensured that every end user had read/write access to the SharePoint folder. This can be seen by each end user only. They tell me that they can read, write, edit, delete info on the database but when they close it and reopen it the information that was just entered or edited is no longer there. This is all new to me;



Would you be willing to help me get thru this?

Is document versioning turned on? As changes are made to the database then SharePoint will save a new version of the database while maintaining the original with its original data.

I'm by no means a SharePoint guru. Just know enough to be dangerous :D
I'd recommend a SharePoint or Microsoft forum for a more definitive answer.

[dponce]

Is document versioning turned on? As changes are made to the database then SharePoint will save a new version of the database while maintaining the original with its original data.

I'm by no means a SharePoint guru. Just know enough to be dangerous :D
I'd recommend a SharePoint or Microsoft forum for a more definitive answer.

I wouldn't even know where to check is versioning is turned on. Do you have any recommendations for a SharePoint forum?