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
Solved

ms access run project

Posted on 2006-11-27
5
284 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
  • 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Navigation is an important part of web design from a usability perspective. But it is often a pain when it comes to a developer’s perspective. By navigation, it often means menuing. This is less theory and more practical of how to get a specific gro…
If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

856 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