Re: time delay in appending table to catalog
- From: JackChiou <JackChiou@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Nov 2006 17:09:00 -0800
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.
- References:
- Re: time delay in appending table to catalog
- From: Bob Barrows [MVP]
- Re: time delay in appending table to catalog
- Prev by Date: Re: time delay in appending table to catalog
- Next by Date: Connect to XLS through ADO - Field names not coming through
- Previous by thread: Re: time delay in appending table to catalog
- Next by thread: Connect to XLS through ADO - Field names not coming through
- Index(es):
Relevant Pages
|
