Accessing remote database with VB Windows App - possible?

Question

Hi everybody,
Is it possible to write a windows application that has internet connectivity and able to access a remote database?

I want to avoid using a web application because the postbacks are making the program very slow. I'm not an expert in Javascript eiher so i'm thinking of a windows application.

What do you think?

Answer 1

Yes, especially easy if it's Access/Jet file.

Otherwise there are many DB access wrappers, some restrict to local, some remote, all of them Microsoft so wouldn't doubt it. Begin your search using "ADODB" you will find a better one that works like JDBC.

Answer 2

Unfortunatly that's carefully confusing to guard an get acceptable of get entry to to db... because there are countless freeware kit available that ought to tell the patron the password of the get acceptable of get entry to to db in spite of if its take care of. The simplst as end results of the take care of the db from outdoors enhancing is an basic trick i got here across together as doing an same form of undertaking... replace the first couple of bytes of the database rfile so as that when the app is closed, if beginning the db is tried the patron receives an blunders putting ahead "Database format isn't known", yet once you open the db contained in this gadget, have it replace the first couple bytes shrink back to the unique, open the db, replace, replace or in spite of, then once you % up the db, replace the first couple bytes so as that they are incorrect back.