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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-25 : 08:14:08
|
| shailesh writes "i want to convert database from sql server 2000 to MS-Access with all keys and default valuesthanking u" |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-01-25 : 12:47:17
|
| MS Access has an upsizing wizard that will natevily upsize all the tables to an MS SQL server. HOWEVER you will still need access to use any forms, queries, or reports that you have created. |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-25 : 16:34:41
|
Auric reread that question ;)
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-01-25 : 16:58:01
|
| HAHAHdoh :)as you can see my brain wasn't operating right this morning..... that was before my morning dose of caffiene I guess. how large is the database??I'd suggest simply linking the tables to MS Access copying the tables to local and then deleting the link to the sql tables. Josh |
|
|
|
|
|
|
sql server 2000