upsizing to SQL.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Until recently my Access Project was LAN based & ran very well. Now the test
period is over & the system has been accepted it is necessary to run the
database over a WAN. There is a dramatic speed difference so I'm looking for
solutions. I have optimized the project & the WAN connection is good but it
is still running slowly. Apparently my options (without completely
re-designing) are either some kind of Thin Client server or SQL. Could
anybody indicate which solution is best & maybe offer some kind of starters
checklist! I've been using Access for a year but I have no knowledge of SQL
at all.

Thank you in advance,

Regards John.

.

Relevant Pages

  • Re: SQL 2000 and User logins
    ... I can create a Access Project from a user's workstation ... I believe the SQL is set for Windows Login Authorization. ... You should probably pre-create a database from within EM as Administrator, ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL Server 2000 & Access 2007 Project
    ... The Access database in questions is an Access Project file. ... SQL Server - I was able to open the table's design view without a problem. ...
    (microsoft.public.sqlserver.clients)
  • Transfer Database using Access Project
    ... I'm trying to transfer an SQL Database using an Access Project. ... 2003 running 2000 file format. ...
    (microsoft.public.sqlserver.clients)
  • Re: odd thing happeningwith subform/new record
    ... If this makes any difference - this is an Access project (.adp) using MS SQL ... server as the backend/linked tables. ...
    (microsoft.public.access.formscoding)
  • SQL 2000 and User logins
    ... I have SBS 2003 Premium and installed SQL 2000 SP3a. ... for the first time and attempting to learning how to build tables through an ... I can create a Access Project from a user's workstation ... I believe the SQL is set for Windows Login Authorization. ...
    (microsoft.public.windows.server.sbs)