Amateur trying to open excel and access from within my c++ builder application - please help!!

[Karl]

Hi Folks

I wonder if someone can help me please. I'm certainly no expert, but have
managed to write some useful applications using C++ builder and paradox in
the past.

Now I need to open an excel sheet and use the data to do a look up in an
access table.

My big problem is that having set up an alias in the BDE, I now pop a TTable
component on the form, set the DatabaseName and all is OK until I try and
select the TableName. At this point I get a dialog asking for user and
password. The fact that I also get this when trying to access the MS access
table makes me think I'm doing somehting daft.

Maybe I'm just thick!

I'd be very grateful for any advice and if necessary I can be emailed at
***@virgin.net

Thanks
Karl

[Jayme Jeffman]

Hi,

This is the default behaviour of MS Access, even though you have not set
any password to the database Access itself has done it for you.
Username = Admin Password = "" (blank)

Drop a TDatabase component on the form. Set its alias to the same wich
you have done before on the TTable component. Set the Database property
of the TTable to the TDatabase above. Set the TDatabase::LoginPrompt
to false and you wont be asked for a password anymore.

HTH

Jayme.

Post by Karl
Hi Folks
I wonder if someone can help me please. I'm certainly no expert, but have
managed to write some useful applications using C++ builder and paradox in
the past.
Now I need to open an excel sheet and use the data to do a look up in an
access table.
My big problem is that having set up an alias in the BDE, I now pop a
TTable component on the form, set the DatabaseName and all is OK until I
try and select the TableName. At this point I get a dialog asking for user
and password. The fact that I also get this when trying to access the MS
access table makes me think I'm doing somehting daft.
Maybe I'm just thick!
I'd be very grateful for any advice and if necessary I can be emailed at
Thanks
Karl

[Karl]

Hi

Thanks vary much for this - I can't believe how much time I wasted looking
for the answer. Gives me heart that I found the same question posted in
several groups unanswered.

Why is it always the simple things that hold you up!

Cheers

Karl

Post by Jayme Jeffman
Hi,
This is the default behaviour of MS Access, even though you have not set
any password to the database Access itself has done it for you.
Username = Admin Password = "" (blank)
Drop a TDatabase component on the form. Set its alias to the same wich
you have done before on the TTable component. Set the Database property
of the TTable to the TDatabase above. Set the TDatabase::LoginPrompt
to false and you wont be asked for a password anymore.
HTH
Jayme.

Post by Karl
Hi Folks
I wonder if someone can help me please. I'm certainly no expert, but have
managed to write some useful applications using C++ builder and paradox
in the past.
Now I need to open an excel sheet and use the data to do a look up in an
access table.
My big problem is that having set up an alias in the BDE, I now pop a
TTable component on the form, set the DatabaseName and all is OK until I
try and select the TableName. At this point I get a dialog asking for
user and password. The fact that I also get this when trying to access
the MS access table makes me think I'm doing somehting daft.
Maybe I'm just thick!
I'd be very grateful for any advice and if necessary I can be emailed at
Thanks
Karl