MS Access Desktop & Online.. Possible?

[Mike Wilson]

Dear all,

I'm planning on creating a Microsoft Access sales database, but need it
online as well as accessible from the desktop.

Is it possible to have linked tables point to an online access database
somehow?

Many thanks,

Mike

 

[IRS Intern]

well if you use Access Data Projects this works like a charm.. but
you've got to come up with a security solution


I believe that under file, connection, advanced you can turn on
encryption...
I would really reccomend doing this over a non-default port at least
though since I've heard of some security concerns with that
methodology


but in a nutshell-- MDB can't work across ANY networks let alone the
internet

of course, MDb has been obsolete for a decade.. so it's best to move
to SQL Server

my favorite interface for SQL Server is ADP- FILE, NEW, PROJECT
Existnig Data

 

[Arvin Meyer [MVP]]

You can use Access as a database with either IIS (asp pages) or Apache
(ColdFusion) to access your data over the web. You can put Access tables on
a server for a LocalAreaNetwork, or use it with a TerminalServer, and link
with a workstation.

 

[Mike Wilson]

You can use Access as a database with either IIS (asp pages) or Apache
(ColdFusion) to access your data over the web. You can put Access tables
on a server for a LocalAreaNetwork, or use it with a TerminalServer, and
link with a workstation.

Thanks Arvin,

I think for now we'll have to go with Access tables on a server and use VPN.

Although what I want is a method to make local linked tables connect to a
location over HTTP.

Mike

 

[IRS Intern]

I STRONGLY DISAGREE

MICROSOFT HAS BEEN RELEASING KB ARTICLES FOR A DECADE THAT SAY 'ACCESS
SHOULD NEVER BE USED IN A WEB ENVIRONMENT'

 

[IRS Intern]

USE ADP AND SQL SERVER YOU CAN WORK WITH REMOTE DATA _EASILY_

 

[David W. Fenton]

You can use Access as a database with either IIS (asp pages) or
Apache (ColdFusion)

Why the association between Apache and Cold Fusion? The web server
has nothing to do with which scripting language you use, except that
only IIS knows how to handle ASP, while IIS or Apache (or any number
of other web servers) can handle PHP, ColdFusion and so forth.

Any ODBC-capable scripting language can get access to Jet data via
ODBC drivers *if* they are installed on the web server.

 

[David W. Fenton]

I think for now we'll have to go with Access tables on a server
and use VPN.

Unless you're paying an exhorbitant price for ultra-high speed
Internet access, this will not work, as Access simply isn't usable
over anything less than 10mbps.

Although what I want is a method to make local linked tables
connect to a location over HTTP.

There is no way to do this with Jet data.

 

[Tony Toews [MVP]]

I STRONGLY DISAGREE

MICROSOFT HAS BEEN RELEASING KB ARTICLES FOR A DECADE THAT SAY 'ACCESS
SHOULD NEVER BE USED IN A WEB ENVIRONMENT'

Aaron.

Then post the URLs to the KB articles.

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.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[IRS Intern]

they're all over

I think that 3 Guys From Rolla used to have big commentary on this; I
can't find their site.. Are you familiar?

I'll look on the 'wayback machine' thanks prick

-Aaron

 

[IRS Intern]

and again; why would we ever use ODBC for JET?
isnt' OLEDB faster??


uh like seriously here folk

MS killed ODBC in order to defeat mySql-- in a perfect world I would
preach ODBC to get MS to not be able to get away with this.. but
you've got to pick your battles

and my battles say 'never use Access for anything'

Access Data Projects work GREAT over any vpn, wireless, wan connection

 

[Tony Toews [MVP]]

they're all over

Not good enough.

I think that 3 Guys From Rolla used to have big commentary on this; I
can't find their site.. Are you familiar?

Sure I recall their website. However you stated Microsoft KB articles.

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.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arvin Meyer [MVP]]

Aaron.

Then post the URLs to the KB articles.

UtterAccess has been running on a Jet database for years, so has
Trigemial.com. I built 2 sights using Jet databases, 1 public and 1 an
intranet.

 

[Arvin Meyer [MVP]]

Why the association between Apache and Cold Fusion? The web server
has nothing to do with which scripting language you use, except that
only IIS knows how to handle ASP, while IIS or Apache (or any number
of other web servers) can handle PHP, ColdFusion and so forth.

Any ODBC-capable scripting language can get access to Jet data via
ODBC drivers *if* they are installed on the web server.

True, but Apache web servers are very efficient in their handling of
ColdFusion.

 

[David W. Fenton]

True, but Apache web servers are very efficient in their handling
of ColdFusion.

Apache web servers are very efficient in their handling of
*everything*.

 

[David W. Fenton]

Not good enough.

That would make it very easy to provide a pointer to at least one.

Sure I recall their website.

They also were not specialists in Access/Jet.

However you stated Microsoft KB articles.

Microsoft did document that fact that Jet was not thread-safe which
could have been a problem with web servers accessing a Jet database.
But ADO to Jet *was* thread-safe, so that made it appropriate for
use for small-volume websites.

 

[IRS Intern]

I dis-agree

back in the day; the KB articles specifically mentioned 'do not use
jet for a website for any reason'


I'm not revising history, MS is

 

[Tony Toews [MVP]]

I dis-agree

back in the day; the KB articles specifically mentioned 'do not use
jet for a website for any reason'


I'm not revising history, MS is

Aaron

Find us those articles then.

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.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

back in the day; the KB articles specifically mentioned 'do not
use jet for a website for any reason'

Where are those articles? Specifically, MS articles, not someone
else's.

Michael Kaplan knows more about programming than you'll ever know
and he ran his website on a Jet back end for years when it was
pretty high volume from my point of view (c. 100K hits per day).
That's not high volume in terms of major enterprise websites, but I
think it's pretty good that Jet held up perfectly well under that
load.

 

[IRS Intern]

Micahel Kaplan is a fucking retard, and you can tell him I said that

the gimp should just STFU and learn SQL Server!