Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Fri Dec 16 16:00:54 CST 2005
I installed VS2005 which also installs SQL Server Express. I just tried to use the upsizing wizard but failed to connect. Do I need to install SQL Server 2005 as well to get that to work? TIA Rocky ----- Original Message ----- From: "E-business2start.com - Marcel Vreuls" <oost at e-business2start.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, December 16, 2005 12:19 PM Subject: [AccessD] Upsize? > > Hi Guys, > Just a question. I have distributed Access 97, 2000 and 2003 databases as > backend database with about 600 installations. Now i want to port the > access db to sql server (MSDE). I know the access upsize wizard exists but > this wizard does not seem to to it right. > I have a database with about 50 tables which are related with each other > and in many case the relation is made with a query instead of table to > table relation. The upsize wizard does not convert the queries to stored > procedures. > Does anyone know a good way to get my access db to sql server with all > tables, relations and queries. > Tnx, marcel > -------------------------------------------------------------------------------- > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >