Search results for query: *

I have a VB app that hits MS SQL Server data via DAO-JetWorkSpace-ODBC. I encountered the following error on Update statement: Run-time error '3197': The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. The...

Thank you for your response

I encountered this very strange problem on my laptop. Environment: Visual Basic 6 SP4 DAO 3.6 Microsoft Jet 4.0 SP6 Microsoft SQL Server 7 SP3 Desktop version Window 98 Second edition Purpose: Update SQL server data via DAO/ODBC/JetWorkSpace Code: Dim engTest As DBEngine Dim wksTest As...

I encountered this very strange problem on my laptop. Environment: Visual Basic 6 SP4 DAO 3.6 Microsoft Jet 4.0 SP6 Microsoft SQL Server 7 SP3 Desktop version Window 98 Second edition Purpose: Update SQL server data via DAO/ODBC/JetWorkSpace Code: Dim engTest As DBEngine Dim wksTest As...

I am completely new to Paradox. I am not sure the exact version of the data, only know it is Paradox version 5.x or below. First I tried ODBC, but got an error saying that I can not use Jet Engine to access an ISAM source. If you know how to use ODBC, please give me a sample statement Dim...

Thanks, Terry. I only want to get rid of them to allow the thirty party program to run. That is just one time deal. Youdao

I have a thirt-party program that can compare two database schema for a commercial ERM software. However, those hypothetical index starting with _WA_Sys_ are causing problem for the program. I was able to delete those index one by one and table by table. Is there a better way to delete all the...