Could someone please create me an access DB with 2 tables...???

I require an access DB with 2 tables:

tblUsers

ID (auto increment field) Integer
username varchar * 20 REQUIRED
Password varchar * 8 REQUIRED
Description * 20 NOT REQUIRED

tblTasks
ID (Auto increment) Integer
UserID Integer REQUIRED
Description String * 100 REQUIRED

Cheers,

Woka

Does not compute.

Quote:

---

Originally posted by Wokawidget
I require an access DB with 2 tables:

tblUsers

ID (auto increment field) Integer
username varchar * 20 REQUIRED
Password varchar * 8 REQUIRED
Description * 20 NOT REQUIRED

tblTasks
ID (Auto increment) Integer
UserID Integer REQUIRED
Description String * 100 REQUIRED

Cheers,

Woka

---

Here you go.. That will bo $50.00 US$$

J/K Keep in mind, Password is a Key word in Access, you will have to soround it with the # symbol (almost positive, but might be another symbol.. I can check if you need me to).

Out of courosity, how do you not have access?


Rudy

We have office 2000 at wrk, it did not ship with Access :(
We have SQL Server 7...no need for access unless I want to write a demo app to post on VBF...

Cheers...

However...the DB u posted has ID1 and ID as fields...ID1 being an increment, and ID being a standard integer...is there any chance you could remove the column ID from both takes and rename ID1 to ID???

Much appreciated :D

Waok

I had some free time so...

Thank you ;)

Woka