Appending thru Access

[JA]

Hi,

I am new to using an Access (2k) adp to work with SQL Server (2k). I'm not
sure what all I can do.

Can I append new records to the SQL Server db thru Access?

Thanks!

 

[Sylvain Lafontaine]

Yes you can. If you are new, then maybe you should poke around a little to
take a feel about ADP and also take a look at the previous posts in this
newsgroup to learn about some of the pitfalls of ADP.

 

[Susie DBA [MSFT]]

yes you can.

but using 2000 against 2000 doesn't work very well.

I really strongly reccomend you upgrade to 2002