Converting to partially use SQL server

[Guest]

Hi,
I have a database that I plan to put on a website for people to download and
use. Part of the DB allows users to import a csv file that I would send out
once a week by email to them. However, this seems like overkill when I could
perhaps put the shared data on the net for people to connect to.
I have absolutely no idea how to go about this, but assume I have to do the
following...
1. Find a hosting service that has a sql server
2. Use the upsizing wizard to create a sql table of the shared data.
3. Amend the front end MDB (or MDE as it will be) to point to connect to the
table on the SQL Server.
4. Distribute database!

Is it that easy? Is there anything I need to do, or should be aware of?
Many thanks
Jamie

 

[Albert D. Kallal]

Your approach is about right.

Just remember that high speed internet is 100 times slower then your cheap
office LAN.

You can read about other solutions to sharing access data accross the web in
the following article of mine:

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