June 6, 2006 at 11:12 am
I have a front-end Access 2003 DB linked to a back-end Access 2003 DB,I would like to upsize the database to SQL 2000.
I have ran some upsizing tests with the Northwind database to get familiar with the process.
My question is do I upsize the back-end first, then the front-end or by doing the front-end, both the front and back ends
get upsized?
My next question is, Once the database is upsized, can the tables renamed with "_local" be deleted or must they remain?
Please advice. Thank you.
June 7, 2006 at 3:57 am
I would merge the front end and back end then do an upsize.
Detail :
DB-Backend is Access 2003
DB-Frontend is Access 2003
Why not import all the tables into DB-FRontend from DB-Backend then run the upsizing wizard. This would then remove any manual work you may have to do to tie the DB's together. It makes sense IMO to do it this way as then you are letting the upsize wizard do the splitting and not having to piece it together after you have upsized each individually.
Its fairly easy to bring the 2 DB's back together! Do you know how to do this? Or are you constrained for some reason to do this?
June 7, 2006 at 7:04 am
You will only upsize the back end to SQL 2000.
You'll still need the front end to interact with the tables in it. SQL Server itself doesn't expose an interace through which users can work.
Once it is upsized, you can safely delete the local tables. They are duplicates of the tables in the SQL Server backend.
George
June 7, 2006 at 7:35 am
Yeah he can quite easily jsut upszie the backend then link the tables form the SQl back to the access front end...but he might as well at least look at using a Access project rather than a access DB with linked tables. it might prove to be better!!
June 7, 2006 at 8:23 am
As a note, using the upsizing wizard to change your database to an ADP is nice ONLY to get an idea of what kinds of changes you'll need to do.
But, the wizard does so many things, well, oddly, that it is pretty much guaranteed that you will not have a working project without having to put some elbow grease into it.
June 7, 2006 at 9:55 am
I am in the process of cleaning the databases of useless stuff and creating indexes were none exist.
I don't have a problem merging both databases if it is going to make the upsizing process simpler. I am trying to do everything possible where I do not have to recreate forms, querries and such.
thanks for the hints , they are appreciated.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply