Very basic: Access frontend - SQL Server 2k backend

[Diana Mueller]

Hello everyone, sorry for the xpost, didn't know where to post.

I'm fairly new to Access, and I never used the DTS feature of SQL Server
2000 before. So I'm a little lost with my latest task:
using Access as frontend and SqlServer as backend with a DTS package to
transfer the data.

Say I have a SQL Server database with one table and I want to do basic
delete, insert, select, update operations using a Access
frontend and a DTS package (or do I need more then one) to control these
operations. How would I do that? I don't need detailed
code, just the basic steps.

Any help is highly appreciated!

 

[Brian]

Hello everyone, sorry for the xpost, didn't know where to post.

I'm fairly new to Access, and I never used the DTS feature of SQL Server
2000 before. So I'm a little lost with my latest task:
using Access as frontend and SqlServer as backend with a DTS package to
transfer the data.

Say I have a SQL Server database with one table and I want to do basic
delete, insert, select, update operations using a Access
frontend and a DTS package (or do I need more then one) to control these
operations. How would I do that? I don't need detailed
code, just the basic steps.

Any help is highly appreciated!

What's DTS got to do with it? You can either create an Access ADP using the
SQL Server database, or connect a front-end MDB or MDE to the SQL Server
database using ODBC linked tables.

 

[MacDermott]

I'm a bit confused as to why you would be using both an Access front end and
a DTS package.
You can use an Access MDB file and ODBC to connect directly to the SQL
Server data, or you can build an Access Project (ADP), which will connect
directly using the SQL Server engine. If you're going to use a DTS package,
why use Access at all?

 

[Diana Mueller]

I'm a bit confused as to why you would be using both an Access front end and
a DTS package.
You can use an Access MDB file and ODBC to connect directly to the SQL
Server data, or you can build an Access Project (ADP), which will connect
directly using the SQL Server engine. If you're going to use a DTS package,
why use Access at all?

I want to thank Brian and You for answering my question so quick! Sorry I
haven't been able to reply, but I was very busy during the last few days.
Now back to my original post:

I got it mixed up, naturally DTS has nothing to do with accessing the SQL
Server Backend. I did that with an ADP and everything works fine.

Thanks again,
Diana