Logon question

[djeeten]

Hi,

I'm creating this program that allows users to make orders.

To make sure everything works easy for the user of the program I created this table tblCustomerOnline where I store the name of the client as long as he is online.

My problem now is that I have just been told that several customers should be able to be online at the same time. I think this will mess up everything I have done untill now.

Does anyone have any experience with a problem like this?


Could you please help me out a little,

Thanks in advance,

dj.

 

[OwenTech]

Please specify what the problem is exactly.
Is this an MS Access problem?
OwenTech

 

[djeeten]

Hi,

I'm sorry. Yes this is an MS Acces problem. As I said, I created a program where a user has to login (enter his name and password).

After this user is logged in, he can place orders (of certain products). First I stored the name of the user that had logged in, in a seperate table('tblCustomerOnline'). That way, I was able to use this whenever I needed it on a form. But this would have given me serious trouble when several users would have been logged in.

So my problem is that my program will be used in a network. So it might happen that several users will want to
place an order at the same time (and be logged in at the same time).

I just wanted to ask now if someone has ever made a program like this(where several users can be logged in at the same time), and maybe give me some tips.

Should I for example, put the tables and the rest(forms, queries) in different databases?

Thanks in advance,

dj.