"Error "field name already exists in the table Query1 (3308) when exporting to .DBF.
the name of the fields in a .dbf file must be 10 char maximum. Maybe the name of your objects are longer than this, when this occur BO Truncate the name at the number 10 character. So two different objects like: “Revenue per Country” and “Revenue per City”, looks like “Revenue pe”, so when Bo tries to create two fields with the same name, fails. Try to change the name of your objects.
We have a group of users who want to take their data into MS Access, they wanted to use the “export to RDBMS” option, but we are trying to avoid allowing any users to create personal connections. As an alternative I suggested they export to a file (.dbf) and then they could open up directly in Access. Problem is the export errors out because several of the objects have the same first 10 characters. I know changing object names is one option, but as I mentioned several of the objects would need to be changed and I am try to avoid this. Any other suggestions. - thx
I did suggest saving as a .txt or .csv but then you have to go through the wizard to open it up and apparently this is not seamless enough for them.
Andreas, I am not sure what they are trying to do. I did ask but did not get a straight answer other than how important it is to “streamline the process” and get this data into Access with all their other data (BO portion of this process to be run daily). This is one of those projects where they are trying to side step the IS dept. and have brought in outside consultants. And although, they are officially not going through our Department I sure have been getting a lot of calls/emails about this.
Irregardless of the project or purpose, I am trying to provide them with a viable solution. The .dbf thing threw me for loop, I tested it and everything looked good until they sent me their query it errored out. I hate it when my suggestions don’t work.
Truth of the matter is, there is probably a consultant over there telling them all the magic he/she can do in Access; however, I do believe they are pulling data from several sources and using Access as a central repository for the data.
Sorry… I probably provided a lot more info than you wanted to know, but I could go on and on…
Sounds like a good ideal, problem is they have not submitted a project request, which they have been asked to do on multiple occassions (when it was determined that they would need the assistance of IS dept), and I can not allocate my time until they do so.
Is it possible to do more with joins and SQL in Access? Can you fill in non-existent data fields in Access vs. BO? I haven’t researched this much so I was just inquiring.
This is a very timely topic. I have a meeting this afternoon to visit a potentially hostile group of MS Access users. We are deploying BusObj as the reporting tool of choice for a rather unstructured database. The former tool was very limited in its capabilities, and in some cases MS Access has been used to compensate for those limitations. It was unsupported of course, but not difficult for a semi-knowledgeable user since they have their own Oracle ID. Well, with BusObj individual users do not (in our deployment) have their own Oracle ID, and our ultimate “stick” to convert from the old tool to BusObj is to turn off the Oracle ID, which won’t be popular with the MS Access users.
My approach of course is to show that the reporting can be done with BusObj, and that it will be a supported tool (help desk and so forth). My questions for the group will be to ascertain if there are legitimate reporting needs that BusObj can’t meet (unlikely), or if there are other processes in MS Access (like data entry / transformation) for which BusObj is not designed. To say the least, it should be an interesting meeting