Quick Access->Sql server Upsizing Question - split mdb front/back end - which to upsize?
Posted on 2006-05-25
I have an access database thats already split into 2 mdb's - a front end and a back end. the front end contiains all the forms and a few temporary/user specific tables, and the back end contains all the data thats shared.
I'd like to upsize it to sql server in such a way that the front end MDB connects right to SQL server, and the back end mdb is no longer needed.
Can I do this with the upsizing wizard? I assume that if I upsize the back end, that I'll need to modify my front end by hand to get it to connect to SQL server instead of the MDB.
Just looking for some confirmation / simple advice before I start down this path...
I'm starting at 250 points, but I'm more than happy to up the points and split if there are several good replies.