Converting Access to MSDE/SQL Server nothing works 1

[DougP]

I am I doing something wrong?
Or is this how it is?
I have had to write all of the code just like in VB to make an Access database work. MSDE does not like the "Time" in a Date/Time it wants this 1899-12-30 08:12:00

the .update command does not work any more.

with rs
.addnew
.update
end with
-----------

Can't add a record then save it like so
DoCmd.GoToRecord , , acNewRec
me.textbox1 = "something"
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Get error "someone has changed the record do you want to undo changes"

All of this worked perfect while it was and Access backend database.





DougP, MCP, A+

 

[PaulBricker]

Well, shouldn't be too much of a surprise. MSDE doesn't recognize DAO objects so all your code needs to be rewritten in ADO include all your DoCmd's. Also, ADO doesn't use the .update method. It automatically updates without any prompting. There are some upsizing tutorials on the net. Google it and see what you can find. You also might want to post any questions you have in Forum958
That is the .adp forum. They can probably give you a lot of pointers you won't get in the Access forums.

Good luck.

Paul

 

[DougP]

Oh No wonder
Stary Stary night


DougP, MCP, A+