Recent content by sdillard

Thanks. When I ran the tests I was able to set up a datalink with ODBC but not with Jet. Received an error message saying "Test connection failed because of an error initializing provider. Unrecognized database format." The ODBC Administrator test worked fine.

Well, I uninstalled and reinstalled Office 2000 but that didn't fix the problem. On the Microsoft support site it says that you can't uninstall MDAC from an XP installation because it is part of the XP load. I am going to check with our PC guys and find out how he loaded XP (it may have been...

I am suspecting that I have some corrupted jet or ADO files? If I uninstall Access, and then reinstall it, will the files be replaced?

I used the code you provided and I did it two ways. The first try I left the dbName = "". The second try I entered the full path to the db. On the first try I received the Class not registered error. On the second try, I received the "Provider cannot be found. It may not be...

I figured out how to change it to 2.6 but that didn't fix the problem.

Something I noticed is that my ADO lib is 2.1. How do I get 2.6.

Nothing shows up as missing in the references. In the past, I haven't used a Set statement. Here is my Dim statement; Dim rs As New ADODB.Recordset I have never had a problem with this before switching machines and operating systems. While trying to figure out what might be wrong, I did...

Yes. It is there but not selected. I selected it and tried to run the function, but it still go the same message.

I use Access 2000. I recently moved my databases to a new PC running Win XP from my old one running Win 2000. Win I try to run my VBA modules on the new PC, I get a "Class Not Registered" error on the following step: rs.Open "[Table_Agent]", CurrentProject.Connection...

I am using Access 2000 with a single user database under Win 2000. I have a VB module that performs updates on several tables. On one particular table, I am getting the following error: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." How do I increase...

I am working on an application in which I link to data from a MS SQL database in order to create an extract of the data on my PC. The data I am pulling down is collected in different time zones so I need to recalculate the date time to make sure they are all in sync. However, after I...

I am attempting to write a multi-threaded app. When I try to create an instance, I am getting an error. My question is, can the appname.objecttype portion of the CreateObject statement be anything I want them to be? Thanks

I located the code that uses the WaitForSingleObject. I incorporated this into my application and it works fine for starting the shell. However, I need to be able to start my shell, let control go back to my VB app, and then at a later time go back to the shell and close it. My problem is...

I am trying to start another application as a shell app within my VB application. Is there a way I can temporarily stop my VB application until the shell completes execution? It seems to compete with my VB app for CPU resources and therefore runs very slow and unpredictably. Thanks

The ActiveX controls only allow file transfers and such as Roger mentions above. The remote control sessions need to be initiated and stopped automatically (elsewhere in my application) and there won't be anyone there to manually start and stop the application. Thanks