Re: time delay in appending table to catalog

OMG, it works, I have to conn.BeginTrans(), conn.CommitTrans() and also
RefreshCache(conn) in order to sync between the two connections.

THANK YOU Bob for helping me again, you are the man.

"Bob Barrows [MVP]" wrote:

You could be running into the Jet delayed-write behavior. See here how
to mitigate this:

http://support.microsoft.com/?kbid=240317
http://support.microsoft.com/kb/200300

JackChiou wrote:
sigh.. After three days I'm still can't figure out why it takes such
long time to create a table.

everytime when I use ADOX to create a new table, I need to wait 5 sec
in order to perform any ADO data insertion.

There are only 8 columns in the table, why take such long time to
create it? is it normal or is there anything I should do to speed it
up?

I am using Visual Studio 2005 Debug mode, not sure if this matter
though.


"JackChiou" wrote:

Hi guys,

I'm in the middle of migrate all the DAO code to ADO, it should be a
easy job until I ran into couple problems and got stuck :(

Everytime when I try to append a table to an access database, the
program will need a 5 sec break. Then I can start to insert data
into that table without showing any error message.

For example:
1. Create a .mdb file with ADOX.Catalog.
2. append a table to this database:
Catalog->Tables->Append(_variant_t((IDispatch *) m_pTable);
3. !!!! wait 5 sec. !!!!
4. Insert data into the table:
connection->Execute("INSERT INTO Part(text1, text2, ....) VALUES
('1', '2', ...);", &Records, adExecuteNoRecords);

if I execute the SQL statment and insert stuff to that table "right
after" creating the table, it will shows:
error code = 80040e37
Description = Could not find output table 'Part'.

It looks absolutely weird to me since there are only 8 columns (all
adVarWChar) in that table and shouldn't take that long to create it!!

I'm using Visual C++ 2005 with access database.
any help will be appreciated!! Thanks!

-Jack

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.

Relevant Pages

  • Re: Error! Not a valid result for table.
    ... date from an Access database and displays it in my document. ... The result of a database field is a table. ... would show this error message if you tried inserting this field into a table ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: Accessing subforms in a library database...
    ... libraries are supposed to provide a ... money) to get MSFT interaction. ... or a .NET Framework to interface with the data in the Access database. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.office.developer.automation)
  • Problem Connecting To Access Database
    ... an Access database. ... All of the apps were working fine on the web server. ... the same error message for all of them. ... RaisePostBackEvent(String eventArgument) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Determine Data Source
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... Applications/Office 2003 Applications/Microsoft Office Word 2003 ... When I click the 'Open Data Source' command button on the Mail Merge ... there any way to determine which Access database the Word document is ...
    (microsoft.public.word.mailmerge.fields)
  • Re: how do i find 50s theme?
    ... Tabledesigns, ... You have posted this message to the wrong newsgroup. ... Access database table design. ... I do not reply to personal e-mail ...
    (microsoft.public.access.tablesdbdesign)