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
wmv678Asked:
Who is Participating?
 
quihongCommented:
Are using making updates?

Why not "publish" your access database to a network file share?

SharePoint 2007 and Access integration is very limited. Even with SharePoint 2010, Access Services (requires enterprise cals) and Access 2010, you wouldn't get the VBA code part working (at least not online).
0
 
quihongCommented:
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.


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

http://office.microsoft.com/en-us/access/HA101314691033.aspx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
quihongCommented:
"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?
0
 
wmv678Author Commented:
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.
0
 
quihongCommented:
I meant, are users making updates?
0
 
wmv678Author Commented:
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?
0
 
quihongCommented:
I am not an expert of MS Access, but I would believe so, at least on some level. Also, I don't think your VBA issue has anything to do with SharePoint. You can easily validate this by placing the db file on a network file share versus SharePoint and see if you experience the same issue.
0
 
wmv678Author Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.