Help for a Beginner Among Beginners

Help for a Beginner Among Beginners

Post by NYA Jo » Thu, 19 Apr 2007 22:03:54


Hello, would anyone kindly point me in the general direction of
a solution to a very basic database question (I'm not even sure where
to ask)?

I have a small consulting company of a dozen employees, with no IT
dept.
We have info from approx 1000 clients stored in an Access 2000
database
which is 10MB in size. A former employee made a simple form, which we
populate
with client info, and we just add records. The file is on a file
server, and
all 12 of us access it simultaneously. Recently, I hired a guy to
setup
a VPN, so that employees can add data to the database while on the
road.
However, it's very slow accessing the database through an internet
connection,
even through so-called high-speed broadband. Plus, we get "dropped"
connections, in
which we need to restart Access, or reconnect VPN, and usually lose
the last few
sentences that we typed.

Question: Where do I go to get a database faithfully accessible over
the internet?
Is this an Access question? Is this a networking question? Should I
just troll through
the yellow pages (I've hired some really incompetent IT people this
way)?

Thank you very much for any help you can give!
 
 
 

Help for a Beginner Among Beginners

Post by ruralguy v » Thu, 19 Apr 2007 23:18:42

If you think about it, the internet is waaaayyyy slower then the slowest LAN.
Even if you have high speed BroadBand. LAN's these days run at 100Mb rates
and HS Internet is maybe 1.5Mb if it is a full T1. The only way I know to
get acceptable performance over the Internet is to use a product like Citrix
http://www.yqcomputer.com/



--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.yqcomputer.com/

 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Thu, 19 Apr 2007 23:18:57

if you're a newbie then I reccomend this:

a) avoid MDB like the plague
b) learn SQL Server
c) learn Access Data Projects
d) spit on anyone using MDB for anything
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Thu, 19 Apr 2007 23:19:25

MDB doesn't work over VPN
use Access Data Projects, it works like a charm
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Thu, 19 Apr 2007 23:20:26

I reccomend CraigsList.org for finding people.
concepts like 'the yellow pages' are 12 years obsolete
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Fri, 20 Apr 2007 01:45:52

you're full of *** kid, ADP works like a charm over VPN, WAN,
Wireless and the godddamn public internet

only *** ing retards require people to use terminal server


seriously

MDB is crap
just move to ADP and your life would be much much much simpler




On Apr 18, 7:18 am, "ruralguy via AccessMonster.com" <u12102@uwe>
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Fri, 20 Apr 2007 01:46:03

you're full of *** kid, ADP works like a charm over VPN, WAN,
Wireless and the godddamn public internet

only *** ing retards require people to use terminal server


seriously

MDB is crap
just move to ADP and your life would be much much much simpler




On Apr 18, 7:43 am, "Albert D. Kallal" < XXXX@XXXXX.COM >
 
 
 

Help for a Beginner Among Beginners

Post by NYA Jo » Thu, 26 Apr 2007 05:10:12

Hello, for future reference, I went with a zero-cost workaround:
Use XPpro Remote Desktop to log in and run Access on the host
machine at the office, while the client works out of the office. You
might have thought, "duh...is that what you were asking?" Sorry
if I was not clear. I don't know if this will work at any great
distance,
but within the same town, it works great. The other minus is that
you need a host machine not doing anything else for the guys
logging in. This is definitely not a final solution, but should keep
us
going until the slow part of the season when we have the luxury
of upgrading to SQL server, or get someone to setup Windows Terminal
Services for us.

Thank you all on this site for your kind and generous attention!
 
 
 

Help for a Beginner Among Beginners

Post by Tony Toews » Thu, 26 Apr 2007 12:12:42


That's how I hit my servers in various locations even when a thousand miles away.
I've done it on dialup but it's definitely sluggish.

And there's no reason why, in the future, you couldn't add a second el cheapo system
and hit it. You'd have to open different port numbers at the firewall and do a few
other similar adjustments.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.yqcomputer.com/
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Sat, 28 Apr 2007 14:35:32

it doesn't sound very scalable to me

and I'll choose SQL Server Replication--- MSDE has _AWESOME_
replication capabilities-- over terminal session any day of the week

is terminal session going to work when your client is out at the job
site?
 
 
 

Help for a Beginner Among Beginners

Post by Aaron Kemp » Wed, 09 May 2007 08:41:46

you should be using ADP

ADP works great over a VPN

terminal doesn't allow you to cut and paste from your desktop for example





miles away.
cheapo system
and do a few
 
 
 

Help for a Beginner Among Beginners

Post by aaron.kemp » Wed, 09 May 2007 18:45:27

Albert

you're mother *** ing wrong kid

stay the *** in the corner *** until you learn ADP




On Apr 18, 7:43 am, "Albert D. Kallal" < XXXX@XXXXX.COM >