Re: Access 2000 with ADOTable error - Unspecified error

Sorry,

is the table name called 'session' a key word in Delphi?
Actually the table name is called 'session'.

"Alan T" <alanNOSPAMpltse@xxxxxxxxxxxx> wrote in message
news:478c0f0e$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I found the problem but not the solution:
Now this was what I did:
The table has problem eg. 'employee'.
Make a copy inside MS Access as 'copy of employee',
Rename the original 'employee' as employee_old',
Rename the 'copy of employee' as 'employee'.

Now open the TADOTable again, got the same 'Unspecified error'.
Then TADOTable points to the 'employee_old', open the table component
without problem.

So it seems if the table name is 'employee' will have problem.



"Alan T" <alanNOSPAMpltse@xxxxxxxxxxxx> wrote in message
news:478bedf7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
D7.
Tried to display Access 2000 table.
I used the ConnectionString wizard to build the connection string to a
Access 2000 database for TADOConnection. Test connection is OK.

Then link TADOTable and TADOQuery to this TADOConnection.
Define the SQL and the table name for the components. Then set the
Active
to
TRUE of the TADOTable, but got the error 'Unspecified error", it also
happened to the TADOQuery.

The OLE DB Provider I used was:
Microsoft Jet 4.0 OLE DB Provider.
I don't understand why the connection string was so long:
"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=C:\database\test.mdb;Mode=ReadWrite;Extended Properties="";Jet
OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database
Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking
Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
OLEDB:New Database Password="";Jet OLEDB:Create System
Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False"

I tried to trim down:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\database\test.mdb;Persist
Security Info=False"

But once I set the Active to TRUE, the TADOConnection connection string
returned back to
"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=C:\database\test.mdb;Mode=ReadWrite;Extended Properties="";Jet
OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database
Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking
Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
OLEDB:New Database Password="";Jet OLEDB:Create System
Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False"

Any idea?






.

Relevant Pages

  • Re: Access 2000 with ADOTable error - Unspecified error
    ... Make a copy inside MS Access as 'copy of employee', ... Then link TADOTable and TADOQuery to this TADOConnection. ... Microsoft Jet 4.0 OLE DB Provider. ... I don't understand why the connection string was so long: ...
    (borland.public.delphi.database.ado)
  • Access 2000 with ADOTable error - Unspecified error
    ... Tried to display Access 2000 table. ... Then link TADOTable and TADOQuery to this TADOConnection. ... Microsoft Jet 4.0 OLE DB Provider. ... I don't understand why the connection string was so long: ...
    (borland.public.delphi.database.ado)
  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)
  • Re: Replacement for Jet provider in application for XP Embedded
    ... provider and I've read that XP Embedded does not use the Jet engine. ... I would insure having system admin rights, and install MDAC 2.8. ... Next i'd review the programs connection string to insure it's using the ...
    (microsoft.public.vb.database)
  • Re: Weird TADOConnection Behavior
    ... We have a TADOConnection that connects to MSSQL 2000 in our ... The connection string is very much the same except for the ... And that the database assigned in the connection string is ... Databases offline and tried running the application ...
    (borland.public.delphi.database.ado)