If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Database SharePoint and Protection
Hello,
I would like to create a share point in which to share an Access 2003 database. I created database using 2007 but files are 2003 so that those who have not upgraded can use it too. I am familiar with Access but I have never shared with other users who will be at their own workstation. We are all in the same office. 1.) I would like to set the database up so that it is read only for all but me in order to reduce problems. Would you agree that this is necessary? If so, what is the best way to go about it? 2.) Is software in addition to Access required, if so, what? 3.) What problems should I look out for when sharing a database and what can I do to prevent them. 4.) Do you have any other advice you would like to share with me. |
#2
|
|||
|
|||
Access Database SharePoint and Protection
first, i think the db must be a 2007 .accdb to be fully compatible with
Sharepoint and sharing... people will be accessing a data page in sharepoint linked to your 2007 db after you set it up... I would set the site permissions in Sharepoint for Visitors for those who you do not want write access... definitely run a test db to check if the SP site is communicating with your A2007 db with multi-users... remember that the db must be built so it is NON-relational to work on SP. "NapTime" wrote: Hello, I would like to create a share point in which to share an Access 2003 database. I created database using 2007 but files are 2003 so that those who have not upgraded can use it too. I am familiar with Access but I have never shared with other users who will be at their own workstation. We are all in the same office. 1.) I would like to set the database up so that it is read only for all but me in order to reduce problems. Would you agree that this is necessary? If so, what is the best way to go about it? 2.) Is software in addition to Access required, if so, what? 3.) What problems should I look out for when sharing a database and what can I do to prevent them. 4.) Do you have any other advice you would like to share with me. |
#3
|
|||
|
|||
Access Database SharePoint and Protection
=?Utf-8?B?TWFhcmty?= wrote in
: remember that the db must be built so it is NON-relational to work on SP. Someone in one of the other newsgroups posted a problem today that they were getting duplicate records in a database uploaded to a Sharepoint server. I already knew that Sharepoint does not support RI, but does Sharepoint also ignore your unique indexes? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|