ADE acCmdSave problem

H

hpesata

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
 
R

RJ

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
 
H

hpesata

Hi RJ!
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

thanx for Your reply, this did the trick!

best regards,
Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top