User Profile

swatijogdand · Dec 18 '06, 06:21 AM

Hi all,

I want to insert a record at a time from front end i.e. vba in a table located on sql server. But, one field on that table has an 'identity' constraint which is not enabling me to insert record . Please help me.

Regards,
Swati.

swatijogdand · Dec 18 '06, 06:20 AM

Hi all,

I want to insert a record at a time from front end i.e. vba in a table located on sql server. But, one field on that table has an 'identity' constraint which is not enabling me to insert record . Please help me.

Regards,
Swati.

swatijogdand · Oct 16 '06, 10:33 AM

Hi.....

Again, it's really very urgent.
does nebody have the code for connecting a SQL Server table to an access database using ADOX ???

Thanx in adavance,
Regards,
Swati

swatijogdand · Oct 12 '06, 04:24 AM

Hi ,

I have assigned one query as a recordsource to a subform.But, if the form is abruptly closed down, next time it gives a 2467 error at load of the form....
is thr ne solution for this ?

Thx in advance
Swati

swatijogdand · Sep 22 '06, 06:59 AM

how to insert data in a linked table through a pass through query?
pass through query and linked table are attached to the access database at runtime.Also ,pass through query contains stored procedures.

can it be done without giving 'insert permissions' on stored procedures?

plz help... it's urgent
thx in advance,
swati

swatijogdand · Aug 29 '06, 04:28 AM

How to link table of sql server to access database using ado?

User Profile

Profile Sidebar

insert records in a table on sql server with identity constraint on it ??

insert record in a table with 'identity' constraint on it ... ?

code for connecting a SQL Server table to an access database using ADOX

urgent ... plz help for 2467 error

how to insert data in a linked table through a pass through query?plz help....

How to link table of sql server to access database using ado