We help IT Professionals succeed at work.

Problem with ADO

Aliev
Aliev asked
on
277 Views
Last Modified: 2013-11-23
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.connectionstring 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.
Comment
Watch Question

Top Expert 2004

Commented:
name is a reserved word,
rename the field name in aname or lastname or familyname, etc

meikl ;-)
Top Expert 2004

Commented:
if you use an adotable,
then set the tabledirect-property to true,
then no structure changes are needed

meikl ;-)

Author

Commented:
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?
Top Expert 2004

Commented:
use my second advice (struggled also over this, sorry)
>set the tabledirect-property to true

meikl ;-)

Author

Commented:
I tryed that. Gives same error again. But on other account (on Windows) works well.
Top Expert 2004

Commented:
? mysterious

Author

Commented:
Now i tried with Paradox table. Gives error "[Microsoft][ODBC Paradox] Invalid argument";
Top Expert 2004

Commented:
will do some tests tomorrow, too

Author

Commented:
Thank you

Author

Commented:
I think it is problem of Windows
Top Expert 2004
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
mdac update? How i can do it?
Top Expert 2004

Commented:
Top Expert 2004

Commented:
sorry, above includes only sql-server driver

select here
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en

meikl ;-)

Commented:
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

Commented:
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.

Author

Commented:
I updated the mdac and works well. And it installed new providers. Thanks, kretzschmar ...

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.