Solved

ms access run project

Posted on 2006-11-27
5
251 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
Comment Utility
will the users be on your network, or on their own system?

AW
0
 

Author Comment

by:polkadot
Comment Utility
user on my network
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now