I'm trying to set up a saved import, but keep getting the following error message: "You cannot record your changes because a value entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again"
There are a couple hundred fields, and they are all set to text. Is there a way to figure out where the problem is occurring without going through all fields?
Is there any way to view a Saved Import to see what it is doing?
I just inherited a database from someone that has several saved imports. I need to be able to see where the data is coming from and where it is going to so that I can recreate it using VBA.
I have split database (B/E is in the SharePoint library, F/E has users on a local PCs). Sometimes, when I update/add data (does not matter if it is via form or directly in the table) it looks OK, but when I re-open the database, the data are gone.
Problem is that I cannot catch the moment when data were not saved (sometimes data are saved, sometimes not). I can point out this: if I re-enter the missing data, primary key continues subsequently, it looks like the data have never been entered. I tried to use script
Code: If Me.Dirty Then Me.Dirty = False
on "On Close" form event, does not work.
B/E is linked by VBA code and it looks OK (no error, Link Manager shows correct path). I suspect interrupted connetion to the SharePoint but I don't know how to check it. I implemented VBA script co keep open connection to the SP but the issue persists.
i have 4 supplier tables with identical field names but different databases in sql.I want to have them all in one table and only want the information for reference i do not want to edit any of the data.I need to create a new primary key number for the complete table. The data will need to be refreshed as the data comes from MMS Sage looking at company PLsuppliers.
I have tried a linked SQL union view- but this has no primary key.I need to keep the Primary key consistent as the data saved in other tables will use this field.The overall goal is creating a Purchase order system and this list will be my complete supplier list.
The user wants to be able to click a product desription in an access table, and a picture of the product pops up. is this possible and if not, what is best way to implement this functionality?
I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables....
How to confirm when the user clicks save that the data is actually being saved in the backend tables.
I want to make a database of diseases (need to learn them for school and would like a serchable database on my smart phone for future reference). Unfortunately spent a lot of time making hundreds of pages of word tables before i realized a database would be better. See attached image or pdf. Is there a way to import the tables to Access?
I need to preserve the hierarchic info in the nested bullet point lists. E.g. under treatment i might have a point called Acute treatment, with sub-levels, Step 1, Step 2, etc. with their own sub-levels. I need to maintain this relational hierarchic info.
I created a form with subforms that are all linked to their own tables. Values that are entered in to the form (i.e. just numbers or names) all save into the tables as I would expect; HOWEVER, all of my value lists (0,1,2 or 1-5) do not. I can change the values in the forms and as long as I am toggling between them they appear in the form but they are not populating the tables.
Other details. They are defined as numbers in the property table, I did change them to a value list in the form properties and did assign values to the property list.
I looked through some other threads that seemed similar but the solutions didn't apply. Because the straight up data entry saves, I feel like it is something specific to me creating those value lists...
I am trying to create a saved export on a table i have. However i want to filter so when i do the saved export it exports the table with the filtered result only.However when i filter my table and export it and save the export. The first export comes out with the filtered results but when i go to my list of saved exports and export it again, it doesnt come filtered and its just an export of the whole table.
I know this has been asked a few times before, and I did search it, but could not find an adequate answer.
I want to use code (VBA) to import tables from a different Access database into the current one, by first deleting the current database tables, and then importing the new tables from the other database. I found code in the following thread that does exactly this:
However, the code in this example only appears to delete tables in the current database that have no relationships with each other before importing the outside tables. My tables, however, are rife with relationships and when i run this code, i get the message, "You cannot delete the table "tblWhatever", it is participating in one or more relationships." Can someone give me a pointer or two about how I can solve this problem (if at all) ?
is there *any* way to lock down a db so that a user can't import your tables and queries? i know an .mde prevents the importing of forms, but i don't want ANYTHING to be able to be exported. i'm thinking this may not be possible.
when i run this function i get an error : "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database"
when i try to import in the same way a dbf file (insted the csv file) with VFP it's working well.
what seems to be the problem? how can i fix it? or if some one know how can i import a large csv file into access DB in an efficient diffrent way?
hi i have an application that has to import data from paradox tables and create reports based on those tables. I am using Access 2003 and the paradox database is 4.0 . I know how to import a batch of files from code but my problem is that the paradox database has some tables that are split in different folders according to the month they were recorded (it's an accounting program ) so a table exists with the same name in each month folder and the problem is that they have id's starting from 0 each month so I cannot append them easily I do not know how many tables that type I will need so I have to keep track of them through a different table so I cannot create individual queries for them.
Having searched the last couple of days, I am unable to find a resolution to this problem. If it has been answered already, a simply link or thread name would be appreciated. If not, help is greatly appreciated.
I have code running that imports data from a .txt file into a table.however, on some days there will be errors importing some of the data. I have found that from the last three months, there has been no data of consequence lost so, I don't care about the data errors. However, any time there is an error with the import it creates a table that is named for example:
01-03-05 Auth_ImportErrors
where "01-03-05 Auth" is the name of the file imported. So each time they import a file, a new table is created. Is there any code that I can run that can automatically delete these tables upon exit?
I need to import the tables from a secure database into a new database, is there any way to keep the table permissions that are set in the secure database, they seem to be lost in the import.
I routinely import from an Excel document provided by a third party. Most data in it is ok, but 10-15 records always end up in the import error tables which Access creates automatically when formats do not match. I am trying to automate this whole process thru VBA and am pretty successful so far, except that I haven't figured out how to programatically get rid of these tables (I do not need them, and data imports anyway). Is there a way to destroy a table programatically in Access?
I have a production machine that writes its output to a CSV file every time it produces a good part (several times pr. day). It can produce identical part which means that the mashine will not put in another line in the csv, but just update the no of produced parts. I had to rename the attached file because you can not uploade *.csv files in the forum.
What I want is:
- When someone opens a specific Access db a tabel in the db is updated with all new data from the csv file.
My problem is: How do I make sure that I only get the new data from the Access db.
I want too import data from excel, this data is test results and contains the students names as well as the answers to the questions.
Currently my import looks like this: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Resultyear", "C:UsersjesseDesktop est-7-2015.xls", True, "Worksheet!A11:AV32"
However is it possible to import 2 lots of data ranges from the one import? as in can I have "Worksheet!A11:C32" + "W11:AA32"?
I am building a horse racing based database, two of my tables being Courses (details of each track) and Races (Type of race, where run, prize money etc). In my Courses table I have CourseID (autonumber, key) and CourseName (text, max 25). The longest name in the list is 19 characters.
In my Races table, I have CourseID set up as a lookup, related to CourseName in the Courses table. This works fine if I type the CourseName in manually, or select it from the drop-down list.
My problem arises when I import it via excel, when the whole CourseID column is deleted, as not the correct data type. I have tried formatting the CourseID column in excel as text, general, and even number prior ti importing, all to no avail. How should I format this column in excel?
I have 2,000 access databases that are structured the same way. I want to import and compile 1 of the tables from the databases into excel. I have a macro written that does this no problem, but I just realized it is not importing Number fields with field size of "Replication ID". This is critical to eventual be able to do the analysis I am looking to do. Is there any way to have excel import the Replication ID?
I am trying to run a report based off Data I dump into Excel from a Database I use for Property management. Once I have dumped this data I amend it for reporting purposes. The issue I am having is this data constanly gets updated and every time I dump new data it obviously overrides all the changes I had made. How can I set up access to know what data I have already imported, keep it and only add NEW data from excel? To make a little more sense in Excell Colum A is Work Order Number, B is property address, C is Works to be done. I alter the works to be done when first dump it as it requires more info and updating. I need Acess to only import new Work order numbers that are not already there and leave any changes I have made to other colums as the report will continue to evolve.
I had created a database a number of months back and received.After getting halfway through and seeing some requests come through from management on what they want to see or improvements, it looks as though there will have to be some retooling done to the database like moving some fields to different tables as there is duplicate entry fields.Would you import all the tables into a new database and then append the data to where it needs to go or keep working within the one I have?
All, using access 2010 but working on a 2003 database. Trying to import a table from another database. I made a copy of a database im trying to import from a database on a production server and placed it in my development folder. When I go to import the table; it throw an error:Reserved error (-1524); there is no message for this error.why I can't import a table especially if no one is using it?