Creating Log in Form using link tables in SQL

[foxhunter]

i have an SQL database where our application runs, but ild like to use MS Access to customize reports.So what i did was i linked the tables from SQL thru ODBC to Access.

Then, i would like to create a log-in form using the table logusers, i jst dont know how to do it. i tried few things like using Dlookup but it does not work. example the table in SQL is Logusers, when i linked that to Access it becomes bdo_Logusers,

Can there be somebody here can give me a sample code that tables were linked in SQL so that i can start learning from it.

Thank you, i hope someone will help me.

 

[James Deckert]

Your code will need to reference the table as what it's called in Access. If you don't want it called bdo_Logusers, won't it let you rename it? Very little should be different when accessing the data. Some SQL slight differences.
What is not working with DLookup?