Re: time delay in appending table to catalog

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • Word2003 and E-mail Merge
    ... I'm using an Access Database to merge about 600 e-mails. ... When I go to "Merge to E-mail", I can send fine as plain ... text, but everytime I try to send as HTML, nothing ... I want to spruce up my e-mail lists... ...
    (microsoft.public.outlook.general)
  • eror 1919
    ... everytime I try to install microsoft office 2000 premium ... it gives me a error message "1919".error configuring obdc ... file ms access database exists and that you can access it. ... Now everytime I try to open a program a microsoft ...
    (microsoft.public.windowsxp.general)
  • Word2003 and HTML E-mail Merge
    ... I'm using an Access Database to merge about 600 e-mails. ... When I go to "Merge to E-mail", I can send fine as plain ... text, but everytime I try to send as HTML, nothing ... I want to spruce up my e-mail lists... ...
    (microsoft.public.word.mailmerge.fields)
  • How to write a bool datatype in a access DB?
    ... I am trying to write a bool in an Access Database, ... problem everytime... ... Georg ...
    (microsoft.public.dotnet.framework.aspnet)