General discussion

Locked

VB and a INTERNET database

By n.harleynovoa ·
O.k. people :
I've been a programmer for many years and have just retired. I am being asked to perform the following task (in retirement) and I haven't a clue. I'd like to know how to do the following without having to learn the entire Internet theory and programming languages. I feel I have been remiss in keeping up with the latest stuff , like the Internet, made complacent by my many years in the area and with the same government agency (I built an Osborne from scratch way back in time - anybody remember the Osborne ?).
'------------------------------------------
I want to be able to do what I do with a LAN/WAN situation but using the Internet: is this possible ?

Currently I mount several Access database(s) (for my several small data size applications) on the server and map a drive on all the local machines to point to that database and I can use it as if it were on their local drives. the question is what is the easiest (in learning time) way to make this happen on the Internet, if it's even possible. Keep it simple for the old brain to absorb.
'--------------------------------------------
My people who work outside the office, and don't always have a method of linking to the LAN/WAN, would be very grateful to you if you have an answer. I haven't used this before so if I'm supposed to here's my e-mail : n.harleynovoa@verizon.net.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VB and a INTERNET database

by kevin.riggs In reply to VB and a INTERNET databas ...

n,

Wow. There are several methods depending on the technologies you want to use and any number of choices your clients have already made or are making. Here is one method:

Assuming the people who are not constantly connected to the LAN/WAN will need batch access to the database(s), then because you are already using MS technology (Access), I'd suggest clients accessing local copies of database(s) via MS ActiveX Data Objects (ADO). This will allow the users to connect via a connection string that specifies a server by IP address so that the client can sync its local copy of the database to the master copy; allowing changes to flow in both directions. In theory this sounds easy but if you've never done this then I highly recommend WROX publishing's _Professional_VB6_Databases_ (ISBN 1861002025).

If the users need real time connectivity via Internet, you can use the same methodology (ADO via connectionstrings using IP addresses) but connecting the recordsets directly back tothe original data store rather than to a local database.

Using the first method would require a procedure that created a temporarily disconnected recordset on the client that would be attached back to the original datastore and then batch updated so that changes that occured while disconnected from the main datastore would flow back up to the data store as changes that had happened on the main data store would be populated in the local database.

Not sure if this is exactly what you're asking but I'm trying to hit the target.

Collapse -

VB and a INTERNET database

by n.harleynovoa In reply to VB and a INTERNET databas ...

Poster rated this answer

Collapse -

VB and a INTERNET database

by agibbs In reply to VB and a INTERNET databas ...

Keep in mind that some hosting companies may be specifically configured NOT to allow that kind of remote connectivity to databses set up on their systems. If the Internet server you store your databse on belongs to you, this won't be a problem. Ifit belongs to someone else, it may not work.

Another option:

Windows 98 introduced a neat new feature called Web Folders. Web folders allow you to treat a file or folder on an Internet website as though they were on your local LAN -- very similar to what you are doing with the database on your LAN now, mapping drives and such. Web folders would make the database on the Internet appear to be local to your program. If you are using Win98, WinME or Windows 2000 for your workstations this would be a great solution, as it ould probably require very little recoding on your part & you won't have to learn another programming language.

--Aaron

Collapse -

VB and a INTERNET database

by n.harleynovoa In reply to VB and a INTERNET databas ...

Both answers helped me very much. Thanks and I'll probably be backfor more. Excellent.

Collapse -

VB and a INTERNET database

by n.harleynovoa In reply to VB and a INTERNET databas ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums