MSAccess

Thread View: borland.public.cppbuilder.database.ado

10 messages

[T] Back to Threads [V] Tree View [G] Group Articles

10 total messages Started by Don Tue, 03 Jul 2007 22:19

#221

Author: Don
Date: Tue, 03 Jul 2007 22:19

8 lines
1312 bytes

I'm attempting to use the dbGo components to access a MSAccess database.
I can setup the ADOConnection & it says that the connection is good. I
then drop an ADOTable component & set the connection to the
ADOConnection.  When I attempt make it active, it complains about the
tablename not being set.  I don't find tablename anywhere in the object
inspector.  Where is it? Or am I not understanding how to use these
components?
Don

Re: MSAccess

#222

Author: Don
Date: Tue, 03 Jul 2007 22:22

5 lines
1211 bytes

I added TableName=Customer to the connectionstring & I don't get 
complaints about the tablename anymore.  I'm now getting a message 
saying "Could not find installable ISAM". Not sure where to go now. Any 
ideas?
Don

Re: MSAccess

#223

Author: Vassiliev V. V.
Date: Wed, 04 Jul 2007 07:10

29 lines
2143 bytes

Connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourfile.mdb

TableName is property of TADOTable.

It is better to use TADODataSet with client-side cursor and add where clause 
to SQL command to retrieve only rows you need.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Don" <dgnospamlocke@comcast.net> ???????/???????? ? ???????? ?????????: 
news:468acb73$1@newsgroups.borland.com...
> I'm attempting to use the dbGo components to access a MSAccess database.
> I can setup the ADOConnection & it says that the connection is good. I
> then drop an ADOTable component & set the connection to the
> ADOConnection.  When I attempt make it active, it complains about the
> tablename not being set.  I don't find tablename anywhere in the object
> inspector.  Where is it? Or am I not understanding how to use these
> components?
> Don

Re: MSAccess

#224

Author: Don
Date: Wed, 04 Jul 2007 12:23

7 lines
1383 bytes

Thanks for the reply.  But you didn't say where to find the table name. 
    It doesn't appear in the object inspector. So I put it into the 
connection string. Now it doesn't complain about the table name. But I'm 
getting an error message saying "Could not find installable ISAM". I 
need to look at all of the records as I'm converting the data from MS 
Access to Advantage.
Don

Re: MSAccess

#225

Author: Vassiliev V. V.
Date: Wed, 04 Jul 2007 14:04

21 lines
2020 bytes

What is your C++ Builder version? It is in object inspector for TADOTable in 
C++ Builder 5 and C++ Builder 6.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Don" <dgnospamlocke@comcast.net> ???????/???????? ? ???????? ?????????: 
news:468b9121$1@newsgroups.borland.com...
> Thanks for the reply.  But you didn't say where to find the table name. It 
> doesn't appear in the object inspector. So I put it into the connection 
> string. Now it doesn't complain about the table name. But I'm getting an 
> error message saying "Could not find installable ISAM". I need to look at 
> all of the records as I'm converting the data from MS Access to Advantage.
> Don

Re: MSAccess

#226

Author: Don
Date: Wed, 04 Jul 2007 15:08

4 lines
1262 bytes

I'm sorry. I should have included that in the original post. I'm using 
BDS2006 - CBuilder and XP.  And it is not in the object inspector for 
this version. I do have CB5.
Don

Re: MSAccess

#227

Author: Vassiliev V. V.
Date: Wed, 04 Jul 2007 16:39

20 lines
1951 bytes

Property TableName is in object inspector in C++ Builder 2006 for TADOTable, 
in category Database. Right-click on object inspector and select Arrange\By 
Name, then properties will be in alphabetic order.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Don" <dgnospamlocke@comcast.net> ???????/???????? ? ???????? ?????????: 
news:468bb7e2$1@newsgroups.borland.com...
> I'm sorry. I should have included that in the original post. I'm using 
> BDS2006 - CBuilder and XP.  And it is not in the object inspector for this 
> version. I do have CB5.
> Don

Re: MSAccess

#228

Author: Don
Date: Wed, 04 Jul 2007 21:51

14 lines
1447 bytes

Hi Vassiliev,
   The following is all that is in the object inspector for TADOTable:

Active
Connection
EnableBCB
MasterSource
Name
ReadOnly
Tag

I always sort by name as I find it easier to use. It's beginning to look 
like I may need to reinstall BDS2006.  I have installed all of the hotfixes.
Don

Re: MSAccess

#229

Author: Minas
Date: Wed, 04 Jul 2007 22:10

22 lines
1496 bytes

"Don" <dgnospamlocke@comcast.net> wrote:

> Hi Vassiliev,
>   The following is all that is in the object inspector for TADOTable:
>
> Active
> Connection
> EnableBCB
> MasterSource
> Name
> ReadOnly
> Tag
>
Hi ,

Right click on Object Inspector -> View -> check Database

or right click - > select View -> All

Best Regards

_Minas Harokopos

Re: MSAccess

#230

Author: Don
Date: Thu, 05 Jul 2007 12:05

3 lines
1313 bytes

That did it!!  I had never noticed that feature before.  Thanks to you 
and Vassiliev for you help.
Don

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads