MS Access Desktop & Online.. Possible?

  • Thread starter Thread starter Mike Wilson
  • Start date Start date
M

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
 
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
 
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.
 
Arvin Meyer said:
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.
Click to expand...

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
 
I STRONGLY DISAGREE

MICROSOFT HAS BEEN RELEASING KB ARTICLES FOR A DECADE THAT SAY 'ACCESS
SHOULD NEVER BE USED IN A WEB ENVIRONMENT'
 
You can use Access as a database with either IIS (asp pages) or
Apache (ColdFusion)
Click to expand...

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.
 
I think for now we'll have to go with Access tables on a server
and use VPN.
Click to expand...

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.
Click to expand...

There is no way to do this with Jet data.
 
I R S I n t e r n said:
I STRONGLY DISAGREE

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

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/
 
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
 
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
 
I R S I n t e r n said:
they're all over
Click to expand...

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?
Click to expand...

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/
 
Tony Toews said:
Aaron.

Then post the URLs to the KB articles.
Click to expand...

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.
 
David W. Fenton said:
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.
Click to expand...

True, but Apache web servers are very efficient in their handling of
ColdFusion.
 
Not good enough.
Click to expand...

That would make it very easy to provide a pointer to at least one.
Sure I recall their website.
Click to expand...

They also were not specialists in Access/Jet.
However you stated Microsoft KB articles.
Click to expand...

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.
 
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
 
I R S I n t e rn said:
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
Click to expand...

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/
 
back in the day; the KB articles specifically mentioned 'do not
use jet for a website for any reason'
Click to expand...

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.
 
Micahel Kaplan is a ****ing retard, and you can tell him I said that

the gimp should just STFU and learn SQL Server!
 
Back
Top