Francisco Tapia
fhtapia at gmail.com
Tue Apr 5 18:28:05 CDT 2005
You can't migrate the FE to SQL Server per say, IIRC I guess that would be and ADP upgrade so that Access looks and reacts kinda like the Access we all know and hate ;). I think it was Arthur who would say this, you want to first take all your listboxes and combo boxes and make "TRUE" queries for their sources rather than the select statment currently lying in there... if you do not the upgrade wizard creates it's ow w/ some funky GUIDs for names... If you want to continue using the MDB as an FE then you won't need to change very much.. .in fact you can take it in phases... first create some VIEWs to feed the table links, and then eventually write your own passthrough queries so that you can leverage the power of your sql server db. I hope this gives you a good starting point. On Apr 5, 2005 5:04 AM, Erwin Craps - IT Helps <Erwin.Craps at ithelps.be> wrote: > > > I need to migrate a MDB front and back to SQL server. > > I tried the both the upsize wizard in MSA2K3 and the import wizard from > SQL server 2000. > But I found out that a lot of stuff are not migrated and renders the > application in a non useable state. > In some cases all the queries are missing, or primary keys and relations > are not set, to much various things missing to verify manualy. > > I wonder if a commercial tool exists to do a better upsize that will > leave my database in a more or less workable state? > > Personaly I would prefer a parralel migration. > > All data in sql server, still using the regular front end but linked > tables to sql and first migrate my IIS-ASP website to .NET and later on > the (multiple) front end MDB. > > Erwin Craps > > Zaakvoerder > > www.ithelps.be/onsgezin <http://www.ithelps.be/onsgezin> > > This E-mail is confidential, may be legally privileged, and is for the > intended recipient only. Access, disclosure, copying, distribution, or > reliance on any of it by anyone else is prohibited and may be a criminal > offence. Please delete if obtained in error and E-mail confirmation to > the sender. > > IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg > > www.ithelps.be <http://www.ithelps.be> <http://www.ithelps.be/> * > www.boxoffice.be <http://www.boxoffice.be> > <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be> > <http://www.stadleuven.be/> > > IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven > > IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: > Info at ithelps.be > > Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: > Staff at boxoffice.be <mailto:figures at boxoffice.be> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...