MS Acces to SQL issues

Hello all - We have several small Access dBs that we want to move up to MS
SQL. We've had some success with the upsizing wizard but have issues. The
most pressing issue is that we can't add new records the the newly upsized
SQL dB. Its like the table or form becomes read-only. I understand that
manual data conversion is best but in the spirit of time, the upsizing wizard
sure is nice and our Access apps are very simple. Any thoughts or
suggestions? Thanks in advance.
--
Rob C, MCSE, CCA
Statesville, NCEnsure you have primary keys defined on all tables you want to update.
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||Define "can't". Do you get an error message?
Jeff
"Rob C" <RobC@.discussions.microsoft.com> wrote in message
news:F4D0AF9E-5926-48FB-BFB4-C83345AA059F@.microsoft.com...
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues.
The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing
wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC|||I'm with Jeff. What do you mean "can't?" The upsizing wizard would not do
this sort of thing. Sounds more like a resource issue.
The main problem I have with the wizard is that it chooses nasty data types
that I wouldn't have if I'd done it manually. This and the transfer of
indexes, pks, and fk relationships is handled poorly by the Wizard.
Sincerely,
Anthony Thomas
"Rob C" wrote:
> Hello all - We have several small Access dBs that we want to move up to MS
> SQL. We've had some success with the upsizing wizard but have issues. The
> most pressing issue is that we can't add new records the the newly upsized
> SQL dB. Its like the table or form becomes read-only. I understand that
> manual data conversion is best but in the spirit of time, the upsizing wizard
> sure is nice and our Access apps are very simple. Any thoughts or
> suggestions? Thanks in advance.
> --
> Rob C, MCSE, CCA
> Statesville, NC