Access 2000 and SQL Server 2000

[BrunoDG]

I've developed a SQL Server database (2000) and an user
interface in Access (2003) that was saved in Access 2000
format because some users still have Access 2000 on their
computer.
Everything works fine on Access 2002/2003 but I have lots
of problems on the Access 2000 computers. Eg: when I try
to add a new record (using vba-code) I always get an error-
message 'You can't go to the specified record'. I've
searched the internet and found article 269824 on
microsoft. I tried this but nothing changes. The problem
is not solved...
Any ideas?

Thanks!!!

Bruno

 

[Chris Newman]

ive not seen this before but my own DB has some interesting bugs when MDAC
2.7 is not installed.

 

[Tore G. via AccessMonster.com]

You could do the difficult operations on the sql server in a stored
procedure. Access 2000 (and later editions) perform very well when they
call stored procedures on the sql server.

You

 

[Bruno De Grauwe]

Problem solved. Needed unique table in form.

Thanks for the help guys!

BrunoDG

 

[NICO_bruneta]

buna bruno
cine esti?