Re: Converting to SQL Server

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

It seemed to work incredibly well. even without touching the VBA code, which
I had made sure was ADO. I did not have to create any stored procedures or
views. I'm almost in shock. The macros work , which I did not think was
going to based upon some articles i read.

The db is relatively simple and small, a fews forms and reports centered
around a contact table which has about 500,000 records in it. Right now I
have the trial db on a windows 2000 machine running SQL server 2005 trial
version, and a single client with Access 2003. What astounds me the most is
that I did not have to make any modifications to the client. Just share a
directory on the server and plop the file down, just like you would do for a
normal access file. I guess it automatically figures out the ODBC
connection.

I did order the book that Dale suggested. I know that there are several
different ways to hook up an access front end with a server db. My biggest
question mark is, if i go to production , what happens if the db goes
corrupt? I have a lot to learn.


"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C4DB072-C339-4054-AD80-D119DBF6602E@xxxxxxxxxxxxxxxx
Use the upsizing wizard.
Tools, Database Utilities, Upsizing wizard.
--
Dave Hargis, Microsoft Access MVP


"Powderfinger" wrote:

I'd like to convert a database from Access 2000 to SQL server. Does
anyone
have any advice as to how to get started?


.

Relevant Pages

  • Re: Converting to SQL Server
    ... All of this is accomplished thru SQL and does not require ... SQL you should see at the bottom of the server list "SQL Server Agent" (if ... and a single client with Access 2003. ... normal access file. ...
    (microsoft.public.access.formscoding)
  • Re: Business Rules & Referential Integrity
    ... With regards to my stored procedures and the inherent "White Elephant", ... fully appreciate your comments and will use Declared Referential Integrity ... in SQL Server and capture any named constraint errors/exceptions this way. ... >> about application design and implementation using DotNet. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... server compares the parameter values to the date of the creation of the SP, ... > 1) you can set the record source to the name of a SP, ... > Sylvain Lafontaine, ing. ... >> I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Permissions???
    ... > Server: SQL Server 2000. ... > the user could Write/Read data from server and execute stored procedures. ... > The connection was made with DSNs. ... ADO gives the following message when using stored ...
    (microsoft.public.data.ado)
  • Re: Help!!!
    ... Ensure your stored procedures include 'SET NOCOUNT ON'. ... > Server: SQL Server 2000. ... > I had an ADO conection to the from a VB Application, ... > The connection was made with DSNs. ...
    (microsoft.public.sqlserver.security)