Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nyh
Starting Member
1 Post |
 Posted - 2007-01-26 : 08:30:23
|
| Migration from MsAccess to Sql-Server.Problem:Ing_ID = nz(me.Ing_AutoNr,0)me.openform "MyForm",,,"ID = " & Ing_IDThis work in MsAccess with new records but this doesn't work in Sql-Server. How can I solve this? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-26 : 09:23:25
|
| Looks like you have to switch to the COALESCE keyword within your SQL code...or else handle null values differently in your application. Access is a bit of a mixture of DB objects + Presentation code. SQL-Server only deals with the DB side. So your presentation code needs a replacement/upgrade.Are you planning to continue with the access forms?...and just shift the data over to SQL-Server? |
 |
|
|
|
|
|
Migration from MsAccess to Sql-Server