?
Solved

ms access run project

Posted on 2006-11-27
5
Medium Priority
?
311 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 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This article will show, step by step, how to integrate R code into a R Sweave document
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
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.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
Suggested Courses

770 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