Recent content by toddbailey

OK, thanks. I just needed to make sure that this wasn't some funky bug that MS never bother to fix. I agree taht suppressing error messages is not the best solution but there are times when you have no choice... anyway, I continue my efforts on isolating what's causing this...

Hi All, After several years in production with out this error, the users are now getting an error dialog when they close a form. There are 2 forms that interact, a switchboard that has a couple of command buttons (docmd.openform for example) when the user clicks the button the switch...

Actually, SS has powerful component called SSIS, I was able to import the data and re direct the Access FE to use the SS de instead of the Access back end with a day and 1/2 of code development. It wasn't very well tuned but out of the box it was noticeably more responsive. Once triggers...

The application isn't buggy, the OWC is. Please re read original post. Also the application uses mostly bound subforms... Obviously you don't have much experience with large scale data base applications. I'm talking tera bytes. The application I'm supporting has over 500 forms, mainly...

Thanks for the response. I found the problem, MS quit supporting this several years ago. The issue I am facing is well documented and has no usable fix. I've moved on to using a datagrid control that supports .net and access 20xx and unlike the MS product is well documented. Let this be a...

Hello, We are thinking about converting a fairly large Access application to Sql Server for data store and Visual Studio to develop the user interface. Are any of the forms and code modules reusable or is this a complete rewrite? put another way, can I import forms and code modules into VS...

Hey, MS has cancelled support of the OWC 11 controls, current implementation is quite buggy. can someone suggest a suitable replacment data grid control? (cheap or free = good) Sub forms are not an option, the organization is trying to eliminate the 200 plus subforms that emulate a...

Hey All, I'm using the OWC spreadsheet control on an Access form, on 5 machines no problems, but on one XP machine when I open the form the control shows up blank. when I open the form to edit on the suspect machine I get a strange error, object is missing. I re-downloaded and restalled the...

This is why I was inquiring if Access had a means of stored procedures, the closest I've found is stored queries. In my case they don't provide much added value, as there is a lot of cost calculations and conditional processing being done. If access provided stored procedure capability OR if I...

I knew this to be true back on the good old days of access 2000 and older but had hoped that maybe MS had enhanced Access to provide a client/server model with perhaps the purchase & installation of an add on package. Since this is not the case, the only option is to have a current copy of the...

Hi All, Is there a way to emulate a stored procedure in a excel to access link? allow me to expand on this: I have a excel sheet with vb/a code that does a lot of data processing and causes a lot of network traffic due to the volume of data being processed, once the datasets are ready, 1/2 a...

Correct, C#, VB, C, Java or any other programming language was needed to implement the import. A lot of conditional tasks were needed to clean up the data and automate for weekly update. the bottom line is importing a data file into an access database.

Hi All I wrote a simple import tool that imports 60K records into an Access data base. It basically reads a line from a text file, creates an insert statement, executes the insert and repeats. If I open a connection 1 time and try to populate all 60K records using 1 connection, the process...

could you post a code sample on how you create the record set and execute the update?

Interesting concept, but in this case I still need to import the data physically into the database