MS Access Assistance

I currently have a message board that uses a query in MS Access. I also have security/code on the website (VB I think) that requires a user name and password to get to the message board. On the message board people enter their name and comment and it automatically appears on the message board. Now, I'm trying to set it up to where the person's name (or screen name) actually appears beside their message.

I do have a table in the database that says USERS (for login and password) and one that says USER TEMP. When a person logs in I believe their information logs to the USER TEMP table and is removed when they close the browser.

The messages on the webpage come from a query in Access.

I can currently add a person's name and IP address in the USER table in the database and then, in the query I link or join their IP on file with the IP from their posted message and their name appears perfect.

But, if their IP changes I don't know what to do. I assume something has to be logged from the USER TEMP table, not sure. I want it all to be automatic. All I want the person to have to do is send me their name (or requested screen name) and password and that be it.

I'm sure an Access Expert could figure this out easy.


Veja mais: what is a temp, access database expert, what is ms access, send query, ms s, ms access, C# access, c access, access, access c#, access query table, automatic comment, access table query, add access, code database access, access link website, add code access database, file access, come join, link access database, security logs, users currently logged, user access, changes access, join file

Acerca do Empregador:
( 29 comentários ) Westmoreland, United States

ID do Projeto: #170702