I am unsure about the relationships for this database, which is a big problem. Also, I created a query but some fields do not allow data entry, which in turn had the same effect when I created a form from the query. I think it's because i selected the fields from the wrong table or i donno. You will understand exactly what i mean when u see my database (attached). If u see disabled fields in my form i did that in purpose because i expect them to be displayed automatically when i enter the data.
If u have time can u please make the changes needed and send me the modified database attached, if not just give me a textual description of what i should do..
thanks a lot, please reply soon...... i need urgent help
Is this relationship correct (see attachment)? When i create an orders query with the fields:-Barcode number (source: orders/products table)Product name (source: products table)Quantity (source: orders/products table)Unit price (source: products table) Total (calculated - [Unit price]*[Quantity] )it does not allow data entry for barcode number and quantity (product name and unit price should appear automatically when barcode no. entered) why is that? and how could i resolve this? attached also is my database to see what i mean... if u have time can u please make the modifications NEEDED and send me the modified one, if not just give me a textual description of what i should do..... (btw it is actually a school canteen system databse, thats why i have customerID field as student administration number or staff initials)please reply soon.. this is urgentthank you
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 email@example.com", 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
Nice to be back here...it's been so long I can't remember what my username used to be...so here's my new one!
I have a crippling problem with a A2K database running on W2K. The database is not terribly large, about 70MB. It is run over a corporate network and sits on a share and the problem is that even a couple of users running it simultaneously will cause the "Database is corrupted or is not a database file" message to appear.
We have vastly simplified the database, split out the front- and baclk-ends, and still experience the error. Typically what will occur is that one or more users will still be in the application, but others won't be able to enter after a time.
I have searched the archives but have been unable to locate a definitive list of tricks that might be attempted to deal with this trouble. Posting to other boards pretty much earns me the "haw, haw, haw...don't use Access, then" type response, which is not especially helpful.
Can we try and brainstorm some steps for this issue?
I am designing a DVD Movie Collection Database for my own personal use and requiring a little help.
Brief description: The key tables are tblMovies, tblLoans with the following key fields
MovieID (Auto Number) MovieTitle Status: Available or Not Available
LoanID MovieID MemberID LoanStatus: Status Loaned or Returned
My query is there a way to store multiple Movies Title with the same Movie ID.
Scenario: DVD contains the movies Saving Private Ryan, Spiderman, Star Wars and a friend loans the DVD, I would like it to be in effect all three movies status %u201CNot Available%u201D.
I already know I could put all 3 movies in the one field MovieTitle, which will fix this, but this isn't a good solution as this won't sort my movies into a alphabetical order and movie count would not be accurate
If somebody has any tips or advice, or if my thinking is wrong please reply