I've just installed MSDE 2000 Release A on WinXP Pro. All seems okay, but when I try to upsize an Access Database, I get a message box saying "Overflow!".
Any ideas on what I'm doing wrong? I'm new to SQL Server
Cheers
Dan
It depends on which version of Access you are using -- see
http://support.microsoft.com/default...;en-us;q294407 for
the Access 2002 upsizing whitepaper -- there's a link to the A2000 one
if you're using that.
--Mary
On Sun, 1 Aug 2004 08:37:02 -0700, "Dan Nash" <dan@.musoswire.co.uk>
wrote:
>Hi
>I've just installed MSDE 2000 Release A on WinXP Pro. All seems okay, but when I try to upsize an Access Database, I get a message box saying "Overflow!".
>Any ideas on what I'm doing wrong? I'm new to SQL Server
>Cheers
>
>Dan
|||Mary,
Thanks, am downloading that now. Forgot to mention I'm using Access 2000.
One question though.. when you install, what's the default login you would use? I used the SAPWD switch to create my password, but what's the Login ID for a default instance? May seem like a silly question, but it might be what's causing my problems!
Cheers
Dan
"Mary Chipman" wrote:
> It depends on which version of Access you are using -- see
> http://support.microsoft.com/default...;en-us;q294407 for
> the Access 2002 upsizing whitepaper -- there's a link to the A2000 one
> if you're using that.
> --Mary
> On Sun, 1 Aug 2004 08:37:02 -0700, "Dan Nash" <dan@.musoswire.co.uk>
> wrote:
>
>
|||I'm a little rusty on A2k, but as I recall you have to use a SQL login
and password with the upwiz, not integrated security (the whitepaper
should discuss this). It's a valid login that you create. FWIW,
upgrading to Access 2003 is highly recommended if you're going to keep
an Access FE to a SQLS BE. A2k was released *before* SQLS 2k, and
there have been many improvements and bug fixes since then.
--Mary
On Sun, 1 Aug 2004 13:49:03 -0700, "Dan Nash" <dan@.musoswire.co.uk>
wrote:
[vbcol=seagreen]
>Mary,
>Thanks, am downloading that now. Forgot to mention I'm using Access 2000.
>One question though.. when you install, what's the default login you would use? I used the SAPWD switch to create my password, but what's the Login ID for a default instance? May seem like a silly question, but it might be what's causing my problems!
>Cheers
>
>Dan
>"Mary Chipman" wrote:
