Re: Migrating from 97 to 2002+ / JET to MSDE



Also the company does not have a network server. What it has,
though, is an FTP site. Will that suffice as a central point to keep our
data?

You can send files to the FTP site..but not connect ms-access to a ftp site
(it don't work that way).

However, since the company has a FTP site..then presumably they have server
space. And, even when you rent, or purchase FTP space, 90% or more do also
provide some type of sql server (database) system and space also. So, you
might check what they offer.

And, if what you have now works..then I would not worry much. As mentioned,
moving to sql server would result in some additional administration and work
to maintain that database server. So, I would only justify the EXTRA time
and effort to maintain the database if you were realize some type of gain by
moving to sql server.

All in all, it seems your main worry was about JET and ms-access, and there
is not much to worry on that area...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.



Relevant Pages

  • Re: replication over internet
    ... Paul, I am getting the following error when I attempt to download the ... snapshot files from the Replication FTP Site: ... Advanced Server and the Subscriber is a SQL Server 2005 database running on ...
    (microsoft.public.sqlserver.replication)
  • Re: need to learn how to get and put table on my web site (via ftp?)
    ... How do you intend to use FTP to do this? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >> Did you actually mean that you wanted to upload a table to an FTP site? ...
    (microsoft.public.sqlserver.dts)
  • Re: Replicating Data between SQL Server 2000 and SQL Server 2005
    ... If its not there be sure to configure your publication for ftp to dump to ... >> Looking for a SQL Server replication book? ... Connection over the internet and 2 different domains ...
    (microsoft.public.sqlserver.replication)
  • Re: master.dbo.xp_cmdshell is failing
    ... Yes, the error is in the FTP command, the s parameter is included twice. ... Wayne Snyder, MCDBA, SQL Server MVP ... > -x:send sockbuf Overrides the default SO_SNDBUF size of 8192. ...
    (microsoft.public.sqlserver.server)
  • Re: FTP and Import CSV file via VB into SQL Server 2000
    ... > The FTP stuff can be found at www.vbip.com. ... > database and then use Access to update the SQL server. ... > to import CSV into SQL. ... > Dim rs As DAO.Recordset ...
    (microsoft.public.vb.database)