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
Does anyone know why this happens?
Everytime i open a database in MS Access 2007, a copy of that db is created in the same folder. When i close the databse, the copy doesnt get deleted.
How can i fix this?
I have an existing database, that is a mess.
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 ?
I just keep starring at the wall.
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 ???
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.
Is this possible and If so how?
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?
Thanks in advance.
I am creating a database that several departments want to use. They each want to have their own database file, but have to report the data to a single manager.
They are wondering if we can export the data from the individual databases and import it into the managers master database, for example, at the end of each month.
How hard is it to do this? Where would I begin, or have you another suggestion?
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..
Thanks in advance..!!
Can someone give me some general suggestions on taking a donor database for one organization and making it workable for an additional organization?
Should I copy both the back-end and front-end to a new folder
Should I back-up both the back-end and front end to a new folder so I can rename it?
Or can I use the same front-end for two sets of data? If so, how do do that? There are several tables.
Any advice would be appreciated.
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!
Somehow a database has become corrupted I am trying to repair it and am being told that it is opened exclusively by user Admin on P11543.
I am P11543 and im positive that I dont have the database open so im a bit confused, any idea on how I can repair the database?
[ms access 2003 / sql server]
I'd like to build a simple database that is local with forms to update records in it.
In addition, I need to build a simple web page for viewing the records in that local database (reading only)
1. any idea how to create the update mechanism between the local database and the web database? the update doesn't have to be live, it could be even done once a day.
2. assuming the local database is an ms access mdb and the web database is sql server, is it still possible?
all ideas are welcome,
Heres my code.. there problem is the DoCmd line at the bottom. The table i want import is Events.
Private Sub cmdImportDb_Click()
Dim strFilter As String
Dim lngFlags As Long
Dim strInputFilename As String
Dim ReturnResult As String
strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mda, *.mdb)", _
strFilter = ahtAddFilterItem(strFilter, "dBASE Files (*.dbf)", "*.DBF")
strFilter = ahtAddFilterItem(strFilter, "All Files (*.*)", "*.*")
ReturnResult = ahtCommonFileOpenSave(InitialDir:="C:", _
Filter:=strFilter, FilterIndex:=3, Flags:=lngFlags, _
DialogTitle:="Please select your database file to import")
DoCmd.TransferText acImportDelim, "", "tblImportDb", "Events", ReturnResult, False, ""
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?
Thanks in advance
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.
Desperate in Oxford, CT. !!
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.
Thanks for your time
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"
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.
First, let me explain what I am trying to do.
Lets say I have test.mdb and test_be.mdb
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
MsgBox "Error in addColToTbl( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
When I run the code I get an error message saying "Error #7867 You already have the database open."
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
MsgBox "Error in addColToTbl( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Is it possible to close one database from another using VB?
If so how is it done?
Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.
It seems to me that this should be simple, but I just can't seem to get the correct setup.
1. I have a database called Names. Some of these names need to appear in another database called CompanyManagers.
2. I have a form set up which lets me choose the Company Manager name from a combo box list.
3. I also want pertinent address information on the Manager to automatically show up in the right fields on the Company manager form once I've chosen that Manager's name from the combo box.
How can I do that in the least painful way?
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?
Many thanks! AOW
Apologies if in wrong section
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)
Status: Available or Not Available
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