I am a student and in need of some serious help. For our Coursework we were told that we needed to create a database for a company of our choosing. I did some research and decided to pick a DVD rental shop as i thought this would be a good idea at the time. Now its come the time to actualy start making the thing and i am in serious trouble..i have no idea how to use access..i have tried going through all the tutorials but they confuse me more!
all i have so far is 4 tables..customers..DVD's..rentals.and Suppliers..i need to know how to create a input form so i can add new customers but when i try to create a form and then go to pick out the feilds..there is no fields to choose from!
Hi, I am new to access and was if someone could assist me in designing a database exactly like the rentmaster software on this website(http://www.rentmaster.info/trial.html). I was told to design a database just like this one but, I am not all that familiar with ms access 2003. I've try searching google and microsoft's website for database templatesand I didn't see anything similiar to it. Any help with this is greatly appreciated and if I didn't go about posting this in the correctly, I am extremely sorry. Please don't hesistate to tell me and/or guide me to the right place.
I am familair with access now and am trying to build my first 'real' database. The database i intend to create is a rental system- with a video table (and a genre lookup table), a customer table, and a transaction table. I want to be able to have a customer rent a video, and the database set a due date for the return, and have a reort that shows all the late videos, and maybe calculate how many days ate and thus a fee. I am having problem on where to get started n the transaction form, where the renting and returnng tkes lace, any pointers, or expample databases would be great.
My company rents equipment to our customers. I am looking for a db to track our stuff. There are three possible locations of everything. Warehouse, employee trucks, and Customers. I assume that warehouse can be added to the employee table. I can set up these 2 tables and one for our equipment list, but the hardest thing I am having with is with the table for transactions(I believe it should be a table), this needs to allow batch transations, because typically more than one piece of equipment is moved at a time.
I will need a report that will show each equipment id number in a customers home from date to date (date it was placed and date it was removed), one that will show a list of all equipment locations on a given date, and one more that will show equipment that has been in a customers house for 5 days or more so I can verify that it is still there, becuase equipment typically should never be with a customer for more than 5 days.
Right now I am using excel, but its not working well. I would greatly appreciate some help! The attachment only has the info I need for the 3 tables I mentioned above that I know how to do, and my best guess at what the transaction table should look like.
I've created a database consisting of 10 tables in total (see image).
I've had no problems constructing the database, however when I come to create a booking form I came across a problem. If I add in payment details into the booking form, it won't show records or let me add one, if I take payment details out it works fine.
This makes me think there is possibly a problem with how I have linked the customer and payment tables together but having problems seeing where I am going wrong, could anyone offer a little help?
I'm developing a database at work that tracks rental equipment (such as quantity, days on rent, price, and daily rental price). Now, I'm not dealing with a small inventory or quantities. We have hundreds of items and quantities from 1 to 1000 depending on the product. I'm trying to find an example database that I can get ideas from. We currently use excel spreadsheets using formulas like "=((DAYS360(J$3,$BF$1))*$F262*J262)" to get the daily prices. Some products will go out in stages, 100 one day, 400 the next, 250 two days later. Then they will come back in stages too. I'm wondering if it's worth it to persue a database format rather than a spreadsheet to calculate all this. So if anyone can point me in the right direction to some samples, that would be great! Thanks!
It is basically one table with some lookup tables that contain repetitive data like product categories. The field code is the product code for a specific product, it was not set as no duplicates. Most products are in specific product categories, but some products are in multiple categories. To work around this, the products were just copied in multiple times and each record for the same product was given a different category. I am in the process of normalizing the database, and making it more relational. I understand this is something I need to correct 1st.
Any tips on steps to correct this as I do not appear to be looking at this ?
Yesterday, I was entering data in a database that I made. Everything was working fine, and I closed it and went to bed. When I woke up this morning to resume data entry, one of the records looked like it was written in Japanese. I closed it, decided to deal with it later, and when I opened it again it says that the database needs to be repaired or isn't a database file. It won't even let me in, it just keeps giving me that message. Please help!
Hi, I am currently working on an existing multi-user access database for the company I work for. I made a couple of changes to the application itself (adding front login screen facility), A colleague of mine also compacted and repaired the database (from 500mb to 10mb).
However since these changes to the database were made we keep receiving this error message: "the database <<database_name>>.mdb needs to be repaired or isnt a database file". In order to fix it i need to kick everyone out of the database and then it allows me to repair it. However this is an intermitent problem and occurs possiblty 2-3 times a day.
I have already searched the internet for answers on how to rectify this issue, it sounds to be a corrupt database but i dont know why it has occured, I have heard of the application JetComp.exe but not sure how successful this is, can someone please help as its becoming an annoying error message and one which there is no end in sight.
Mulitple users are using a basic database complete with switchboard, forms, tables, queries, etc. Sometime one user will have the database open all day and it will somehow lock the database so if other users try a open / access the database they will recieve a message that states on opne" database has been locked by DEL-1263" and they cannot open or access the database. I tried creating a workgroup with usernames to access to see if it would not lock the database and allow multiple user access without locking, but it's not working. How do I do this so he database does not become locked by one user ???
environment. an access 97 format database running in AccessXP on a peer to peer network. When users click on the Cross to close access, as opposed to the Close combo box corrupts their database. Ran compile and no errors. Checked systems files and there are two MSysModule tables, but cannot delete, not sure if this is related.
I have ran the same test on my laptop, the only difference is it is standalone, and have not been able to replicate the problem, is it a server pack problem, the network or something else??? anyone with any ideas? Users said run other access programmes and no problem???
I have to add some new forms and tables to a database. This will take some time and the clients wish to keep it running. Is it possible to make a copy of the database which I can work on at home, then transfer the data from the original database to the amended one?
I was thinking the simpest way would be to just copy the old tables into the new database.
I created a macro called "autoexec" with the action set to "RunCommand" and the corresponding command called "WindowHide". My understanding is that when the database opened, the Database window would be hidden. It isn't. Can someone please let me know what I need to do to hide the Database window when my database opens?
I am responsible for support of a multiuser database without much security. The above error seems to be happening more and more often. Even after I get all users out of the database, it does not let me do the rebuild and says the file is locked by my machine. I have rebooted and done everything I could think of but I still get the message that I can't compact and repair because the file is locked by me.
So two questions. First, any suggestions what causes this corruption and what I can do to prevent it? And second, what can I do so that Access will let me do the rebuild and not think that I have the file open?
Thanks in advance for any and all suggestions/ideas.
Does anyone know if there is a form or sample database out there that can check the version of a specific database a person is running on their pc against a master version; and if the 2 versions don't match automatically update the local version from the master version?
Is this possible? I would need the autoupdate to do Tables, Queries, Reports, and Forms.
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application Call AcApl.OpenCurrentDatabase(strfolder, True) Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
I have a program I have got going in access 2000 and a myql database on a website using a php front end for it to access and add things to it and my question is this... Is there a way I can make my access database program have the ability to upload record into my database on the website and vice versa have the program download records out of the mysql database? This is something that actually doing it will be beyond my knowledge but I wanted to know if it can be done and how hard it will be to do this and if I will have to change both sides or if I can just modify my access program to do this. Thanks!
I am working with a development database. Once changes are done in the Development db, I then export the Database object to an updater for distribution to the users who are working with the db in a live environment.
Development DB ----->Database Updater<------------Clients
This data is pushed to a db that acts as an update manager for the individual clients. (Easier than me tracking all the clients and pushing to them on their own)
I currently push the individual files when they get updated, but on occassion, we produce a bulk update of queries or forms based on new requirements. Is there anyway to have Access export all of the Objects to the Updater MDB file?
Hello there...I am hoping someone out there can help me...This afternoon as I was entering information into my access database another user (coincidentally) was in the same form and must have saved their information shortly before or after because an error message asking me to overwrite their changes appeared and then the screen changed and all of this Asian characters appeared. I quit the application, made sure that Access was closed on her computer and rebooted. Now everytime I go to enter the database the following prompt continues to appear:
The Microsoft Jet database engine could not find the object "MSysDb." Make sure the object exists and that you spell its name and the path name correctly.
I went into the disk drive and all 200mb of the database is there, however, I can not access the information. Any advice or help would be greatly appreciated. Thanks!
I have a split multiuser database. There are approx. 10-15 users. Each user has a local copy of the FE. As part of this database there is a form where users enter batches. The Batches form captures the batch data, BatchAutoNum, BatchDate, TIN#, CheckDate, CheckType, UserName, etc. This table (T_Batches) that is fed from this form has just under 14K records and is stored on the BE. Then, on this form there is a subform which is linked by the BatchAutoNum field. This subform contains all the transactions that rollup under each batch. The table that is fed from this form (T_Transactions) is also stored on the BE and has 17.6K records. My users began to get scattered error messages recently "The Microsoft Jet database engine stopped because you and another user are attempting to change the same record at the same time." This happens when they are on the Transactions subform in the Batches form only. They would be forced to close and reopen the database. While no data is lost when this happens it is certainly aggravating and doesn't make me look too good. There are many other forms, reports, etc. in this DB but we only get this message on the Batches form. I have added a compact on close to the FE. I have created a blank DB and imported all the objects in the FE. I have compacted the BE (223mb). I even rewrote the Batches form but we are still getting the message. I was thinking of storing the transactions for each batch locally and then running an append query after each batch that the user enters but before I put in more time redesigning this form I wanted to get some feedback on other possible causes and solutions. Another thing I should mention too is when I working on a form and then go to save it, I sometimes am asked if I also want to save changes to another form which I don't have open...another bad sign ??
Could the issue be in the tables rather than the forms ?? I looked for null or empty fields in both the T_Batches and T_Transactions tables but I don't see anything obviously wrong....This is an extremely important departmental DB and while it is still currently operational, I am concerned that the DB will suddenly become unusable and we will lose all our reporting capabilities which are tied to the batch activity being entered by the users.
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
I am trying to update the stock levels on our company website on a daily basis with those found in our stock system.
Our stock system uses MySQL for the backend and Access 2003 for the front end.
Our website (www.epactrading.co.uk) uses php and a MySQL database. The website was not built by me but is a piece of software that allows me to log into the backend and add products, categories, update stock levels etc. Unfortunately the company we paid the software for will not give me/tell me how to gain direct access to the MySQL database, apart from using the back end provided by them. I am assuming/hoping the the user name and password to log into the back end is the same to access the tables in the database.
Does anyone know how I can find out the table structure or gain access to the tables in the website database?
Also I cannot run my own php scripts on the server, which is how I was originally hoping to update the site.
I have two separate databases. I need to be able to open database 2 using a criteria of a field on a form from Database 1. I have successfully used the shell command to actually open database 2 but I can't get the correct form with filtered information to open. I have used the following code behind a button:
Dim Varset, varpath Set Varset = DBEngine.Workspaces(0).OpenDatabase("S:RESETIB Station ModuleDSA USE ONLYIB Intelligence_be.mdb").OpenRecordset("Select LogIn.* from LogIn Where Login.[Hash ID] = '" & Environ$("username") & "';") If Varset.EOF Then MsgBox "User does not have an account. For access email firstname.lastname@example.org", vbCritical, "Invalid User Account" DoCmd.Quit Else varpath = """c:program filesmicrosoft officeofficeoffice11msaccess.exe"" ""s:RESETIB Station ModuleDSA USE ONLYIB Intelligence.mdb"" /wrkgrp ""s:RESETIB Station ModuleDSA USE ONLYsecurity.mdw"" /user " If Varset!Permission = 1 Then varpath = varpath & "agent /pwd randjont" If Varset!Permission = 2 Then varpath = varpath & "Supervisor /pwd randjont" If Varset!Permission = 3 Then varpath = varpath & "Superuser /pwd randjont" Call Shell(varpath, 3)
Database 1 is sourced from and ODBC connection and database 2 is from a local table. They both have the same field (although named slightly different). Where do I put the query/sql that will do the last part of opening the Subject Form for the person with the common field value? Your help is greatly appreciated. Tyler:)
Periodocally there will be updates to test_be.mdb as the application changes over the years. New functionality will require a combination of new tables, new columns, and table/columns becoming obsolete.
Currently clients sign into test.mdb with a userid and password, and can only access the test_be.mdb through the appication. The backend is password protected and they don't see the database window from the application (test.mdb).
I need to have a way to be able to send updates to them via ftp, email or some other method. It will not always be feasible for me to go to the client to add or delete and table changes in test_be.mdb.
My hope was to create a third database call testupgrd.mdb. This database would have the code I have included below, with the commands needed to add and delete columns, add new tables, delete old tables, etc. The code would open test_be.mdb with the password associated with the database and then run the commands.
Does this seem reasonable or is there some other way I should be addressing this?
Here is the code I have so far behind a 'Apply database changes' button in testupgrd.mdb.
Public Sub addColToTbl() On Error GoTo ErrHandler Application.Database "c: est est_be.mdb", True, "password" Execute "ALTER TABLE tblDepartments ADD COLUMN Organization1 Text (30) NOT NULL;", dbFailOnError Exit Sub
I am trying to open a database with code behind a button in a second database. This is the code I am trying. Whenever I cursor away from the opendatabase line, I get a compile error, Expected: =.
Public Sub addColToTbl() On Error GoTo ErrHandler OpenCurrentDatabase ("c:cimscims_be.mdb", True, "password") CurrentDb().Execute "ALTER TABLE tblDepartments ADD COLUMN Organization1 Text (30) NOT NULL;", dbFailOnError Exit Sub