Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ACCESS to SQL (Upsizing) Expand / Collapse
Author
Message
Posted Tuesday, March 2, 2004 12:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 18, 2005 1:50 PM
Points: 26, Visits: 1
 

Why is it, sometimes a database will not allow me to

upsize it to SQL ?  The Upsizing option in ACCESS is not available (unable to

highlight it)

I have 2 datasbases in the same folder on my PC.  One will upsize, the

other won't.  Is there something in ACCESS that won't allow me to upsize a

DB.  What am I missing ?

Thanks.




Post #103639
Posted Wednesday, March 3, 2004 1:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
I guess both are the same version and the same type (mdb or mde?)




--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #103754
Posted Wednesday, March 3, 2004 1:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, October 29, 2007 2:41 AM
Points: 380, Visits: 10
what Version of access you use ? (Access 97, 2000 or 2002 [XP])
by the way Access 2002 [XP] is the best tool to upsize your application to SQL Server.




Alamir Mohamed
Alamir_mohamed@yahoo.com
Post #103761
Posted Wednesday, March 3, 2004 12:17 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:46 PM
Points: 331, Visits: 554

If it is an older Access database like Access 95 or 97 you might have to convert it to a newer version before the option is available.  Also, are you trying to upsize to the same SQL Server as sysadmin?  Or could the Access database have security set up and you don't have sufficient privileges?  Just a few gotchas that I've run accross.

Linda




Post #104001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse