ACCESS FEED: RE: [MS_AccessPros] Access 2003 upsizing question

Jumat, 26 Oktober 2012

RE: [MS_AccessPros] Access 2003 upsizing question

Gary

This is going to be tough. Are these queries using only linked tables? If they
are using Access tables as well as SQL tables you could run into issues.

I think the SQL Server Migration Assistant can be run to just import specific
queries, but I'm not sure. Just to be safe, run the migrating tool on a copy of
the Access DB.

Oh, and make a backup of your target SQL DB before you proceed.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP

<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Gary D. Schwartz
Sent: Friday, October 26, 2012 12:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access 2003 upsizing question

Hi:

A couple of weeks ago, I asked about converting queries from Access
SQL to Reporting Services SQL. All I need is the queries, as the
tables are being brought into the customized SSRS application, and no
forms, macros, or Access reports are needed.

One suggestion was to use the upsizing wizard. I can do this on a
copy, to retain all of the current version. I could then pull over
the converted SQL code from there to the new application.

Question: the Access database has a number of tables which are
actually linked to a SQL Server database. Is running the upsizing
wizard going to affect those, or anything outside the Access database
copy? Is there need to do a database split first?

Thanks,
Gary

--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com
<mailto:gary.schwartz%40pobox.com>

[Non-text portions of this message have been removed]