you are using Access 2000 with SQL server 2000 ... and because Access 2000 is made before sql 2000 then you have to do one of the following: 1- go...

you are using Access 2000 with SQL server 2000 ... and because Access 2000 is made before sql 2000 then you have to do

try to use an output parameter (@err) that indicates if any error happened or not

ALTER Procedure AnyThing

@err int output

as

Begin transaction

set @err...

I have another solution for you .. to transfer data and Structure from SQL Server to Access:

open Access

from "file" menu, choose "Get External Data" , then "Import"

then...

ok I understand now more ..

you have to do this phases before other phases I said before:

- changing code to ADO, and you still use Aceess

then make all the rest...

the relationship in Access is transfered to Triggers in SQL server 7 , and is transerefed to Relationships in SQL Server 2000

of course Relationships is more simple to use...

I mean use Upsizing wizard to send data to a database name "TempApplication" .. and put it on this server .. or any other server ..

so it will be...

ok Christy .. go a head on what you said ...

all you have to do is

1- reading in upsizing wizard (use access XP .. it is the...

so you want to make 2 big steps in 1 atep :

the 2 steps are

1- sending Data to SQL server

2- making VB application connected to it ..

...

First thing is to use Access XP (2002) upsizing wizard to transref data and structure (not access 2000)

the simplest solution is to "Create a two-tier application" by linking Access...

see these links

http://www.sqlmag.com/Forums/messageview.cfm?catid=3&threadid=6207

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9011

they will help you understand the problem and the solutions

I hope this help u

Alamir Mohamed

Alamir_mohamed@yahoo.com

to see this job :

go to EM (Enterprise Manager) , expand your server , expand "Management" folder, expand "SQL Server Agent" , click on "Jobs" ...

here you will see...

the solution which cmore give above is wonderful ... but I have a question

what If I put Triggers on the 3 tables on insert and deletes ??? ......

please take care of this :

open enterprise manager , right lick on your server and choose "properties" , go "server settings" tab, and UNcheck "allow triggers to be fired which...

did you try to save information in local tables on Access ??

and make Yes/No (Bit) field on that local tables to let you know it this chages go...