Hi, can anyone help? Like an idiot I veered away from my intention to put a password on an Access database which holds only a table and a few queries and explored other security options. I now cannot get in to the database at all and get a message telling me that I do not have the necessary acces srights and to consult my administrator. When I look at the properties, I am shown as the administrator, which makes sense but despite trying various, desperate things, I cannot get back in to take the security off. Needless to say I did not create a copy first, so have learned a lesson the hard way. Any advice gratefully received.
I have an inventory database i am working on but am too new to access to know all the inner workings. Quick summary of what I need to accomplish: I have a databse with several tables each representing different types of parts that we sell. Each table is similar in that the primary key for each is the part#, beyond that though the different types of parts have different specs that go with them. (example: for enclosures, the dimensions are needed but the amperage is not, for circuit breakers the opposite would be true.)
Next I have an inventory table, each record has a unique Control number that we assign as the primary key, then just a part #, notes about its condition (some parts are used) , a shelf location, and a price and date.
I have a very small sample database that i can email to anyone interested in looking at it.
Basically what i think i need to come up with is form that has several aspects to it. A user enters a "CATALOG NUMBER" into a combo box at the top of the form. tabbing out of that field then shows the specs of that catalog number below. the problem is the part numbers would come from a number of tables like the BUS PLUGS, MCCB'S, ENCLOSURES tables, all of which have different types of data. Finally, at the bottom of the form would be a result of a search through the INVENTORY table returning the multiple lines of line by line data where the CATALOG NUMBER matches the one specified above to show the records with the same catalog number but different notes, prices and different shelf locations. anyone care to take a look?
I just finished building my database and i have to install it on a PC. my problem is how to remove access tool bars and menues so that the only thing that appears when you open the databse is the login screen? I don't want the user of the database to be able to go to design view and change the design of the forms or the reports. I want the user to see and be able to interact with the login form and the switchboard. I wanna also know how can i install the databse on the PC. do i just copy it and paste it or is there any way else?
I need to import the data from one database into another everytime a form opens, I have some code which works:
Function GrabAccessTable() DoCmd.TransferDatabase transfertype:=acImport, _ databasetype:="Microsoft Access", _ databasename:="\triggerwwwroot$AW@RDAW@RDOnline.mdb", _ objecttype:=acTable, Source:="Main", _ destination:="Table", structureonly:=False End Function
The problem is that it won't surrently write it into an existing table, I want it to write into a table called Table (stupid choice of name I know....) but instead it creates a new table calle Table1.
Hello everyone! I am completely new to MS ACCESS, so this problem might be fairly simple but yet it is eating my head.So if I get some directions it will be greatly helpful and appreciated. Description: The bakery buys ingredients from number of suppliers, makes a several kinds of cakes and sells to few shops. There are about seven ingredients in the first week with the possibility to add new in ingredients later on. There’s a catch though; on any day, only a single type of cake is made, in a single batch and all of them must be delivered before the next day’s cake are finished. It is necessary to be able to rack the ingredients used in a batch back to the suppliers. I have made tables for suppliers, ingredients, orders and order line (with fields ordereId, ingredientId, quantity, unit price). Forms that allowing users to allow new ingredients types, suppliers, and new order for ingredient are required which I have made. These forms are to be used to add the data for which ingredients are needed in the second week of baking. So these are my questions on which I am stuck in
1. Do I need any more Forms or do I need to edit my form? 2. Is it okey to put table as the data source or would it be better to place a query? 3. How do I keep records of my earnings and expenditure, expenditure and keep them updated with my databases? I hope you will understand that I am completely new to these topics and its really hard for me to grasp them all at once. Merely some guiding points will be of great help. Thank you. 6pandn21
I thought I new enought about access databases. I've used the Time & Billing database as a template for my sister to use, but her partner uses a MAC. How can I get the MAC to access the database? I believe the MAC can use Excel but how can I link these two, if at all.
there is a standalone msaccess database(*.mdb)... i want to create an audit table cantainig the respective detaill(created or update by,time stamp.n the data that is update or created)...
the challenge is there is no form ....the database is manully updated...i mean anybody can opne the databse n alter the existing table inside the databse....
its just a standalone database..
is it possible to achieve??? if yes... how can this be achieved???????
if not is there any other approach that i can follw???? will really appreciate for ur feedbacks...
hei hei can you think for me 1 more second , PLEASE because I made all my menus invisible in startup. BUT when I open a form , for every form a taskbar icon is getting created. whwen I click any of the taskbar button of my my project forms, the Database window is apearing. I don't understand why is it coming , I don't want it to apear when users are working on the project. but before it is not apeared but it is happening since yesterday only. please help me in lettimg me the reason for the appearence of Database window. thank you for your time. Kiran.
I created a Contact database where I have the date and time as two separate fields in one of the tables. I have them defined as such, but would prefer that the fields wait until I enter data into them and not auto fill with the current information. Is there a property of these fields I can set so that these fields do not get auto filled? Again this database is too large to send, so I hope that you can help without it.
When I bring back my access 2003 project from work back home, i open the project at home, I am using access 2002 or 2000 format.
Then I notice if I save a copy of my work using access 2002, while initially using an access 2003 database, the file size decresaseas dramatically, from like 3mb to 800 kb?
I am in the process of trying to create a DragNDrop feature in the Access database that I've built. I have 3 employee with several different txt boxes all side by side and I need to be able to drag and drop the job from one to another.
I need to create a class module to do this but my problem is I don't know how.
Hi I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.
I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either. Any pointers or code would be gratefully received.
I know this sounds stupid but on my database with user-level security, i have somehow managed to remove administer rights from all users , and do not know how to change it back, if it is even possible.
I think what might have happened is it was stored on my USB drive and i switched computers and opened the db, would that have affected it? :confused:
Is there an easy way out of this or am i screwed? :eek:
I have been following a text book to try and secure a database, i set up the Work Group Info File, allocated a password, now even when i want to start a completley new database i have to enter a password.........
AND when i set up the password i must have enetered it wrong now i am completely locked out!!
Is there any way to fix this i cant do anything!! I cant even start on a completely new databse!!
i have this database with tables i can't access, so i had to import the data into a new database , given the size of the new database JoeCruse (form this board) pointed out that it could be that the front end is separated form the back end. and i can't find the front end anywhere
i want to press F11 and see the tables and so forth open up when i launch the original db. how do i go about doing that.
:eek: security levels were set on a database using the wizard, unfortunately the person who set the security did not print out the sheets with the WID etc on it, this person is now unable to open access at all from their pc it asks for a password which the user does not believe they set or if they did set one it was their standard pc log in, however the database and access can be opened from any other pc on the network......can anyone out their help...thanks
I have a database that I password protected. Somehow, in the process of applying the password, the file became corrupted and now I am getting the following error message:
"This database is in an unexpected stat; Microsoft Office Access can't open it.
This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state."
Does anyone know what this error is and how I can retrieve my data?? I have tried to import the files into a new database, convert the database into a different version and compact and repair. Nothing has worked. I have looked into recovery tools and two of them do get me into the database and let me see some of the data, however, the programs are holding my information hostage until I purchase the software which is running around $300.00. Any ideas???
I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so often one of them experiences being unable to input data from their Form because of this lock condition. Sometimes the condition will go away (if they wait long enough) and they can input data again. Sometimes it's User A experiencing the lock, sometimes it's User B. I thought splitting would alleviate lock issues, but it doesn't seem to be the case for me. Could this be a "permissions" issue on the shared directory where the BE is located or some security setting within Access (or both)?
I copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working.
Any suggestions would be very much appreciated.
Thanks, Mike
------------------------------------------------------------------------- #1 02-13-2006, 04:33 AM odun Registered User Join Date: Apr 2005 Posts: 108
can't log on to database
Hi all, I was playing with passwords for one of my access db. I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
Please help
Thanks!
odun View Public Profile Send a private message to odun Find all posts by odun Add odun to Your Buddy List --------------------------------------------------------------------------
Is a moment of desperation! I created a security group or something (dont know what i was thinking!), and now there is no way to get into my application!!!! It says to contact with the administrator, but I'M the administrator!!!!
Any way to get the scripts minimun from the applications?? The classes, the modules??? God!!!! My last backup was 4 days ago!!!! I can't loose everything!!
Message: you do not have the necessary permission to use myapplication.
I have two db's a front end and a back end db. One of my users recently got this error "Could not update currently locked" Access "3218". I have a form tied to a table. She changed a drop down that puts an ID in the table row and the error occurred. This has never happend before and the locking is set to "No Lock". She swears nobody else was in that specific form either. How does this error occur out of no where? I did add 3 new columns to that table for a total of 30 columns. The front end is local and the back end is on a shared drive. Honestly if anyone can help I would be so so greatful. There is no code used to update this row in the table. As soon as she hits the drop down the new row is created in the table.
I used a test database to work on security. I didn't think it would effect other databases. Now I've locked myself out and can't open any databases. I keep getting asked my logon and password for ALL databases.
What can I do? I don't understand why it's effecting me using all databases. Everytime I type a username and what I believe to be the correct Password it wont let me in