Recent content by soloprogrammer

I recently converted a Microsoft Access97 application to Microsoft Access 2000 with a SQL Server backend. There were Previous and Next buttons, but when I want to go to different records, I get a "Can't go to specified record" error. In testing this worked BEFORE I moved the tables to SQL...

I finally figured out the problem. For some reason, in Turkey you have to use semi-colons ";" instead of commas "," in functions. Ugh!

I'm working remotely on an Access 2000 database application in a foreign country (Turkey). The backend is SQL Server. Any new function I call from a query or form or report, no longer works. I keep getting the error "The expression you entered contains invalid syntax. You may have entered an...

If anyone else is having this problem, I did find the answer. It was the SQL Server. The datatype BIT was the problem. Here's a link to the solution: http://support.microsoft.com/support/kb/articles/Q280/7/30.ASP

I tried doing this through ADO with a commitTrans. It appears to update with no errors. But when I go to a different record and then back to the original record, the changes are not there. I opened the table through Access and tried to make the change to the field. When I click off of the...

Thank you. I'll try that. That is probably what the cause is. THANKS!

I just recently converted an Access 97 application to Access 2000 with a SQL server backend database. Here’s the issue: The users are getting the following error: “Write Conflict—The record has been changed by another user since you started editing it. If you save the record, you will...