Upsizing error message - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Upsizing error message

Author

Topic

Corobori
Posting Yak Master

105 Posts

Posted - 2004-01-08 : 11:14:59

I am having a problem upsizing an Access 2000 server on a Windows 2000 Profesional version using SQL Server MSDE engine. Here is the message:

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-08 : 12:21:16

Could you translate it for us?

Tara

Corobori
Posting Yak Master

105 Posts

Posted - 2004-01-08 : 12:59:30

quote:
Originally posted by tduggan
Could you translate it for us?

SQL Upsizing Wizard

Overflow

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-08 : 13:05:42

I googled "Access upsizing wizard overflow" and found a bunch of information. This might be the one that you need:

http://support.microsoft.com/default.aspx?kbid=272384

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2004-01-08 : 13:19:51

Hey Tara...ever use/like the wizard?

Never have...

Build db...export data..build stage...load stage...audit stage..load db....

Can't be to sure...and to "rely" on an MS wizard....shudder

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-08 : 13:21:35

I've never even used Access, let alone an Access upsizing wizard. I rarely even used the SQL Server wizards. When I do, it's cuz I'm being lazy.

Tara

Corobori
Posting Yak Master

105 Posts

Posted - 2004-01-08 : 15:37:34

quote:
Originally posted by tduggan

I've never even used Access, let alone an Access upsizing wizard. I rarely even used the SQL Server wizards. When I do, it's cuz I'm being lazy.

Well I have been using Access since version 1.0 and made a pretty good living out of it.

Anyway. My situation is the following: one of my client needs to converta data in Access to SQL Server. He is using the MSDE engine not the SQL Server full version.
X002548 seems to say that relying on a Microsoft wizard is not good. What should be using then ? I guess I can't use DTS without SQL Enterprise Manager, which is not installed with MSDE ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-08 : 16:21:00

I wasn't suggesting anything by my comments. I was just stating the facts as the pertain to me.

Doesn't dtsrun.exe come with MSDE? I think it does. dtsrun.exe allows you to use DTS without the UI.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources