Friday 14 September 2012

Sharing a MS Access database

So I've got an inventory database but have about 8 people who need to use it. Thought this wouldn't be a problem but turns out this stuff is more complex then it appears. When more then one person opens it (it's on a networked drive) a message keeps popping up about permissions. I did a quick search and found Microsofts help page here and there are a few options:

  • Put it on a network folder
    • done this which is where the problem is
  • Split the database to front end and back end
  • Use SharePoint
  • Use a Database Server
The ideal one would be a database server. But unfortunately I lack the knowledge to create the queries and forms for the web.

Next best is either SharePoint or splitting the database. Here's an article on SharePoint but I'm unsure whether we have SharePoint enabled somewhere and also how to do it.

My favourite option is Splitting the Database. Basically have the tables in on database (the backend) and the forms, queries and reports in another (front end). Heres a quick forum post on how to do it.

No comments:

Post a Comment