I have recently completed a database (Access 2000) for our factory, which the users will update daily. I am at a different location and need to manage, view and also make changes and updates. Iam probably doing this wrong, but at this point, I update the database and email the whole thing to them, they update and send it back everyday. I have assigned a password for the users and me as admin, and they seem to work. When I open the database, it requires me to enter my password, but the users open the database and it opens without a password and has them logged in as admin.
1. How do I change this?
2. Is there a way to send just the data and not the whole database every time?
What are my options for doing this?
Thanks
8 2143 Rabbit 12,516
Recognized Expert Moderator MVP
I have recently completed a database (Access 2000) for our factory, which the users will update daily. I am at a different location and need to manage, view and also make changes and updates. Iam probably doing this wrong, but at this point, I update the database and email the whole thing to them, they update and send it back everyday. I have assigned a password for the users and me as admin, and they seem to work. When I open the database, it requires me to enter my password, but the users open the database and it opens without a password and has them logged in as admin.
1. How do I change this?
2. Is there a way to send just the data and not the whole database every time?
What are my options for doing this?
Thanks
1) Right now, you are in a workgroup with accounts and passwords. This is a workgroup seperate from your computer login or your network login. It's a security measure within Access itself. The problem is that it does not travel with the database. This means that you must join the workgroup on each computer running Access. Workgroup settings are under Tools > Security.
Short of doing this, if you know that the users aren't adept Access users. You can go to Tools > Startup and from there you can turn off many of menus and commands. This means that when you startup the database file, they won't be able to do much except what you let them. However, there is a bypass key. If you hold shift while opening the file, you bypass the startup settings and have full access to everything.
Either way, it's not very secure.
If you and the users can both upgrade to 2003, you can instead create an mde file from the database which effectively turns off any tampering they can do to the database design and code.
2) If by sending data you mean the data that the users enter, then yes. Either you can have the users export the tables into another database file and send you that. This requires that they have access to the tables, something you may not want. Or you can implement it in the code to export the tables into another database file and have them send it to you.
Thanks Rabbit, That helps.
1.So if I have the users join the workgroup, and I send back an updated version of the database, would the workgroup apply to the updated version, or would they need to join the workgroup everytime, for the password to be required?
2. If I add code to export the tables for data transfer, will it import very easily to update the database the other location? I will need to send it back to the users and it would need to be very simple for them to update things on their end.
Do I have other options for the users and me to both be able to update and use this database from different locations?
I appreciate the help...thanks
Rabbit 12,516
Recognized Expert Moderator MVP
Thanks Rabbit, That helps.
1.So if I have the users join the workgroup, and I send back an updated version of the database, would the workgroup apply to the updated version, or would they need to join the workgroup everytime, for the password to be required?
2. If I add code to export the tables for data transfer, will it import very easily to update the database the other location? I will need to send it back to the users and it would need to be very simple for them to update things on their end.
Do I have other options for the users and me to both be able to update and use this database from different locations?
I appreciate the help...thanks
1) Once they join the workgroup, it applies everytime they open Access; they won't have to rejoin.
2) I have a question about this. When they send you the data, you add to or edit the data and then send it back to them? Or are you talking about new forms, tables, coding and such?
3) Not that I know of but I don't know much about that area. Maybe someone else can give you an answer.
The users will update data daily and send to me. I need to review data daily and also update data with new orders etc. I will want to occasionally make database changes and additions we go along - (new forms, etc) to expand and modify the database and structure.
Rabbit 12,516
Recognized Expert Moderator MVP
The users will update data daily and send to me. I need to review data daily and also update data with new orders etc. I will want to occasionally make database changes and additions we go along - (new forms, etc) to expand and modify the database and structure.
Is it a very big database? If not and if you're going to be making changes so often, I would suggest leaving it as one file. If not, it may be better to seperate the data tables into another file.
Before you say it's very big, have you compacted your database? I suggest turning on the setting that compacts your database when it closes.
It's under Tools > Options > General Tab
NeoPa 32,577
Recognized Expert Moderator MVP
Remote management of a database is made easier if you separate the code (design) from the data. All tables in your database should link to tables in your data database. New versions of the design are then much smaller.
If you have network access to the same area they have network access to then you won't need to move the data database at all. You just both link to the same location.
With a multi-user database compacting on close is not such a great idea. You'd need to schedule this on a regular basis (probably manually).
Thanks, that helps.
1. Do I just use database splitter to separate the data from the code, or is it more complicated?
2. After I separate them, the users add to the database, then email the tables back to me, and I import them somehow into my version of the database?
Sorry if Im confused about something simple, thanks for your help.
Rabbit 12,516
Recognized Expert Moderator MVP
You'd just import the tables into a different database file and then link to them from your main database.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Nasir |
last post by:
Hello all,
I am currently suffering from a high loss of my database.the problem
is like this.
I have a DATABASE server running MySQLD 3.23.58.Users vist and sign up
their interest in my website.Now the problem is arising that when a
user signs up first , they get emails of confirmation from my
server.In addition to these emails , the customer also gets some
|
by: MLH |
last post by:
I was running the following code while logged
in as a user belonging only to the Users group.
Set usrNew = .CreateUser(Me!UserID) 'The user ID is in a
control on the form
usrNew.PID = "AAA123456789"
usrNew.Password = "password"
.Users.Append usrNew
|
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The objective
in utilizing this new deployment method is to reduce the maintenance
overhead as well as making it easier for my users to setup and run the
application initially. I have VS 2002, Windows XP, Access XP(2000
format).
He is my problem....
|
by: AnhTai |
last post by:
Hi all,
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install
from blastwave). This is my first time with MySQL so I don't have any
exp with it.
I have some troubles as:
- I set password for root account via this command:
# mysql -h atlantis -u root mysql
|
by: mrouleau |
last post by:
I am sorry if this is the wrong group to ask, if so please point me in
the correct direction.
My problem is I have an MDB file with user-level security on it
(mdw). When i move it over to a system that has Access 2007 and try
to open it, I get a user name and password prompt. The admin username
and password from the other system doesn't work.
Is there anything special I need to do? If I could I would actually
love to remove this...
| |
by: bmoore |
last post by:
I am just beginning to implement user-level security in Access 2003. I created a user account and it is assigned to the users group. I would like to assign a password for this account (or for the users group), but am not given the option to do so. (I am trying under Tools > Security > User and Group Accounts > Change Logon Password.) Only the admin userid is available. Is it because there is currently no password assigned for admin that I...
|
by: Don Calloway |
last post by:
I'm attempting to implement User-level security on an Access 2003
database in Access 2000 format and have hit a brick wall. I created a
Workgroup Information File with myself as admin and added users without
any privileges as suggested by Access. Next, I created a Group with only
Read-Only access and added one of the users to that group. I then
assigned a temporary password to each user and finally set a password for
the admin group so...
|
by: =?Utf-8?B?QnJpYW4gTmljaG9sc29u?= |
last post by:
Hello,
I'm trying to create an admin page that can run miscellaneous scripts for
our IT department. Currently, I'm trying to create a script that can map a
network drive for a user (e.g. a form where I can input \\path\folder, drive
letter, and domain\user). Is this possible? If so, can someone point me in
the right direction?
Thank you,
Brian Nicholson
|
by: Big Charles |
last post by:
Hello,
Programming in VS2003-ASP.NET 1.1, I have this problem: Using
DirectoryEntry and without any admin user, how can I check if a domain
account, that try to login, has expired?
Scenario: User load web application and login using account and
password of the Active Directory.
But user account of ActiveDirectory has expired (or password could be
expired). For security reason, we don't want to use any account with
admin privilegies for...
|
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:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: 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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |