I hve a VB form & db to input data in my sys.i got anothr sys in lan.hw do i load t prog in tht sys 4 inp data

Question

I have a VB program in one system and a database in the same sys. I got another system in LAN. How do i load the prog in the other system so that i can input with the same form in the other system and insert the value in the database in the first system. what should i do for that.

I tried using DSN.As i am new to it, can anyone tell whats the connection string?
I am getting the error "Cannot Find Installable ISAM" what should be done.

Answer 1

yes, you can do this.

1. First create the VB exe file.
2. Access the folder which contain the exe in the first system from the second one.
3 Select the exe file and right click and select "send To->desktop(create shortcut)
4.. You can see the shortcut created in your second system.
5. Run that shortcut, you can run the same exe from the second system
6. Then the same exe refer the daatbase from the first system

Please try this and let me know if you have any doubts.

THanks,
M.RAJA

Answer 2

In the coding of ur vb form connect the db using the DSN. Then convert ur vb form to exe file. Place the db and exe in a folder of ur system. Map that folder thru the system connected in lan. Create a dsn in that system. Execute the exe and it will work finely.

Answer 3

Yes its easy if u know VBA... Connect database using .NET then import the library (using system.excel)... Use the VBA code to copy the data... EX: Workbooks.open("path");
Activesheet("Sheet1").Select;
Activesheet.Range("A1") = TextBox1.Text;
Otherwise Search the VBA Code in google

Answer 4

I have no idea.