Access 2003 interface with Sharepoint

[Walt]

Hi,

I have a database that I might need to allow others to use via the internet.
We are using Sharepoint.

To interface my db with SharePoint will I have to put the db on the web
server?

Are there known problems with interfacing Access 03 with Sharepoint?

Thanks for the help.

 

[Arvin Meyer MVP]

Hi,

I have a database that I might need to allow others to use via the
internet.
We are using Sharepoint.

To interface my db with SharePoint will I have to put the db on the web
server?

You'll have to put a copy of your DB into SharePoint lists. Unfortunately,
there is no referential integrity in SharePoint, so you really can't do much
more than view some records and perhaps update a list. You can sync that
update, however with the Access table providing the data can pass all the
validation rules.

Are there known problems with interfacing Access 03 with Sharepoint?

Other than the aforementioned, the only problem is speed. Syncing data
between the database and SharePoint is painfully slow if you have more than
a few dozen records. My last attempt at a sync took 12.5 minutes for about
2,000 records.

I'd consider either a small asp/asp.net application or using a Terminal
Server if you have a full database that needs sharing. SharePoint is just
fine for sharing something like a contact list.

 

[Arvin Meyer MVP]

Hi,

I have a database that I might need to allow others to use via the
internet.
We are using Sharepoint.

To interface my db with SharePoint will I have to put the db on the web
server?

You'll have to put a copy of your DB into SharePoint lists. Unfortunately,
there is no referential integrity in SharePoint, so you really can't do much
more than view some records and perhaps update a list. You can sync that
update, however with the Access table providing the data can pass all the
validation rules.

Are there known problems with interfacing Access 03 with Sharepoint?

Other than the aforementioned, the only problem is speed. Syncing data
between the database and SharePoint is painfully slow if you have more than
a few dozen records. My last attempt at a sync took 12.5 minutes for about
2,000 records.

I'd consider either a small asp/asp.net application or using a Terminal
Server if you have a full database that needs sharing. SharePoint is just
fine for sharing something like a contact list.