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
tar.gus@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.


"Karl" <tar.gus@virgin.net> escreveu na mensagem
news:45196116$1@newsgroups.borland.com...

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