473,320 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

When running access .mdb on network, can form properties be set for individual users?

167 100+
I am running MS Access 2007. If I have an access application running on a network can I control the read/write access for the data by setting the form properties to yes or no for "Allow Additions", "Allow Deletions" & "Allow Edits" based on the user's login? Not sure how access would handle the form properties if it is on the network and shared. If one user is logged in and has 'read only' access and I set these form properties to 'No', then another user logs in, can I set these same form properties to 'Yes' for this user independently of what has been set for the other user?
Hope this makes sense!
Mar 25 '11 #1

✓ answered by Stewart Ross

Access is not a client-server application. Regardless of the location of the front end database (on a network drive or elsewhere), the application is running locally on the user's PC. There are as many instances of the application as there are users, each of which is unconnected at the user interface level with any of the others.

This means that settings such as Allow Edits etc apply to that instance of the application, so you can certainly set these for individual users under program control without any difficulties that I can foresee.

-Stewart

2 1726
Stewart Ross
2,545 Expert Mod 2GB
Access is not a client-server application. Regardless of the location of the front end database (on a network drive or elsewhere), the application is running locally on the user's PC. There are as many instances of the application as there are users, each of which is unconnected at the user interface level with any of the others.

This means that settings such as Allow Edits etc apply to that instance of the application, so you can certainly set these for individual users under program control without any difficulties that I can foresee.

-Stewart
Mar 25 '11 #2
NeoPa
32,556 Expert Mod 16PB
Changes made to the settings or properties of a form are made within a session. A session manages the running values of variables etc, rather than the fundamental design of the objects stored within the database. Essentially like RAM data. When the session is over all session data is lost, but the designs within the database are maintained. A session starts when you open the database on a PC and typically lasts until the database is closed or the session is reset (which can happen sometimes when code is edited though not in all cases).
Mar 26 '11 #3

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

Similar topics

1
by: Eric Janzen | last post by:
This is a very frustrating problem. We have installed Developer Suite 10g on 4 machines. The Development suite is in one Oracle home directory. On the same machines we also have a 9i database...
4
by: Kevin Myers | last post by:
Hello, Please forgive my reposting of this note with hopefully a more relevant subject line. On an Access 2000 form under Windows 2000 I would like to use a Kodak Image Edit Control to...
1
by: Tim Graichen | last post by:
Hello, I currently have a subform that displays four fields from a query. I have the subform's properties set as follows, so that the end users can not accidently change the data. Allow...
2
by: sierrachang | last post by:
Why would one not want to sort records in a form using Form Properties > Datasheet View > Sort Ascending? It's the fastest way, isn't it?
4
by: Boris | last post by:
I observe the following strange behavior of my application. Let say we have managed application MyApp.exe which depend on a few assemblies MyAssembly1.dll, MyAssembly2.dll and MyAssembly3.dll. The...
0
by: Adam Knight | last post by:
Hi all, Is it possible to access a web forms properties via code. Ie: Alter its name, action ect. Which namespace & class does the Web form fall under? Help appreciated!!!
9
by: Dimsion | last post by:
Hi, How do i expose all my forms and it controls to other form in the project? I want to be able to add a form and some control on it, this then be available to all other forms. form1 click...
0
by: MezzCowles | last post by:
Hey all, I've got a .NET program that we've written, and since it writes to and reads from the HD, it, of course, throws a PolicyException when we run it across the network. That's perfectly...
1
by: utpal | last post by:
Hi, My CSharp program, when I run from the local drive it can create/modify registry. However running the program from a network drive, gives RegistryPremission error. I don't belive that just by...
3
by: piers.allard | last post by:
I am looking for assistance with an issue I am gettting with an Access2k application. When I have xp style switched on, switching from screen to screen causes the first screen to resize to it's...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.