Re: Upsize no longer transfers "Required" fields to Not "Allow Nul

Oups, sorry, it's not upsizing but sqlupsizing. Personally, I don't care
for the mis-post, it's for you; as you have a better chance to get a correct
answer by posting to the most relevant newgroup as possible.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Ed B" <EdB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3215558A-F05D-4A5F-9305-6A6720FA1ABC@xxxxxxxxxxxxxxxx
Thanks Sylvain,

Last thing first: Perhaps it was because of how I was accessing this
forum
through the ms Discussion Groups site, but I could not find what appeared
to
be a more appropriate group (I still don't see m.p.access.upsizing!).
Sorry
for the mis-post.

Anyway, I haven't changed any default values to 0 or "", so that can't be
the explanation why something changed. In any case, in part because of
running into this "What Changed?" problem, I was already coming around to
the
idea of working on the data structure in SQL Server not Access. But I'd
still like to know what happened...thanks for your input and ideas.

Ed

"Sylvain Lafontaine" wrote:

A default value such as 0 or "" can take the place of a Not Null
property;
so I would say that you have added a default value or set a string field
to
be allowed to have a zero length.

Also, I'm not sure if you have the right method of learning how to work
with
SQL-Server. If you want to use SQL-Server as the backend, then you
should
work directly on the sql-server and not on Access for developing your
data
structure.

Finally, this newsgroup is about ADP and SQL-Server and not about
Upsising
or ODBC linked tables; so you should ask in a more appropriate newsgroup
like m.p.access.upsizing .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Ed B" <EdB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5EE8196D-95F9-4A72-85BD-D1C0A3EA2D30@xxxxxxxxxxxxxxxx
Hi everyone,

I have been working on upsizing an Access 2000 data structure to SQL
Server
2000 using the Upsize Wizard in Access2k2/XP. I have been developing
the
data structure (no data yet) in Access, upsizing, reviewing the
results,
tweaking the structure in Access, then repeating.

So far so good then, all of a sudden, the Access fields that have
"Required
= Yes" stopped showing up in SQL Server with "Allow Nulls" unchecked.
I
have
no idea what I may have done to cause this (I assume I did something,
since
such changes are rarely truly spontaneous!), but I have no idea what it
may
have been.

Any ideas?

Thanks in advance for your help.





.

Relevant Pages

  • Re: Migration Access97 *.mde db in SQLServer2005
    ... Many people prefer to do their upsizing process manually instead on relying ... Sylvain Lafontaine, ing. ... Independent consultant and remote programming for Access and SQL-Server ... Access97 to Access2003 and after then use the SSMA. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Migration Access97 *.mde db in SQLServer2005
    ... Microsoft Access or SQL Server 2005: ... FMS Upsizing Center ... Sylvain Lafontaine, ing. ... Independent consultant and remote programming for Access and SQL-Server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Upsize no longer transfers "Required" fields to Not "Allow Nul
    ... through the ms Discussion Groups site, but I could not find what appeared to ... If you want to use SQL-Server as the backend, ... Sylvain Lafontaine, ing. ... I have been working on upsizing an Access 2000 data structure to SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Upsize no longer transfers "Required" fields to Not "Allow Nulls"
    ... If you want to use SQL-Server as the backend, ... Sylvain Lafontaine, ing. ... I have been working on upsizing an Access 2000 data structure to SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Upsize no longer transfers "Required" fields to Not "Allow Nulls"
    ... because we have a modern language! ... Since Jet database and SQL Server are two different type database engine and there are quite some differences, such as data types, it is almost guranteed that the "Upsizing Wizard" would leave something converted not so well. ... I have been working on upsizing an Access 2000 data structure to SQL Server ...
    (microsoft.public.access.adp.sqlserver)
Loading