dude you can't run Linked Tables outside the LAN.

I'm having trouble finding info on linking to tables on a SQL
Server
database from a computer outside the LAN.

These people are just outright lying to you.

It works best to move to Access Data Projects.
Direct SQL Server is _ALWAYS_ more efficient than linked table BS.

That's why 80% of professional developers would never use Access for
any reason--

SQL Server direct is just more fun, faster, and easier.

SQL Server allows you to do things to your data that would make Jet
puke.

Jet just plain sucks.

File, New, Project (new database), browse for MSDE installation (or
SQL Developers Editon)
if you have Access 2007, then you can use SQL 2005 Express instead of
MSDE 2.0

-Aaron



On Feb 25, 8:42*am, Jon22 wrote:
I'm close to completing the consolidation of various small Access databases
and a couple of Excel spreadsheets that my little company uses (5 staff) into
an all encompasing Access database and I was planning on splitting the
database when I was finished to allow simaltaneous use of it by staff on our
small office network. However it is becoming more and more obvious to me that
I am going to need to give staff access to this new database from remote
locations (outside of our office network). Two staff members are regularly
overseas, one is mainly on the road with her laptop etc etc. I've been
playing around with trying to link tables from remote locations (ftp path of
the database on our Network Storage Device at the office) and needless to say
- that don't work. So I've spent the last 10 hours downloading, installing
and trying to get my head around Microsoft SQL Server 2008 Express and how it
might help me out. It all started when I came across a very encouraging
article on keeping your Access database as your front end application and
linking to SQL Server database tables. I'm finding it MUCH more complicated
than I had hoped.

Can anyone suggest a simpler way of achieving remote access to my database?
I have at my disposal a Network Storage Device which has remote access
capabilities (this is where the database is currently stored), our website
which it could be stored on, or I'd be happy to use my quite powerful
workstation at the office as some kind of server. You may have guessed by now
that I'm no IT guru by any stretch so please bare this in mind with any
suggestions.