 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / September 2007ADE acCmdSave problem
Hi! I wrote an ACCESS 2003 app which uses SQL Server 2005 Express Edition. Everything works fine when I start my app as .ADP. when I convert it to .ADE and start it, ACCESS displays an error-messagebox when I call the function "DoCmd.RunCommand acCmdSave" and tells me that it isnt possible to save the current record. This is pretty weird for me, because the .ADP works fine. I need to use an .ADE because I am installing the app at customer PCs and I would like to protect it. currently I use an password for the code, but I think using .ADE is more secure. any help on how to solve this would be greatly appreciated, thanx in advance! regards, Hans Try the more explicit DoCmd.RunCommand acCmdSaveRecord. Hopefully it is as simple as that. "DoCmd.RunCommand acCmdSave" saves an object (generic). I have had no problems with the more explicit acCommandSaveRecord (in an ADE) but that was against SQL Server 2000. Good Luck RJ > Hi! > [quoted text clipped - 17 lines] > regards, > Hans Hi RJ! > Try the more explicit DoCmd.RunCommand acCmdSaveRecord. Hopefully it is as > simple as that. [quoted text clipped - 3 lines] > Good Luck > RJ thanx for Your reply, this did the trick! best regards, Hans mailto:657DB992-9761-4B82-B713-0B3000FCE0C5@microsoft.com > Hi! > [quoted text clipped - 17 lines] > regards, > Hans |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.