SQL 2000 back to Access 97

#1

Is there backward-compatibility? I am supporting a legacy
Access 97 database and need to do a lot of data
manipulation I'd like to automate in MS SQL 2000. If I
export the DB to SQL 2000 and run my changes there, can I
send the tables back into Access 97 with the
inserted/updated values? Thanks.

#2

You can link to the SQL Server tables from Access and not even bother with
moving them. Or, you can pretty much do a straight import. If you don't
change the schema, it shoudl be painless.

Kevin3NF

"ChrisN" <chrisn (AT) schoolwisepress (DOT) com> wrote

Quote:

Is there backward-compatibility? I am supporting a legacy
Access 97 database and need to do a lot of data
manipulation I'd like to automate in MS SQL 2000. If I
export the DB to SQL 2000 and run my changes there, can I
send the tables back into Access 97 with the
inserted/updated values? Thanks.

#3

Yes but it seems you may be able to use a linked server and
automate the manipulations of the data from SQL Server
against the Access linked server.

-Sue

On Tue, 9 Sep 2003 10:09:23 -0700, "ChrisN"
<chrisn (AT) schoolwisepress (DOT) com> wrote:

Quote:

Is there backward-compatibility? I am supporting a legacy
Access 97 database and need to do a lot of data
manipulation I'd like to automate in MS SQL 2000. If I
export the DB to SQL 2000 and run my changes there, can I
send the tables back into Access 97 with the
inserted/updated values? Thanks.

#4

Thanks Sue,

CN

Quote:

-----Original Message-----
Yes but it seems you may be able to use a linked server
and
automate the manipulations of the data from SQL Server
against the Access linked server.

-Sue

On Tue, 9 Sep 2003 10:09:23 -0700, "ChrisN"
chrisn (AT) schoolwisepress (DOT) com> wrote:

Is there backward-compatibility? I am supporting a
legacy
Access 97 database and need to do a lot of data
manipulation I'd like to automate in MS SQL 2000. If I
export the DB to SQL 2000 and run my changes there, can
I
send the tables back into Access 97 with the
inserted/updated values? Thanks.

#5

Thanks, Kevin. No, schema won't change.

CN

Quote:

-----Original Message-----
You can link to the SQL Server tables from Access and not
even bother with
moving them. Or, you can pretty much do a straight
import. If you don't
change the schema, it shoudl be painless.

Kevin3NF

"ChrisN" <chrisn (AT) schoolwisepress (DOT) com> wrote in message
news:01ce01c376f5$1da58e00$a301280a (AT) phx (DOT) gbl...
Is there backward-compatibility? I am supporting a
legacy
Access 97 database and need to do a lot of data
manipulation I'd like to automate in MS SQL 2000. If I
export the DB to SQL 2000 and run my changes there, can
I
send the tables back into Access 97 with the
inserted/updated values? Thanks.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2000 back to Access 97

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL 2000 back to Access 97 - 09-09-2003 , 12:09 PM

Re: SQL 2000 back to Access 97 - 09-09-2003 , 12:52 PM

Re: SQL 2000 back to Access 97 - 09-09-2003 , 01:00 PM

Re: SQL 2000 back to Access 97 - 09-09-2003 , 02:52 PM

Re: SQL 2000 back to Access 97 - 09-09-2003 , 02:53 PM