?
Solved

Table names

Posted on 2002-05-06
4
Medium Priority
?
167 Views
Last Modified: 2010-04-04
Hi

I've inherited an Access database in which someone named one of the table transaction.

Does anyone know how to update this table using the standard delphi6 ADO components.

I'm not able to rename the table as there's a lot of apps that uses it.

Thanx
 Fick
0
Comment
Question by:jfvd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
Stuart_Johnson earned 300 total points
ID: 6992418
Hi Fick,

If you're dowing it within a TADOQuery, try using inverted comas around the table name:

select * from "transaction"

Cheers,

Stuart.
0
 

Author Comment

by:jfvd
ID: 6994303
Thanx for making me think a bit

I tried the inverted commas without success but if you use square brackets everything seems to be going fine.

Thanx
 Fick
0
 
LVL 6

Expert Comment

by:Stuart_Johnson
ID: 6995102
Hi Fick,

I'm a little curious as to why you only graded that question with a 'B'.  Didn't the answer work perfectly for you?  It doesn't cost you any more to award an A than a B and it keeps my awarded grade history perfect.

Stu
0
 

Author Comment

by:jfvd
ID: 6995117
Stu

The inverted comas didn't work ... I got some kinda error when I tried that so I looked at access again and tried '[' which worked.

Sorry just trying to be honest. If I can I'll change.

Fick
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question