By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Odd behavior of A2K app in Access 2003

P: n/a
Hi folks,

I have an app written in Access 2000. In that app I have a form with
a button that allows the user to transfer the current record from one
table to another table. This procedure works perfectly when run under
Access 2000 or 2002. However, in Access 2003 it croaks with an SQL
syntax error. The rest of the app functions just fine under Access
2003

Anyone have a clue why this is?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Post:
- the event procedure for the command button,
- the SQL view of the SQL statement,
- the actual error message you receive.

The issue could be that you need to turn off Sandbox mode. See:
http://office.microsoft.com/assistan...roduct=acc2003

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lauren Wilson" <ZZ*@ZZZZ.XXX> wrote in message
news:aq********************************@4ax.com...
Hi folks,

I have an app written in Access 2000. In that app I have a form with
a button that allows the user to transfer the current record from one
table to another table. This procedure works perfectly when run under
Access 2000 or 2002. However, in Access 2003 it croaks with an SQL
syntax error. The rest of the app functions just fine under Access
2003

Anyone have a clue why this is?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.