Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

I have a Visual Basic 6 application and want to put the MS ACCESS database it uses on a network and access it remotely from a mobile laptop in transit.  How would I go about doing this?

Posted on 2011-03-14
8
300 Views
Last Modified: 2012-05-11
I have a Visual Basic 6 application and want to put the MS ACCESS database it uses on a network and access it remotely from a mobile laptop in transit.  How would I go about doing this?

Using the internet would be OK if that's possible in a secure mode, otherwise, a mobile link to the network would also work.

Help?

Thanks,
bob...
=======
0
Comment
Question by:bob-hytekltd
  • 4
  • 2
8 Comments
 
LVL 41

Expert Comment

by:graye
ID: 35132771
I'll spare you the lecture about using MSAccess in such a scenario....

There really isn't a good way to expose a MSAccess database via web page, so the "naked" internet option really isn't all that viable.  A reasonable approach would be to establish a VPN link back to the corporate LAN.  Then you'd just attach to the database the same "as if" you were logged into the LAN, via a UNC path (such as \\Server\Path\Database.mdb).

I'd suggest that you talk with the network folks (assuming that not you too!) to find out if they already have a VPN solution in place.  There are a quite a few choices out there for VPNs.
0
 

Author Comment

by:bob-hytekltd
ID: 35133661
Thanks.

Yes, the Network person is me as well for this first test.  I understand about using MS ACCESS but it's what I've been given to work with.

I was actually interested in how one sets up a wireless link from their laptop not using the Internet.  I know you can purchase wireless USB devices that uses the GPRS/Cellular system to establish the link back to the server/network but never used one before.  Who has them and what are they called?  Is it just like the old diailup/dial-in networks just with more bandwidth???

bob...
=======
0
 
LVL 41

Expert Comment

by:graye
ID: 35133878
No, you don't want to reinvent the wheel.   Yeah, sure... in the old days, you'd have a bank of modems that used Remote Access Server that allowed you to dial directly into your network.  However, that's practically non-existent today.   Today, *everybody* uses VPN.  That allows users who have fast broadband speeds at home to connect to the LAN at that high speed.

I'd *seriously* recommend that you take a look at using VPN instead of a modem pool.   There are several "software only" systems that you can create yourself using just what Microsoft has already installed on a Server.  This works pretty good, but it scares the bejebus out of the security folks.  Obviously, they'd prefer that you spend money on a dedicated VPN hardware solution.

Google "VPN solutions" and start reading up...   After that, come back here, and we can help you decide which product will best suit  your needs.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:bob-hytekltd
ID: 35138119
Great response!

I'll head off to Google and take a look.

I'll be back!  (Oh.  Sorry.  That line has already been used before.)

bob...
=======
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 35142481
The best thing would be to use a secure remote desktop solution.  You don't have to add VPN overhead.

One of my Access developer colleagues recommends this Citrix alternative:
http://www.terminalserviceplus.com/
0
 

Author Comment

by:bob-hytekltd
ID: 35429540
Sorry.  This is my first attempt at asking a question.  Didn't know the rules.

I have a satisfactiry response from aikimark.

Very helpful!

Thanks to all who responded.  All were good but aikimark nailed it.

Best,
bob...
=======
0
 

Author Closing Comment

by:bob-hytekltd
ID: 35429547
Thank you all!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question