Re: Recommended? Access + DAO + SQLServer 2000 + ODBC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you have a well designed application, you do not transfer
table data/indexes.

If you have poorly designed application you do.

Most people prefer Windows Integrated Security
rather than SQL Server Accounts.

If you remove the SQL Server permission's from the
integrated logins, you will get a login screen when you
connect, which will enable you to use SQL Server logins.

Terminal Server works well.

(david)

"Savvoulidis Iordanis" <iordanis_sav@xxxxxxxxxxx> wrote in message
news:ObogX0gIGHA.1312@xxxxxxxxxxxxxxxxxxxxxxx
> I currently use a MDE + MDB access 2000 application (which uses the DAO
> library only), through Internet VPN (1Mbit Download, 256 Upload). The
> limitation is that all data/indexes must travel through the wire (access
MDB
> is file based) and be filtered on the client. 1 MBit is still slow for
> Internet VPN.
>
> 1) Of course the performance sucks, so I decided to make a quick shift to
an
> ODBC connection to SQL Server for the data, but still use the MDE
> application with no changes (or only a few). So now the tables are linked
to
> SQL Server database.
>
> This way, do I avoid the transfer of all the table data/indexes, each time
I
> open a form, or not?
>
> Also I use User Security Accounts for the MDE. How can I make use of SQL
> Server logins when the MDE starts? Should I stop using User Security
> Accounts?
>
> 2) Another idea that came on my mind is to use Windows Terminal Services,
so
> I keep the first MDE/MDB scenario.
>
> Can Windows Terminal Services let users open multiple (but private for
each
> user) desktop sessions on the server, to run the MDE? Is it a safe option
> for gaining speed ?
>
> =================================
> TIA and I'm looking forward to any replies
>
> Savvoulidis Iordanis
> Greece
>
>
>
>
>


.

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)
  • RE: Login failed for user (null).
    ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [NT] SQL Extended Procedure Functions Contain Unchecked Buffers
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... SQL Server 7.0 and 2000 provide extended stored procedures, ... Several of the Microsoft-provided extended stored procedures have been ... Exploiting the flaw could enable an attacker to either cause the SQL ...
    (Securiteam)