473,545 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 Security On a Network Drive

17 New Member
Hello there,

I have recently followed the steps to creating my secure database as outlined by the following link: http://www.databasedev .co.uk/access_security .html

I have copied the Workgroup information file to the network drive where the database resides and set up the security using the security wizard. Everything works out fine on my workstation. The problem I am having is when someone else from another workstation tries to log in. They have no problem joining the Workgroup. When they go to open the database the login prompt box does pop-up, which to me is a sign that they have infact joined the workgroup successfully, but when we enter any one of the user names and passwords I have created, it doesn't seem to recognize them. It says "Not a valid account name or password".

Does anybody have any idea what the problem is here?

Thank you for your help and input.
Jun 14 '07 #1
4 1558
cwalker
1 New Member
I think they have to JOIN the workgroup from their workstation.

If you have a lot of people using the DB, make a shortcut with group file for them.

"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "yourdatabase.m db" /wrkgrp "yourgroupfile. mdw "

I did this, and works well.

BTW. I am new here. And like here.
Jun 14 '07 #2
CanuckChuck
17 New Member
O.K so I fixed the problem. I am not 100% sure how I did it, but it was either because I had not removed the default admin account from the admins group, or because I went in and set it up again from the actual network drive.

Now I have the problem that others seem to have where if I change back to my original Workgroup I can access the database without any security enabled?

It seems there is always something with this security setup!?!?

Any Comments?
Jun 14 '07 #3
CanuckChuck
17 New Member
I think they have to JOIN the workgroup from their workstation.

If you have a lot of people using the DB, make a shortcu with group file for them.

"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "yourdatabas.md b" /wrkgrp "yourgroupfile. mdw "

I did this, and works well.

BTW. I am new here. And like here.
Thank you for the reply, I was just posting as you were.....and I agree I like as well. I may try the shortcut also, as you can see in my last reply I am having another issue and maybe that will resolve it
Jun 14 '07 #4
MMcCarthy
14,534 Recognized Expert Moderator MVP
Have a look at this site which provides very comprehensive information on Access Security.

Access Security
Jun 14 '07 #5

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

Similar topics

6
9681
by: moonriver | last post by:
I write a program accessing files in network drive o:. It is doable as a standalone application. However, if it is running under windows service, the following exception will appear: 13/07/2004 10:24:48 AM run() error: System.IO.IOException: The specified network password is not correct. at System.IO.__Error.WinIOError(Int32 errorCode,...
1
2341
by: Namratha Shah \(Nasha\) | last post by:
Hey Guys, Before we start with our sample app we need to view the security configuration files on the machine. You will find them under <drive>\WInNT\Microsoft.NET\FrameWork\<version>\Config Enterprise Level Security configuration file is :- enterprise.config Machine Level Security configuration file is :- security.config
16
7815
by: sinna | last post by:
Hi! I'm new in JavaScript, and tried out some examples. If found an XML example at MSDN MSXML 4.0 DOM which is: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/xml_mth_hn_2uck.asp var xmlDoc = new ActiveXObject("Msxml2.DOMDocument.4.0"); xmlDoc.async = false; xmlDoc.resolveExternals = false;
1
4357
by: intl04 | last post by:
Are there any problems with multiple user access to the same Access database on a shared network drive? I have 'shared' chosen for 'default open mode'. As for the record locking properties, I selected 'edited record' for default record locking; also, 'Open databases using record-level locking' is checked. We seemed to experience...
2
5670
by: Peter O'Reilly | last post by:
I am experiencing difficulty access a mapped network drive in an ASP.NET application. While using the .Net framework v 1.1 implementation of System.IO.Directory.Exists(), it fails to recognize a mapped network drive. This is true if the path specified uses a mapped drive letter or is expressed as a UNC address. I have also tried the...
8
9707
by: Sarah | last post by:
I need to access some data on a server. I can access it directly using UNC (i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network drive resource (S:\Path\FileName). Here is my problem: my vb.net program has problems with UNC. If the UNC server is restarted or goes off-line, my VB.net program crashes. The code for UNC...
5
13257
by: Mitchell S. Honnert | last post by:
Is there a way, given the full path of a folder on a network, that one can programatically tell if you have Read access to that folder? I have an application where the user is able to select a number of search folders using the standard dialog control. There shouldn't be an issue with the search folder being on a local drive or a network...
17
4387
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server...
8
13221
by: mark_aok | last post by:
Hi all, I have a split database. Both the forms, and the tables are stored on a shared network drive (this is Access 2003). The users use the forms, and the tables on the network drive, there are no local copies. When connection to this drive is lost, Access CRASHES. It does it every single time. Does anyone know if there is a way...
25
2971
by: p byers | last post by:
Good Morning Folks I have a LAN Among the several connections to it are the following four devices: A MAXSTOR network Storage Device A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4) A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) A PC running Microsoft Windows XP Professional 5.1.2600 (SP2) All of the PCs are...
0
7464
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...
0
7656
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. ...
0
7805
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7413
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...
0
7751
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...
0
5968
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...
0
3449
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...
1
1874
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
0
700
bsmnconsultancy
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...

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.