MS Access to MS Sql upsize

[e106199]

I tried to upsize it with ms access upsizing wizard but it didnt work.And i used enterprise manager. How do i get the tables in enterprise manager. when i click on database folder after i connect the sql server by using the enterprise manager it freezes and nothin happens unless i shut the enterprise manager down. is there anything that i m missing?
thanks
-shane

[b]quote:Originally posted by bruce

Shane,

Are you using the upsizing wizard built in with MS Access?

I did a test using the wizard, it picked up the auto number field and enable identity on the SQL server.

To resolve the problem, you can change the schema using Enterprise manager.

right click on the table name and click design table
goto the column you want auto number to enable
Make sure the data type is int
In the column property

- Set the Identity to Yes
- Set the identity seed to where you want the auto number to start
- Set identity increment to 1

Hope this helps.




[b]quote:Originally posted by e106199

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[bruce]

Nope.

MS has a very bad design on EM. It moves a lot of data across the wire. When we try to open the database tree from our test machine connecting to the net w/ DSL, it took 10 minutes. When opening the database tree from a server that's local to the SQL server, it open in 2 seconds.

Just let it sit there for a bit, it will eventually open.

If it still doesn't work, you can update the table schema w/ Query analyser


[b]quote:Originally posted by e106199

I tried to upsize it with ms access upsizing wizard but it didnt work.And i used enterprise manager. How do i get the tables in enterprise manager. when i click on database folder after i connect the sql server by using the enterprise manager it freezes and nothin happens unless i shut the enterprise manager down. is there anything that i m missing?
thanks
-shane

[b]quote:Originally posted by bruce

Shane,

Are you using the upsizing wizard built in with MS Access?

I did a test using the wizard, it picked up the auto number field and enable identity on the SQL server.

To resolve the problem, you can change the schema using Enterprise manager.

right click on the table name and click design table
goto the column you want auto number to enable
Make sure the data type is int
In the column property

- Set the Identity to Yes
- Set the identity seed to where you want the auto number to start
- Set identity increment to 1

Hope this helps.




[b]quote:Originally posted by e106199

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[e106199]

Thanks, i dont know how long i waited (i was sleeping) but i got it.I can change the fields now but now i realized another problem. In access you can set a date field's default value to be the current date. How do i do it in sql server. There is no option in default value tab. If i write date() is it gonna work?
thanks a lot
-shane



[b]quote:Originally posted by bruce

Nope.

MS has a very bad design on EM. It moves a lot of data across the wire. When we try to open the database tree from our test machine connecting to the net w/ DSL, it took 10 minutes. When opening the database tree from a server that's local to the SQL server, it open in 2 seconds.

Just let it sit there for a bit, it will eventually open.

If it still doesn't work, you can update the table schema w/ Query analyser


[b]quote:Originally posted by e106199

I tried to upsize it with ms access upsizing wizard but it didnt work.And i used enterprise manager. How do i get the tables in enterprise manager. when i click on database folder after i connect the sql server by using the enterprise manager it freezes and nothin happens unless i shut the enterprise manager down. is there anything that i m missing?
thanks
-shane

[b]quote:Originally posted by bruce

Shane,

Are you using the upsizing wizard built in with MS Access?

I did a test using the wizard, it picked up the auto number field and enable identity on the SQL server.

To resolve the problem, you can change the schema using Enterprise manager.

right click on the table name and click design table
goto the column you want auto number to enable
Make sure the data type is int
In the column property

- Set the Identity to Yes
- Set the identity seed to where you want the auto number to start
- Set identity increment to 1

Hope this helps.




[b]quote:Originally posted by e106199

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[e106199]

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane

[bruce]

Shane,

Are you using the upsizing wizard built in with MS Access?

I did a test using the wizard, it picked up the auto number field and enable identity on the SQL server.

To resolve the problem, you can change the schema using Enterprise manager.

right click on the table name and click design table
goto the column you want auto number to enable
Make sure the data type is int
In the column property

- Set the Identity to Yes
- Set the identity seed to where you want the auto number to start
- Set identity increment to 1

Hope this helps.




[b]quote:Originally posted by e106199

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane
</blockquote id="quote"></font id="quote">

[bruce]

i think the command is getdate()

[b]quote:Originally posted by e106199

Thanks, i dont know how long i waited (i was sleeping) but i got it.I can change the fields now but now i realized another problem. In access you can set a date field's default value to be the current date. How do i do it in sql server. There is no option in default value tab. If i write date() is it gonna work?
thanks a lot
-shane



[b]quote:Originally posted by bruce

Nope.

MS has a very bad design on EM. It moves a lot of data across the wire. When we try to open the database tree from our test machine connecting to the net w/ DSL, it took 10 minutes. When opening the database tree from a server that's local to the SQL server, it open in 2 seconds.

Just let it sit there for a bit, it will eventually open.

If it still doesn't work, you can update the table schema w/ Query analyser


[b]quote:Originally posted by e106199

I tried to upsize it with ms access upsizing wizard but it didnt work.And i used enterprise manager. How do i get the tables in enterprise manager. when i click on database folder after i connect the sql server by using the enterprise manager it freezes and nothin happens unless i shut the enterprise manager down. is there anything that i m missing?
thanks
-shane

[b]quote:Originally posted by bruce

Shane,

Are you using the upsizing wizard built in with MS Access?

I did a test using the wizard, it picked up the auto number field and enable identity on the SQL server.

To resolve the problem, you can change the schema using Enterprise manager.

right click on the table name and click design table
goto the column you want auto number to enable
Make sure the data type is int
In the column property

- Set the Identity to Yes
- Set the identity seed to where you want the auto number to start
- Set identity increment to 1

Hope this helps.




[b]quote:Originally posted by e106199

Hi all,
i upsized my access database to sql database but autonumber field seems to be not working. I used enterprise manager to upsize my database and i dont know how to keep the autonumber field in sql server. i know that there is identity in sql server but how do you make an autonumber in identity format in sql server.
thanks in advance
-shane
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">