Search results

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...

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...

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...

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...

We are using a simple C# program to cleanup and then import 100,000 records into a access table. Import time is pathetic, takes over 10 minutes, the same data into sql server takes 1:45. we are using oledb, and run a simple insert into. we basically open the database, create a sgl cmd, prepare...

when I go to modules and right click on one and select design view I get a dialog Microsoft Access has encountered a problem and needs to close..... The data base is on a network share, if I copy the database to a local folder on my machine, I don't see the error dialog, however the...