Access 2000 and SQL Server 2000

  • Thread starter Thread starter BrunoDG
  • Start date Start date
B

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
 
ive not seen this before but my own DB has some interesting bugs when MDAC
2.7 is not installed.
 
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
 
Problem solved. Needed unique table in form.

Thanks for the help guys!

BrunoDG
 
Back
Top