Access Database SharePoint and Protection

[NapTime]

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.

 

[Maarkr]

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.

 

[David W. Fenton]

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?