all groups > sql server odbc > october 2004 >
You're in the

sql server odbc

group:

Converting Access 2000 to SQL server...


Re: Converting Access 2000 to SQL server... Ron Hinds
10/28/2004 2:49:55 PM
sql server odbc:
[quoted text, click to view]

In my Access app, I have used Access Query objects, as SQL Pass-Throughs, as
the RecordSource for dropdowns and reports. For bound forms, it might not
work as well. I don't think the data is updateable.

[quoted text, click to view]

Absolutely! Pass-Through means the SQL will be sent directly to the server,
so it must use syntax the server understands. When using ODBC, the ODBC
driver translates Access SQL for you. See my reply to a previous post of
yours for more details.

[quoted text, click to view]

IMHO ADO is best.

[quoted text, click to view]

Converting Access 2000 to SQL server... Brad Pears
10/28/2004 5:25:29 PM
I am converting an Access 2000 app to use SQL server instead of access
tables.

There is a lot of work ahead to get it where I really want it - especially
after browsing this newsgroup and doing some research.

I will be using SQL pass-through queries to replace the existence of link
tables - specifically for the tables that currently contain thousands of
records.

Currrently, I have forms/reports that are based on Access tables. Will I
then have to modify these objects so that they are based on the new pass
through queries I will be developing?

Also, since I am communicating directly with SQL server, am I to assume that
Access SQL will not alwyas work anymore and I must use the Transact SQL that
SQL server uses?

One more question...

When creating recordsets etc... in Access, what is the best method to use
when connecting via ODBC to SQL server? The use of ADO recordsets or is
there something better than that for SQL server?

Thanks,

Brad

Re: Converting Access 2000 to SQL server... TSH
11/19/2004 10:51:11 AM
Brad,
We did this and only because the database was getting too big for access.
And it turned out to be even a bigger headache than we thought.
Another problem was that for our type of data (time series, i.e. pretty much
all flattables) msSQL turned out to be horribly slow. If it weren;t for the
size limitation I'd 100% regret leaving access-jet.

Bottom line: Be absolutely sure you really need to convert before you do it.

TSH

Re: Converting Access 2000 to SQL server... labc
1/6/2005 8:43:04 AM
Hi,

Use a project (.adp). There is a exemble in the help section.

"Brad Pears" <donotreply@notreal.com> a écrit dans le message de news:
%23Ro9ZTTvEHA.612@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.
Don't see what you're looking for? Try a search.
View other messages in the sql server odbc group.
AddThis Social Bookmark Button
View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
home · blog · groups Questions? Comments? Contact the dn