• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

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
0
wmv678
Asked:
wmv678
  • 5
  • 4
2 Solutions
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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:
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:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now