Link to Queries / Build on Access

Discussion:

(too old to reply)

p***@twc.state.tx.us

2008-07-11 15:07:32 UTC

I have a Linked Access 2003 front-end to a SQLExpress 2005 backend. I
have attempted to use Pas-through and SQL Queries and run them on the
Front-End, but everytime it fails.... Although I can see the Tables on
the SQL and nothing is missing.

I Also attempted to Upsize a another Copy of my old Access 2003
Database to SQL , but it fails to upsize my most important Table. I
have removed offending Field information and it still fails (5
times). Don't know what to do. Appreciate any suggestions.

I am a SQL Novice.

Thanks Pete

Alex Dybenko

2008-07-12 05:32:56 UTC

Permalink

Hi,
pass-through query - what fails? what error message? Did you specify correct
connection string?

upsize - try to upsize table structure only and then you append queries to
export data to sql server database
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by p***@twc.state.tx.us
I have a Linked Access 2003 front-end to a SQLExpress 2005 backend. I
have attempted to use Pas-through and SQL Queries and run them on the
Front-End, but everytime it fails.... Although I can see the Tables on
the SQL and nothing is missing.
I Also attempted to Upsize a another Copy of my old Access 2003
Database to SQL , but it fails to upsize my most important Table. I
have removed offending Field information and it still fails (5
times). Don't know what to do. Appreciate any suggestions.
I am a SQL Novice.
Thanks Pete

Bob Larson

2008-07-13 08:18:12 UTC

Permalink

Also, are you using the ODBC Driver (SQL Native Client) if you are on
Windows XP or (SQL Server) if on Windows Vista. It is important to select
the correct one.
--
Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP