Aliev
asked on
Problem with ADO
Hi, i have problem with ADO. I created in MS Access 2002 database and one table(Table1) in it. And added it to ODBC under name "bd". And in Delphi i created ADOConnection, ADOTable . ADOConnection.connectionst ring works and i am sure that correctly. When i press Test Connection writes "Test Connection succeded". In ADOTable1.TableName i select from list Table1. When i makes ADOTable1.Active true then gives error: "[Microsoft][ODBC Microsoft Access Driver] The microsoft Jet Database engine could not find the object 'name'. Make sure the object exists and that you spell name and the path name correctly." . What i must do?
But in other user accounts in my Windows works well. On my account not works...
Thanks.
But in other user accounts in my Windows works well. On my account not works...
Thanks.
if you use an adotable,
then set the tabledirect-property to true,
then no structure changes are needed
meikl ;-)
then set the tabledirect-property to true,
then no structure changes are needed
meikl ;-)
ASKER
Now gives error "[Microsoft][ODBC Microsoft Access Driver] The microsoft Jet Database engine could not find the object 'aname'. Make sure the object exists and that you spell name and the path name correctly."
What i must do?
What i must do?
use my second advice (struggled also over this, sorry)
>set the tabledirect-property to true
meikl ;-)
>set the tabledirect-property to true
meikl ;-)
ASKER
I tryed that. Gives same error again. But on other account (on Windows) works well.
? mysterious
ASKER
Now i tried with Paradox table. Gives error "[Microsoft][ODBC Paradox] Invalid argument";
will do some tests tomorrow, too
ASKER
Thank you
ASKER
I think it is problem of Windows
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mdac update? How i can do it?
sorry, above includes only sql-server driver
select here
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
meikl ;-)
select here
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
meikl ;-)
hi,
if you use ADO components from the Component Pallete you will not use the last version of ADO. Instead, you'll use the one which is implemented by Delphi (2.5 I suppose).
to use the last version, after you install it, you'll have to import the type library to use it.
Bogdan
if you use ADO components from the Component Pallete you will not use the last version of ADO. Instead, you'll use the one which is implemented by Delphi (2.5 I suppose).
to use the last version, after you install it, you'll have to import the type library to use it.
Bogdan
now I've seen,
you don't have to use ODBC if you are working with ADO.
for the ADOConnection, set the LoginPrompt to False.
you don't have to use ODBC if you are working with ADO.
for the ADOConnection, set the LoginPrompt to False.
ASKER
I updated the mdac and works well. And it installed new providers. Thanks, kretzschmar ...
rename the field name in aname or lastname or familyname, etc
meikl ;-)