How do I connect to an Access Database?
Posted on 1997-05-19
I am new to Delphi and am having trouble connecting to my access database :
I have used the BDE and created a new driver called ODBC_Access and selected the Access driver as the default.
I set the database name to the path and db name above.
I then create an alias called property with an alias type of
ODBC_Access. I fill in the database name as "property.mdb" and the path as "d:\Clients\Property_Guide\Software" for the alias. When I go into Delphi 2 and try to connect my TTable component, I manage to set the DatabaseName property to "Property", but when I try to set the TableName property
It comes up and asks me for a user name and password, which it shouldn't do.
I'm not sure where I'm going wrong so any help will be appreciated. Thanks in advance.