Solved

ms access run project

Posted on 2006-11-27
5
290 Views
Last Modified: 2008-02-26
I create project using Ms Access , I do not know how can user open this project , what will be my next step that user can open main form right away?
And how i can be sure at the end of the day that all entries are safe?!!!!!!!!
0
Comment
Question by:polkadot
[X]
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
  • 2
5 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 18027939
will the users be on your network, or on their own system?

AW
0
 

Author Comment

by:polkadot
ID: 18028210
user on my network
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 500 total points
ID: 18029367
ok.  

1) place the original MDB on the network drive, so that you can 'see' it.  

2) Open the MDB using Access, and the split it into a FrontEnd (FE) and BackEnd (BE) using Tools/DataBase Utilities/Database Spliiter.  Have the tool place the BE on the Network Drive.

The BE will have the 'real' data bales, and nothing else, while the FE will have the Forms, Queries, Modules, Reports, and LINKS to the BE tables.  The FE will still function EXACTLY as before.

3) from the FE MDB, using Tools/DataBAse Utilities/Make MDE File create an MDE version of your application- make sure that you then SAVE a copy of the MDB FE to a safe location, perhaps on a CD.

An MDE is a 'compiled' version of the MDB, with all of the source code for the forms, reports, modules converted into runtime 'executable' internbal code, and the actuall source code (VBA) removed, so that the MDE cannot be editted (which is why you need to keep a copy of the MDB which does have the source code)

Make sure that the MDE can successfully link to the BE.

You now have two choices:

1) copy the MDE to each user's desktop - this option makes updating the application a challenge, since each user has his/her OWN copy of the MDE, and you will need to be sure that when and if you update the MDE, t6hat each user does in fact get the newest version.

2) copy the MDE to the same network drive whewre the BE is located, and place a SHORTCUT to the MDE on each user's desktop - now updating the MDE is easy, since each user is copying the SAME file to their local memory to run the app.

The choice is up to you.

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
changeXy challenge 13 93
Problem to App 4 119
Problem to Alipay 10 71
convert Systemjs to Webpack 3 81
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
This article will show, step by step, how to integrate R code into a R Sweave document
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

733 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