Community
Showing results for 
Search instead for 
Do you mean 
Reply

Excel crashing when Accessing DB using OLEDB connection

New Member
Posts: 35
Country: UK

Excel crashing when Accessing DB using OLEDB connection

I have a problem trying to access tot he ACT DB using the OLEDB through excel.

I can connect and see the list of tables. When i then select 1 and then choose whether to duisplay the data in a cell or a new worksheet excel just restarts with a message saying error encountered.

I've updated MDAC but still no joy.

I'm getting this problem on both machines that i'm trying out. One is a client XP machine and the other is a 2003 server. Both with Office 2003 installed on them.

 

Any ideas what it could be or at least how to diagnose further.

 

THanks

Hummy

New Member
Posts: 35
Country: UK

Re: Excel crashing when Accessing DB using OLEDB connection

Just some further information the exception seems to be thrown in the ACTOLEDB.DLL according to Excel.

Probably no use knowing that and probably also stating the obvious but thought i'd mention it anyway.

Bronze Elite Contributor
Posts: 2,115
Country: United_Kingdom

Re: Excel crashing when Accessing DB using OLEDB connection

Hi Hummy,

 

Have you tried connecting to the ActDemo dB? Another thing to also do is carryout a repair on the Act Ole Db Object via ActDiag and then try again.

 

HTH

Vivek

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog
New Member
Posts: 35
Country: UK

Re: Excel crashing when Accessing DB using OLEDB connection

I've performed a Repair and detect in Excel 2003.

I've also tried the repair OLE DB objects via ActDiag.

I will try the ActDFemo Db, but what is the default username and password for that database.

 

Thanks

Bronze Elite Contributor
Posts: 2,115
Country: United_Kingdom

Re: Excel crashing when Accessing DB using OLEDB connection

Username: Chris huffman

 

 

There is no password.

 

Vivek

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog
New Member
Posts: 35
Country: UK

Re: Excel crashing when Accessing DB using OLEDB connection

That's interesting. Trying to import data using the Demo database works fine.

 

Any ideas what it could mean then. Is it perhaps the number of records that it its fetching (roughly 6000).

 

I've noticed having registerd the ACTOLEDB.DLL the faulting module is now NTDLL.DLL.

 

 

New Member
Posts: 6
Country: USA

Re: Excel crashing when Accessing DB using OLEDB connection

I'm experiencing the same problem, have you resolved this issue in any way?

 

Ryan

New Member
Posts: 6
Country: USA

Re: Excel crashing when Accessing DB using OLEDB connection

 

Excel Stops Crashing for me when I specify New Worksheet when It asks Where do you want to put the data.  Hope this helps.

Copper Contributor
Posts: 11
Country: United States

Re: Excel crashing when Accessing DB using OLEDB connection

That fixed it for me too!


Sounds like a problem for Microsoft to fix.

Copper Contributor
Posts: 11
Country: United States

Re: Excel crashing when Accessing DB using OLEDB connection

Scratch that. It's just inconsistently failing now.