i am unable to trieve the date in ms-access

hi friends,

I am trying to create alert system in which i can able to retrieve the date while configure the OleDbDataAdapter1 itself the

problem occurs this is the code i tired

select * from table name (username=?) and (date=)

after entering this error occurs

You haven't mentioned about SQL Server version you are using, refer to this http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ link in this case where it explains how you can achieve from SQL Server side.

IN SQL Server 2000 you can use DTS to get (import) the data from any other data provider and you can schedule the DTS package too.

|||

hi

i am not using MS SQL server but i am using ms access