Access 2003 interface with Sharepoint

  • Thread starter Thread starter Walt
  • Start date Start date
W

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.
 
Walt said:
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?
Click to expand...

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?
Click to expand...

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.
 
Walt said:
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?
Click to expand...

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?
Click to expand...

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.
 
Back
Top