Ask you a question

I made of pb6.5 and sqlserver2000 procedures, implementation will access database tables in the imported into the sqlserver2000, using method is in the script
Invokes the SELECT * INTO newtable FROM OPENDATASOURCE (' Microsoft. Jet. The OLEDB. 4.0 ', 'Data Source="c: \ DB. MDB"; User ID=Admin; Password=') the name of the table statement, function realize there is no problem, but if import the MDB in the table, import the DB again. The table in the MDB, i.e. repeat. Import the DB table, in the MDB will appear error
51 "sqldumpexceptionhandler: process happened serious abnormal c0000005 EXCEPTION_ACCESS_VIOLATION, SQL Server will terminate the process,"

. But if I import the DB MDB in the table, I choose to import another DB2 database. The table in the MDB, no problem, and finish the import the MDB
In the table, and then to import the DB. The MDB in the table, and the error message will appear,

The results I found can't repeat the import table in an access database, also please help me solve the, thank you!

CodePudding user response:

Can be done with data pipeline

CodePudding user response:

But I use pb connection kingdee encrypted ais (actual access) database, there is always a problem, so no data pipeline,
Or please advice, thank you

CodePudding user response:

.
Not yet tried.

Try to switch to system data import/import tool.

CodePudding user response:

Import and export tools, no problem, but I want to make the program, so I can import at any time want to import kingdee data of each unit,

Handheld device maker e-ten audit software, I was doing to solve other financial accounting software data import to essentially a problem, hope to have this experience programming friends advice, thank you.

CodePudding user response:

If the primary key you want to update, insert operations of a primary key does not exist, it must be, can't select all, and into

CodePudding user response:

Can only bit by bit guide, too much is not

CodePudding user response:

Have a new answer

CodePudding user response:

"If the primary key you want to update, insert operations of a primary key does not exist"

Xyz_77 thank you, could you explain it in detail, the update operation what ah