Re: MDB vs ADP

Probably worth noting that if you design the system properly this method can
work fine.

I run a large system on exactly this basis - you have to make careful use of
asyncrhonous data access using ado but it does work (and in some cases our
admin system is actually faster at pulling down data that the front ent web
client which is physically located within the same LAN as the sql server.)
So whilst in many cases it can be very slow using an adp / mdb to connect to
a sql server over the net you can make it work.

It's important to note that if you're using Linked tables to connect to the
sql server then this *will* be extremely slow. Re-write using sp's and then
write your own code to populate disconnected client-cursor recordset based
forms that are popultaed from Stored procedures. This way has given us
acceptable performance as above.

Nick

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:eaOuJ3rrFHA.308@xxxxxxxxxxxxxxxxxxxxxxx
> By suitable, he is talking about speed; which will be borderline with both
> MDB and ADP over the Internet; not only when loading 1000 records but also
> when navigating from one record to the next (with or without update to the
> last current record).
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "F. Campos" <fcampos2@xxxxxxxxxxxxxx> wrote in message
> news:df4rik$sj9$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Thanks Norman,
> >
> >> 6. Either *.ADP or *.mdb FE is not suitable to be used on the Internet
> >
> > Are you sure *.ADP or *.mdb FE is not suitable to be used on the
Internet?
> > I mean, if you have an access to internet with static IP adress,
80.90.x.x
> > for example, can you configure that PC as a SQL Server in a way that
other
> > PC can access to your DB through internet?
> > I have hot tried it, but could it work? And could it work fast enought?
> > without
> > having to wait more than 5 secs. to show 1000 text records.
> >
> > Thank you
> > Fernando
> >
> >
> >
>
>


.

Relevant Pages

  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: SQL CE Setup 101... C#
    ... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
    (microsoft.public.sqlserver.ce)
  • Re: HELP! SQL Server Stops my Internet !!!!
    ... up the key first just in case) ... Jasper Smith (SQL Server MVP) ... > shares Internet Connection. ... > internet access and makes my hub crazy! ...
    (microsoft.public.sqlserver.setup)
  • Re: MDB vs ADP
    ... > Are you sure *.ADP or *.mdb FE is not suitable to be used on the Internet? ... And could it work fast enought? ...
    (microsoft.public.access.adp.sqlserver)