473,588 Members | 2,478 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Ms access data base security

16 New Member
Hi, kindly guide me on how to solve this security problem. i set a passord to the data base and seems to work well. but since several people use the data base and know the passord, i think its risky. infact because i cant hide tables or data base forms using these option.

2. i decided to use user level security wizard and it looked like the best solution untill i copied the data base to another machine and opened it. the data base opened without asking for passord and i could access all tables and forms.too risky! kindly can someone help me with best solution for this?

my second question goes to whoever can assist me with replicating the data base on several machines in different departments. its because i dont want to centralize it but keep information synchronized across.
i,m using ms access 2003.regards.
Jun 23 '10 #1
1 1712
FishVal
2,653 Recognized Expert Specialist
User level security is stored in a separate mdw file, not in mdb. You need to copy both files to a different PC.
Jun 23 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1315
by: loyalone | last post by:
q: how can I format data that saved and updated as short time into access database from vb I tried but always saved time as blank or datetime
2
5051
by: DarekB. | last post by:
Elo, or other "non server" data base. 4ex. dBase Do U know how to do it??? I've MsVS.NET, i'm tring create OLE Db connection, and recive info that: Invalid property value: ..Net does not support ODBC driver
2
1256
by: ruca | last post by:
Hi, I'm currently facing problems in my Web Application when I try to use a Microsoft Database. With SQL and OrACLE works fine. I only can access with a user at time. No more than one user. What can I do to start working both webapplication and microsoft access together. What do I have to do? --
2
1425
by: farhad | last post by:
Hi Could you help me , how can I get backup automaticly by timming (like as each 15 min) from access database if my access have password ?
4
2131
by: Joe101 | last post by:
Question: How to put access data base onto a web page?
8
3665
by: slb813 | last post by:
Hello, I am having a problem that I can't seem to work out. I am running Apache 2.2 on a Windows XP platform, using PHP5. I am attempting to insert a row into a MS Access data base with a PHP script. I have a good connection into the data base, because select's work well. The error that I am getting is: Warning: odbc_exec(): SQL error: Too few parameters. Expected 5., SQL state 07001 in SQLExecDirect in C:\xampp\htdocs\test.php on...
3
5755
by: ashokkuncha | last post by:
hi all, i am new bee and hope some one help me out. in my web application i am using access as data base, one table of the dabase has candidates details as records ( emp no, name , skill set ect ). now i need to add new column ' Resume' that will have resumes(word files) of the candidates as column values. i should be able to upload/retrieve resumes programmatically. OS is windows 2003, prgramming language is java with tomcat as web...
3
1287
dnb
by: dnb | last post by:
Hi Friends, I make project in vb6.0. i need some data save in diffrent language in access data base.like 1st field in english and 2nd field in hindi etc.......... How can i do this? Plz give me solution of this query..... thanx in advance....................
24
2938
by: joeldault | last post by:
Question For Microsoft Access Data Base -------------------------------------------------------------------------------- I am Trying to create a single formula that would do the following: If A1 is less then or equal to 499, deliver B1*1, if A1 is equal to or less than 999 but more than and including 500, deliver B1*2, If A1 is equal to or less than 1499 but more than and including 1000, deliver B1*3, AND SO ON..... I have read the...
0
7929
marktang
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...
0
7860
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,...
0
8222
Oralloy
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...
0
8223
tracyyun
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...
0
6634
agi2029
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...
0
3847
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...
0
3883
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2371
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
1
1458
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.