Cannot Open Database". It may not be a database that your application recognizes, or the file may be corrupt. I have a colleague that is using Microsoft Access to import objects from SQL server but he's getting the above error. I've checked the login my colleagues uses and it has all the right permissions ect but I cannot seem to figure out why this error is still happening. Is it something to do with the SQL server or Microsoft Access?
I am getting error that MS Access db is corrupted and need s to be repaired. I repaired tht db but still getting the error. I have attached the error copy . Please help its urgent
I have a corrupt MS access 2000 database. It was saved to a flash stick with a compact and repair on close. It seems the flash stick was removed before the compact had completed. Has anyone got any tools that can recover the database? Or maybe point me to some freeware on the net that can recover it?? I appreciate any help.
when i am tryint to access my Access database its giving this error:
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. (Error 3011)
Code: Private Sub Command26_Click() If Forms![test site]![prp test].Form.[A Right Answer] = -1 Then Forms![test site]![number correct] = Forms![test site]![number correct] + 1 End If DoCmd.FindNext End Sub
Then when clicked it checks a yes/no box to see if "A right Answer" is the correct yes. Then it should pop to the main form and take the number correct cell and add one to it. I am trying to get the record to go to the next record inside the sub-form but docmd.findnext seems to be wrong too.
I am still new at database design, and cant quite come to terms with my project and access way of doing things.
I have to keep a register of people who participate in projects. The projects can be of two different kinds. BUT (here comes the tricky part) The projects are being evaluated on three different indicators, with each one of these having 4 measurements, in the range of 4-0. That was a quick introduction. Now let me break it down in parts.
The people:
I have made a Uniqe identifier (Social Security number (PK))
First Name Last Name Department (This can be 4 different departsment) made a drop-down menu type.
The Projects:
Unique identifier (Project ID (PK)) Social Security number Project Type Start date End date
Project type:
Unique identifier (TypeID (PK) Project type (Cti / Regular)
How might i design this the best way, so i can combine the people with the projects there on. And which type.
There can only be one person, but he can be on many projects. These projects can vary in type. My problem is ensuring there connected proberly.
Furthermore, once the basic design is made i need to make evaluations based on their performance if they are on the projecttype "Cti".
here i need 3 x this:
Evaluations:
Objective (range 0-4) Baseline reading (range 0-4) Midway reading (range 0-4) End reading (0-4) Success = Yes/NO (here i will do a End reading <= Objective formula).
That was a rather long list, but i have sat working on this in three whole days, and im getting a little fed up with not knowing up-and-down.
I have a form which contains fields from my main table and also has a subform containing a query based on a filtered list of my main table.
I have a combobox on the form to select a name and pass it to the query to filter on.
The list of names is in a table called tblnames which has 2 fields, name and ID. I have linked the ID field on this table to a field called nameid on my main table which is a numeric field (and that allows be to select a name from a list when I enter data into my main table.
The xox is unbound, control source empty and row source set to tblname.
The combobox is only showing a list of numbers (I assume they are the id field from tblname). Yesterday I had the list of names showing and I checked a backup and the only difference I can see is the row source property refers to the name field in tblname but I don't know how I got it there. When I click on the list box for row source I only get offered a list of my objects.
we have Oracle 11g as main database and for viewing purpose, we have created an mdb (Access 2007) using Link tables via ODBC connection (system DSN).While querying, count queries are working fine with accurate record counts but, all select queries are not working fine. It filters and displays with wrong records. There is no issue in query building.how to get correct records through odbc connection to Oracle database.
What I'm looking to do is calculate the success rate (%) of compliance rates with Quality Control paperwork. Essentially, each record has 12 "check box" fields representing the different QC sheets that are submitted each day.
I am trying to get the message Request added to show up when the new record command works.
The message "add button error" show if there are any errors, rather than just doing nothing and stopping.
However when it works I get both, I know I doing something very simple very wrong.
Private Sub bAddRecord_Click() On Error GoTo errorhandler RunCommand acCmdRecordsGoToNew MsgBox "Request added " On Error GoTo 0 errorhandler: MsgBox "add button error" End Sub
I have a listbox on a form that looks up a table to to allow me to pick a stock location. The table only has 2 colums in it, the Primary Key Field (ID) and the Store location. When using this in a a form instead of getting the Stores Location, all I get is the ID. I have tried changing the Bound Volumn Value and the Column Count Fields, however no change.
Using ms access 2010, I created a table called all items contains the ID, item name, item code, item price.
Second table I created called orders, contains item1,Q1=quantity,Tot1=calculated field.
Then a form to fill the orders table with a combo box for Q1 (gets the value from a table called numbers), second combo box for item1 (gets the value item code and item price from the table all items), and a text box to calculate the total of the Q1-item1(item price) All working perfect except the combo box for item1 ends up displaying a different item code that's only if the items were at the same price, for example, I choose latte from the combo box gives me correct item price but the code is cappuccino, only happening with items with the same price.
If I set the property of the combo box Bound Column to 1, I get correct item code but calculation error, Bound Column to 2, I get correct calculations but wrong item code. how to get the combo box to display the correct item code?
I have a vba code export a error message if the current date of a file is not correct.. I have tested the code it worked to send a error message to a error.txt file but he it doesn't look to the modified date
So instead of:
file1.txt (13-02-14) Then Send error message ("file not updated") to: Error.txt
IF NOT no action requeried
This code does the following :
file1.txt (Modified date: 13-02-14) Then Send error message ("file not updated") to: Error.txt
file2.txt (Modified date: 14-02-14) Then Send error message ("file not updated") to: Error.txt
Code: Sub CheckD() Dim FSO As Object: Set FSO = CreateObject("Scripting.FileSystemObject") Dim objFile As Object: Set objFile = FSO.GetFile("C:Users ameDocumentsShow5621.txt") If objFile.DateLastModified <> Date - 1 Then
[Code] .....
So also if it is the current date he send the error message to the error.txt file, it could be possible that i did something wrong.
In a query I would like to extract the last ten years. This is what the data looks like:12/13 (Data type = text)(Short for 2012/2013 which actually represents 7/1/2012 to 6/30/2013.)
I am able to extract the "12" and turn it into the general number 2012 using: ("20" & Left([TAXYR],2))*1..But how can I convert that to the data type-date so I can include those records in the past ten years from todays date? I was trying to use DateAdd but I think the problem is the data type and where converting to date gives me "1905" or "9/##/1905." I get why it does that, but is there a workaround? Maybe adding 39,785 days?? (2014-1905)*365
i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)
i just need a code that checks what the users level is and then open home lvl#
(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...
Hi, I have a networked DB and I can't update the FE because the LDB file is locked. It says there are about 8 users in the DB which I know isn't true (I keep a table of current users and I prevented any new people from logging on before I went home last night)
I've never had this happen before? Does anyone know how I can fix it and kill the connections/Delete the .ldb?
I'm sure I caused the problem cause I've just put a few weeks development into the live system but i'm not sure why. I know if I have left recordsets open this can keep the connection but are there other reasons why this may be happening?
I have recently converted an Access 97 database to Access 2003 and have noticed some records have been replaced with oriental symbols. I've noticed about 2 new corrupt records a month since it was converted. Does anyone know why this is happening and if the corrupt records can be recovered?
I have a database with backend tables. I came back to work today and somehow the main table in the backend has been corrupted. I tried to repair the table in the Backend and I get the following error Could not find field 'Description'..
Now when I try and open the Backend I get this error. The database 's:SOE_CONTROLSoeControlDatabaseBackendew_1-8T_SOE_DATABASE_be.mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsfot Access to attempt to repair the database?
When I click yes I also get [B]Could not find field 'Description'.[/]
Each time I have done this another DB1 or DB2 or DB3 or DB4 table has been created. When I look in the tables I can see that somehow there is a deleted record and it will not let me delete that record. I delete it and then open the table again and the same deleted record is still there.
I hope this is making sense because I sure need help!!
Hi all: Would appreciate any help that anyone can offer. Have a client with an Access2K database that gives the dreaded "...No read permissions on table MSysObjects..." error. I'm trying to just get the data into a new clean mdb but Access blocks me at every turn.
Have tried compact & Repair Have tried JetComp Have tried TransferDatabase via code No luck, can't get at the data.
Now here's the kicker, the database is the back end to a VB6 application. The application continues to run fine and is happily accessing and updating the database. Any suggestions about alternate ways to get the data into a new clean mdb would be much appreciated.
Let me start by saying that I do not claim to be an expert database developer. I own a small company. I'm good with Access, but from time to time, it gets the best of me.
I've been reading alot of the posts so please forgive me if this topic has been covered. I couldn't find a thread to help me with my problem.
I have a table called 'projects'. This table has an autonumber field (you know where this is going, huh?) that serves as the primary key for the table. I realize that this is a big no-no now. Please go easy on me... :-)
I have a form, also called 'projects'. This form has a comboBox that uses fields from the 'projects' table as its rowSource. The user (myself) selects a record from the comboBox and the afterUpdate finds the record in the table and bookmarks it. The corresponding fields on the form update. We all know the drill.
I'm calling any record entered prior to today, an 'old' record... ... anything from today is a 'new' record.
So now I can still pull up 'old' records, but not 'new' records. Even if I close the form and try to add it directly into the table, it's like access doesn't recognize it. It'll let me enter it, but I cannot pull it up via the comboBox.
My first instinct was to just copy the table (structure & data) into a new one and see if the problem goes away. Two things... the problem does not go away and it renumbers my primaray key and so even if the problem did go away it would give all of the related records in other tables new parents, leaving a few orphans. so much for no child left behind...
anyway, i tried copying the structure only into a new table. I manually added a record. I was able to pull it up using the form. I copied the 'old' records from the old table to the new table. I can pull up those... but now I can't pull up the record I entered manually. I imagine that I copied the corruption into the new table.
It's almost like that the table is corrupt in that it will not index new records properly. I'm not referring to my own indexing, I'm referring to something that I suspect microsoft has on the backside.
