How to deploy an Access Application?

Posted on 2007-12-03
Last Modified: 2013-11-29
I am a new Access VBA developer. I am building an Access DB application. This app will have around 10 users. I want to know how to deploy the application on a server and user's matchines so they can interact with the Access DB at the same time. Shall I split the frontend forms from the backend tables?

Please help.  Thanks a lot.

Question by:kate_y
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 28

Expert Comment

ID: 20396215

OM Gang
LVL 28

Expert Comment

ID: 20396239
....a little more
Some of the tables can/should be left in the front-end.  Lookup tables are a good example of these, i.e. zip code or area code tables or similar where the data rarely changes.  Having these tables local to the front-end means the data does not need to traverse the network, i.e. more efficient.
OM Gang

Author Comment

ID: 20396626
omgang, thanks. But i need more details on how to do it. Also once i put the database on the server how does the app access the db?  I didn't use the connection string now because it is attached. So i am not how to do that. Could you provide me some real sample?
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

LVL 28

Expert Comment

ID: 20396693
Split the application into the front-end and back-end files.  Place the back-end db on the server into a shared directory that your users will have access to.  Install the front-end file onto a client (user's) machine.  Open the db to the database window.  Right mouse-click 'Tables' from the left nav pane under Objects.  Browse to the server share where the back-end db is located.  Select the back-end db and then choose 'Link'.  From the dialogue box that opens select the tables you want to link to.

Note:  if all your users will have the same mapped drive letter to the server share where the back-end db is located then you can perform the above by browsing to the appropriate drive letter.  If your users may have different drive letter mappings, or no mapped drive at all, then browse to the location of the back-end file by UNC path instead, i.e. make sure you don't have a drive letter mapped to the server share when your perform the above.

OM Gang

Author Comment

ID: 20397059
Thank you so much! Let me try it.

I assume i should use the Tools-Database Splitter. But I don't have the feature installed. I need to do that first I suppose unless there are other ways to split the files.
LVL 84

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 20398440
Yes, the Database Splitter should work well. Once you have the database split, place the BackEnd (i.e the Tables) on your server, and distribute a FrontEnd to your users ... make sure that the folder hosting your backend has create/destroy/read/write permissions for the correct user group (generally the Everyone group).

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question