Link to home
Start Free TrialLog in
Avatar of wmv678
wmv678

asked on

Published Access Database to Sharepoint, now what?

Hi All,

I've recently published an Access 2007 database to a Sharepoint page.  Previously, I was uploading, but when you downloaded and opened, none of the VBA worked.  I think publishing should solve this.  The problem is, I published, and now I'm now sure how to use the published copy on the sharepoint.  Can anyone tell me how multiple users can use my DB after I published it?  Do they open it, save it?  Just not sure of the next step.. how a published database is actually used.

Thanks
Avatar of quihong
quihong
Flag of United States of America image

SharePoint 2007 doesn't support "publishing" MS Access Databases. MS Access DBs are by default not even allowed to be uploaded (the file extension is blocked).

However you managed to "published" you MS Access DB, it will not allow multiple users to use it properly. Each user will just download a local copy of the db and updates won't be synced. If VBA isn't working, its probably a client side security(macro) configuration setting.

With SharePoint 2010 and Access 2010, you can leverage Access Services which allows you to publish an access db. The forms will be converted to aspx pages. VBA code will not work though, you will need to translate the logic to supported macro calls.


Avatar of wmv678
wmv678

ASKER

quihong, are you sure?  I referred to this link:

http://office.microsoft.com/en-us/access/HA101314691033.aspx
"When you publish a Microsoft Office Access 2007 database to a Microsoft Windows SharePoint Services 3.0 site, other members of your organization can work with the database."

I think the key phrase is "work with the database". I know you can sync an access db table to a SharePoint list (access db file kept on network file share), but I wouldn't call that publishing.

You are not going to get multiple concurrent users access/updating, if that is your expectation.

What are your expectation and/or requirement?
Avatar of wmv678

ASKER

I was afraid that might be the case... that it merely linked the tables to the sharepoint.  This isn't very helpful as I have many linked and referenced tables, and adding entries to a table manually is difficult.

I want multiple users to be able to access my database and use all of the forms I've created and for the VBA coding to work as well.  Currently, after uploading and downloading, the VBA won't work.

I'm ok with only one user accessing at a time, I'm just looking for full funtionality when they do.
ASKER CERTIFIED SOLUTION
Avatar of quihong
quihong
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I meant, are users making updates?
Avatar of wmv678

ASKER

You're suggesting a shared directory on the network to share the database?  Is there anyway to prevent concurrent updates doing this?

Also, where is the VBA lost... when uploading, or downloading to sharepoint?  If I copy this to another directory, will the VBA still work?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wmv678

ASKER

The key is to reopen the database, delete all of the tables, and import all of the tables published on the sharepoint.  Anyone can do this, and since all of the dbs are linked to the same set of sharepoint tables, everyone has the same, updated information.