database acces + sql + .txt

[akhileshbc]

1. How Could I create new table in Acces via VB, i am planning to create "monthly attendance", or something like that

You can use SQL statements to create tables in Access: http://msdn.microsoft.com/en-us/libr...#acfundsql_ddl

2. Could I use SQl instead Acces for my program, but I am completely have no idea how to do it, could someone give me e-book/link/lesson for this matter (I have learn most of basic command on SQL though but do not know how to connect it to vb)

You mean SQL server ?

Links:
* http://www.vbforums.com/showthread.php?t=337051#ado
* http://www.vbforums.com/showthread.p...7051#SQLServer

3. my program use an encryption .txt file to save it login_data, I can read and add data on it, but how could I edit the file ?
in a txt file something like this

Link: How can I edit a text file without opening it?

...