Hi Guys,
I just complicated my database and I wanted to know what is the best practice for staff to access the APP. I have split my DB in 2. The back end stores the data and the front end is the App. The database will be placed on a network drive. In my DB I have 4 different forms, there are 4 different staff using the DB. Each have different task to do which is why I had to create different forms. The best way I thought for distributing the app is copy the App to the staff desktop and then go into Tools – Startup. I was going to select the form they need and of course uncheck certain boxes to make sure they can’t access anything else.
I can’t think of any other way to distribute the App. If anyone has any other suggestions please let me know. Thank you for all input.
4  1430   MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi Guys,
I just complicated my database and I wanted to know what is the best practice for staff to access the APP. I have split my DB in 2. The back end stores the data and the front end is the App. The database will be placed on a network drive. In my DB I have 4 different forms, there are 4 different staff using the DB. Each have different task to do which is why I had to create different forms. The best way I thought for distributing the app is copy the App to the staff desktop and then go into Tools – Startup. I was going to select the form they need and of course uncheck certain boxes to make sure they can’t access anything else.
I can’t think of any other way to distribute the App. If anyone has any other suggestions please let me know. Thank you for all input.
Creating four different frontends is a viable option here particularly if you haven't imposed access levels to the users. Have you a user login which could determine the appropriate form for each user? You should also create a mde of the frontend to stop the user from altering the structure but backup the mdb file first.
Mary
Hi Mary,
Thank you for your input. I did not think of setting up user login, which would probably be the easiest. Thank you for the advice.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi Mary,
Thank you for your input. I did not think of setting up user login, which would probably be the easiest. Thank you for the advice.
No problem.
Glad I could help.
Mary
NeoPa 32,569
Recognized Expert Moderator MVP
Personally I'd store the front end (MDE if you like) on the network too, but create a form which starts automatically, which is programmed to switch to one of the other forms depending on the Network Logon Name of the operator. These could even be stored in a table for later flexibility. This would have the benefit of a single release if changes are required rather than trying to maintain four separate versions.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Colin Chudyk |
last post by:
Hi,
Here is my situation. Can anyone provide insight?
I have developed a database in Access 2002. I am planning to distribute it
as a split MDE (front) / MDB (back) to be used by the Access runtime and
also full-version. Some of the client workstations will have Access 2002
installed. Most of them will have the runtime installed.
However, I can't find the Office 2002 Developer Edition anywhere! Nobody has
|
by: Colin Chudyk |
last post by:
Hi,
Here is my situation. Can anyone provide insight?
I have developed a database in Access 2002. I am planning to distribute it
as a split MDE (front) / MDB (back) to be used by the Access runtime and
also full-version. Some of the client workstations will have Access 2002
installed. Most of them will have the runtime installed.
However, I can't find the Office 2002 Developer Edition anywhere! Nobody has
|
by: ship |
last post by:
Hi
We need some advice: We are thinking of upgrading our Access database
from Access 2000 to Access 2004.
How stable is MS Office 2003? (particularly Access 2003).
We are just a small company and this is a big decision for us(!) It's
not just the money it's committing to an new version of Access!
|
by: Ian Davies |
last post by:
Is the runtime version of Access for distribution, that is available with
the developer extensions a fully functional version of Access apart from the
ability to create, edit and code a database? I am particularly interested to
know if the Linked Table Manager will function, as I make use of this in one
of my applications as a way the user can reconnnect to the backend if they
should choose to move it to a different location after...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
| | |
by: wazdakka |
last post by:
I'm confused about what is necessary to distribute an Access 2003
application to people that don't have MS Access (or don't have the
right version) installed on their PCs. I have done some research on
the MS website, as well as on this newsgroup, and have never found a
clear explanation of what is required.
I have written an application that I would like to sell, but if I can
only sell to those with access to Access (sorry, couldn't...
|
by: Prakash |
last post by:
I am developing an HR package under Access 2003 for a client but do not
want to give him the source code.
I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this & what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)
I currently own a copy of MS Office Professional Edition 2003.
|
by: Paul H |
last post by:
Most of my projects are developed in Access 2003. I have not even installed
Office 2007 yet!
I need to buy VSTO to get the run-time licence for Access 2003. No doubt I
will soon need a run-time licence for Access 2007. Is there a version of
VSTO that has the Access run-time licence for both version of Access? Or
will I need to buy VSTO 2003 now and then VSTO 2007 at a later date?
Thanks,
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd
like to know is the stability, speed & ease of use of both the
products.
I believe Access 2007 has a new file format too and that it may be
slower.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
