Should the Security Wizard be run to create the user rights before or after splitting the database? If it's run before splitting, does that mean that the .mdw will control both the front end and back end, versus running it after splitting it will only control the front end? I'm planning on having the back end on a server with no user rights to traverse the directory.
When should I convert the front end to an .mde - before or after running the Security Wizard, before or after splitting?
Any and all replies would be greatly appreciated by this Access rookie.
I tried using the security wizard and I think I, I know I should have read up rather that trying to set it up. I printed the security report so I can get back in to the db but now all db's on this pc require me to log in now. How do I remove this security? Can I just delete the security db that was created by the wizard?
Hello all, its been a very long time since I've been here. I'm having to brush off the dust and get back to using Access a bit here and I'm tasked with trying to set permissions on a database which our department uses. The actual database I will eventually set permissions on is an Access 2000 DB.
I've tried setting up security years ago and had all sorts of problems and then abandoned the project. So now I am re-trying and I used a test db to do this so I didn't screw things up. The test db is Access2003. I've read tuturials on how to use the Wizard, but I continue to "lock myself" out of the db.
Here's a step by step process of what I've done.
1) Create a new workgroup information. 2) Name my WID (left it as the random alphanumeric code) and selected the "I want to create a shortcut to open my security-enhanced database." 3) Have all database objects selected for security. 4) Selected "Full Permissions" and "Read-Only Permissions" groups for the workgroup information file. 5) Entered Users. 6) Set User permissions. 7) Saved the copy of the unsecured database.
When its all done then when I try to open the database and I receive the following popup.
"You do not have the necessary permissions to use the <database> object. Have your system administrator or the person who created this object establish the appropriate permissions for you."
What steps or concepts am I missing here? What I don't understand is shouldn't there be a login popup that comes up when opening the database? This is one area of access I understand very little about. Do the mdw files need to be in a specific location? I appreciate anyone's help on this. Thanks.
Hi All, Forgive me for being a bit anal but I always prefer prevention over cure any day.
First I do have a back up of the db. (Access2K) It is run on a Public drive with controlled folder access and is used by Multiple Users internationally via Citrix software. Assuming Access uses Windows API's to verify the user logged in, no passwords should be necessary.
Upon using the security wizard it will create a new mdw file. Should this be located in the root of the server or would the same folder (a different drive in server) that the db occupies be sufficient?
Currently this is a standard mdb. I tested a FE/BE configuration and for some reason this ran incredibly slow on our network. Not wanting IT to elaborate on lack of funding, I opted to remain with original configuration.
The shift option on open is password protected. Is there anything that I've overlooked? Any and all constructive critique will be appreciated.
I need to give different users different levels of access to my database.
I ran the user level security wizard and have correctly created user accounts. I chose to make my account a member of the Admins group, and that appears to have worked in that I can go into User and Group Accounts and create accounts, remove passwords, change group membership etc.
However, I am no longe able to access the User Level Security wizard. Access gives me a message when I try, saying that I need to be a member of the Admins group to control security settings.
Can anyone confirm if this is correct or if I have done something wrong? I don't want to let my users start using the database and then find out I've actually locked myself out of some vital settings at a later date!
I created *.mdb database and I used (user-level security wizard) to give each user a username and a password. The dB file is saved in D: drive. The security wizard created a shortcut on the desktop to open the dB through it. After using that wizard I cannot open the database directly from drive D:.If I try to open it , it says"You don't have necessary permissions to use the database".Now, there are many users should use this db through the network.
If I would have a backend table with the data kept in tables and a frontend database with forms and reports and queries etc. and linked tables to the backend db, what would be the right way to secure both.
In my situation I have salary information in some of the tables, which should not be wide open to the holy world. I also need to restrict the access of some queries and forms in the frontend database to different users. That means I need to set up a secured frontend database with different usergroups having different object permissions. So in that frontend database the Users Group and the Admin User do not have any permissions any more. Thats why I created a shortcut where I kept the database and workgroup information in the target. Every user needs to open the database via the shortcut.
Unfortunately I was not able to secure both the backend and the frontend database, because the linked tables in the frontend db are only pointing to a database not to a shortcut. Because the backend database is secured as well (no permission to Admin and Users any more) it can't be opened directly - only by shortcut.
Am I right that there is obviously no possibility to have a secured backend and frontend db via the Jet database engine and Access?
I hope somebody can answer my questions. At least I know that I can't do anything else and I did not something wrong ;)
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
guys, can someone help, i copied this sql from the wizard window, i'm trying to put the sql in a vba code here is what i did, the select is not working it has syntax, can someone help?
Dim mySQL As String Dim db As Database Dim rs As Recordset Dim x As Long
Set db = CurrentDb
mySQL = "SELECT change_order_tbl.serial_num, Max(change_order_requestor_tbl.change_order_effect ive_date) AS MaxOfchange_order_effective_date" _ FROM change_order_requestor_tbl INNER JOIN change_order_tbl ON change_order_requestor_tbl.change_order_id=change_ order_tbl.change_order_id GROUP BY change_order_tbl.serial_num HAVING (((change_order_tbl.serial_num)="abc"));"
I have a table that shows all the company's PC's, and another table that shows all the software. I have a smart look up for a the PC's that when you click on it, it will show you all the software loaded to that machine. however, there is so much software loaded to these machines that when the look-up is clicked you can not read all of the software because it is listed horizontally. Is there any way that you can have the look-up view vertically. Any other ideas would be much appreciated.
Is it possible to do this through vba. If security is setup for all the tables and a user goes in and creates a new table, can that table have security applied to it using code?
So maybe the creator of the table has read/write privileges but everyone else only has read only.
Ok, I have Acc2k3 professional with Visual Studio Tools for the Microsoft Office System which according to MS includes the Microsoft Office Access 2003 Developer Extensions (http://msdn.microsoft.com/vstudio/office/officetools.aspx) that are required to package an MDE/ADE file using Acc2k3.
The question is how do I run it? I cannot find anything to do with packaging or deploying an Access file anywhere, not only in Access but ot the system and on the Visual Studio Tools for the Microsoft Office System cd.
I should point out that my PC has VB.NET 2003, Office 2003 (prof) and Office 2000 (prof - Access only) installed on XP SP2 (I believe that all relevant SPs and critical updates have been applied). I have tried upgrading my project from Acc2k to Acc2k3 and all to no avail.
I hope someone can help on here with this. I am having problems using the package wizard. I can run through the first couple of steps on the package wizard, but when it asks for a language to cache, it fails to install the necessary files.
I have found the resolution on the MS KB site about copying the files to the HDD, and the renaming the exe file to SETUP.EXE, but whenever I select this file to cache, I get the following message:-
'C:SourceSETUP.EXE' could not be copied to 'C:Documents and SettingsusernameApplication DataMicrosoftAccessADE11Cache1033SETUP.EXE'.
Verify that the source file exists, that you have write permissions on the destination folder. etc
I don't think it is permissions, as it does copy the msi and cab file to that particular folder, it's just the SETUP.EXE file that it doesn't copy over.
Has anyone ever experienced this before when using the Package Wizard?
I want to manipulate a few tables and make them into one table, but I don't want all of their fields. I heard that I could do it with "map table wizard" from the top of the menu. Where can I find it? Or, can anyone recommend me what I should do better?
I have three fields that I would like to have access the same table using the Lookup Wizard. I am unable to get the query to work.
Example:
The Fruit table has 5 records, let's say: orange, apple, banana, kiwi, strawberry.
The first field -- Fruit1 -- would use the Data Type Lookup Wizard referencing the Fruit table.
The second field -- Fruit2 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The third field -- Fruit3 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The bottom line: a person will have a choice of 3 fruits.
Again, the problem is that I cannot get the query to work where I choose =banana for the criteria for all three fields. Banana might be person one's first choice, but it might be person two's second choice, etc. I'm looking for all the bananas no matter which choice it is.
Hello, I have just started on Access: creating 2 tables with primary keys and one-to-many relationships, and 2 simple queries. I want to create a form but can never complete the wizard or auto-form or else because it crashes with the pop-up message "object variable or with block variable not set" ? what does this mean? thanks for your help.
I've been building a database with Access. When I added a combo box to a form, it used to pop up a wizard which would guide me through selecting the data the box displayed and what happened to the selection the user made.
Howdy All!!! I am receiving the below error message: "You have chosen fields from record sources which the wizzard can't connect. You may have chosen fields from a table and a form a query based on that table. If so, try choosing fields from onluy the table or only the querry."
OK here is what is going on... I have a table that is linked to a *.txt file. This *.txt file comes from our AS400 and is the root of all my information. It has 2 pieces of information in it that I need to seperate out and then eventually join back together. It is a space delimited file. The 2 pieces of information are: 1) Header (Dates, Vessell, and Container information) 2) Body (Product information and qty of each Container)
The mapping looks like this: Header='ISPDD' 1- A Record Name = mid(1,5) [Ref. Example:ISPDD] 2- Unique Key = mid(6,7) [Ref. Example:0000001] 3- Container Number = mid(13,10) [Ref. Example:MK03000001] 4-Arrival Date = mid(23,8) [Ref. Example:06092004]
Body='ISPDT' 1- A Record Name = mid(1,5) [Ref. Example:ISPDT] 2- Unique Key = mid(6,7) [Ref. Example:0000001] 3- A item code = mid(13,6) [Ref. Example:007529] 4- A item color = mid(19,3) [Ref. Example:015] 5- Item Qty = mid(22,6) [Ref. Example:111111]
What I did is wrote 2 query's. One that looked at the *.txt file and produced results on [Like "ISPDD*"] to give me just the HEADER information. I then added the criteria from the space delimited mapping above. I did the same to pull out just the BODY information, again adding the criteria to the query from the space delimited mapping above.
Now that I have the two pieces of information, I want to run a report and combind the 2 together in a more reader friendly format. In doing so I received the error message above.
I then tried having the query's create a new table after they run (one Header Table and one Body Table). Once that completed I created a relationship between the 'UniqueKey Header' and 'UniqueKey Body'. This actually worked but, when I receive a new *.txt file and run the query it gives me read only/cannot delete files because of relationships. Needless to say I am in a bind. Hopefully I shared enough detail to help me with my problem. Many thanks in advance for the help. One other piece of info, This *.txt file can contain many headers and boddy information. I have received one that had at least 10 different Unique keys that had to be linked together.
I am at the point were I want to package and distribute my application to other users. My application uses several .bmp files and other resources that I have stored in the OFFICE11 file because you have to reference the location of the objects in VBA Code where access can find it.
What I cant figure out is, how do I get the package wizard to install the resource files I include with my program to where I want them (OFFICE11) so if the user installs the database at a different location than the default location which is C:Program FilesApplicationNameI'mDistributing, the program will still run because the resource files can still be found by the program in the OFFICE11 file.
Make Sense?
A more advanced problem I am experiencing:
Is there a way to have a run time distributed application automatically find and repair it's link to the back end if the back end gets installed to a network instead of the default Local C: path?
I will try and explain this as simply as possible.
I have a lookup table that is purely dates so the field is Clinic_Date, the format is date/time, and the input mask is set to short date.
I have a table called appointments. I have a field called appt_date which I am trying to make a look-up field by using the wizard to look up from the clinic_date table. However I an getting the error message "You have entered an expression that has an invalid reference to the property l." (thought it doesn't look like the letter "l" but more like a long vertical line).
It's much as I thought it would be. MS Access is limited for a mid size database application. I have developed this mid size database for the medical clinic I work for. I didn't want to do it, but they saw some of my personal projects I created and pretty much told me to come up with something.
Well, the good news is, the database itself works exactly as designed, meaning it does its job very well. The bad news, and I knew it would happen, is instability. When I first started creating this program, I had no idea how many people would be using it at once. That, and after reading through these forums for the last few months, I realized that Access wasn't the puppy to be creating this database in. As it stands, about 130 - 150 systems access the database (about 3 times more than I originally forcasted.)
I'm sure those of you who have done something similar knows the next thing I'm about to say...... yep..... mysterious run-time errors - locked database from time to time - owc (office web component) errors...... etc. etc. These errors pretty much happen during peak hours.
I am pretty positive it's because access wasn't designed to handle such a load..... which led me to a researching a resolution. The answer that may be my savior is the upsizing wizard included with ms access. We do have MS SQL server running on a server...... I was just curious if anybody's ever used the upsizing wizard; either that, or has anyone ported an access project to sql. (This is a big program, and would hate to have to reprogram)
I am running Office 2003 with the latest updates on XP Professional SP2, again with the latest updates. The install was fresh only about a week ago, and I had only used this install of Access for a few hours before it started doing it!
I have tried creating a totally new database, or using an existing database, and the same happens. This led me to believe it was my Office install. I tried doing a repair through add/remove programs, which successfully repaired Office apparently, yet the problem persists. I even totally removed Office, rebooted, and reinstalled, and tried without updates!
