Placing a DB on the Internet

[PosseJohn]

I am in the beginning stages of DB development. I plan on having a split DB,
so the actual data can be stored on the internet and be available to users at
various locations.

I've done a similar project within a LAN system, but not on the internet.

How will I need to refer to the internet within the program? And what would
the best way to protect the data from prying eyes or malicious persons?

Any good references would be appreciated.

 

[Rick Brandt]

I am in the beginning stages of DB development. I plan on having a split
DB, so the actual data can be stored on the internet and be available to
users at various locations.

I've done a similar project within a LAN system, but not on the internet.

How will I need to refer to the internet within the program? And what
would the best way to protect the data from prying eyes or malicious
persons?

Any good references would be appreciated.

Using the standard split file setup you cannot do this over the internet.
The back end file is literally "opened" in a split setup and you cannot do
that over HTTP. The back end file must be one that you an see and open
using Windows explorer (not Internet Explorer).

You either need a true web-based front end (not Access) or you need to use
something like terminal server so that people remotely run your file on your
LAN. In the case of the latter both the front end and back end are on your
LAN and people simply run them remotely over the internet.

If you used VPN software so that your LAN was actually visible to your
remote users over the internet they would experience such slow performance
as to be completely unusable and you would really be opened up to file
corruption. Keep in mind that even blazing internet speeds are REALLY slow
compared to even a crappy LAN. Using such a VPN to run the app with
terminal services though is quite usable. That generally only lends itself
to a small number of remote users though without a lot of work and expense.

 

[Daniel Pineault]

Don't. Access is not a Web based database!

Unless you are looking at using access 2010, then rethink your application
and use the proper tool for a web based database (Sql Server, MySQL, ...).

see http://www.devhut.net/index.php?lang=en&pid=0000000036
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[David C. Holley]

If you're users are in multiple locations and need access to the same data,
there are server hosting companies with technology that will allow them to
login to the server as if its right there in the office. For all practical
reasons, it creates a LAN.

 

[PosseJohn]

Does the possibility of having users send/receive copies of the DB and have
it automatically (thru programming if necessary) integrate the DB with the
most updated information/data.

 

[Alex Dybenko]

Hi,
you can consider using terminal services, you only have to environment, no
need to change application
http://www.granite.ab.ca/access/terminalserver.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jack Leach]

Don't you still have to contend with the fact that you're connecting over the
internet and thus risk corruption on anything but a seamless data flow? Or
do these server hosting companies allow you to run the frontend on their
platforms, keeping all of the data transactions local?

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

Maybe you should take a look at replication... this is what the replication
functionality was designed to do, being that trying to access data from the
internet is not a good idea from Access.

Also, this link may give you some answers...


http://www.members.shaw.ca/albertkallal/Wan/Wans.html

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Alex Dybenko]

you only have to SETUP environment

Hi,
you can consider using terminal services, you only have to environment, no
need to change application
http://www.granite.ab.ca/access/terminalserver.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tony Toews [MVP]]

Don't. Access is not a Web based database!

Access can be successfully used as a web database if there are
relatively few updates.

But what you really mean to say is that using an Access database file
to store the data is a good idea over a WAN or to a hosting service.
That is correct.

Unless you are looking at using access 2010, then rethink your application
and use the proper tool for a web based database (Sql Server, MySQL, ...).

You should explain how Access 2010 uses Sharepoint.

That said Access works fine over a WAN or to a hosting service so long
as the data is being stored in SQL Server, mySQL or similar.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

But what you really mean to say is that using an Access database file
to store the data is a good idea over a WAN or to a hosting service.
That is correct.

Arrghh. Insert a NOT in there.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/