Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slbmis
Starting Member
7 Posts |
 Posted - 2002-03-06 : 18:29:54
|
| How do i migrate a database from access 95 to mssql server without having to change how the databse is accessed.If it is to be changed what would be required. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-06 : 20:14:59
|
| It depends what you mean when you say "how the database is accessed". Do you mean that the change is seamless to the end user - or that you don't need to change anything in Access?If you mean seamless to the end user then you'll be continuing to use access as a front-end. In this case, probably mostly what you'll need to do is:import all you access tables into SQl Serverrecreate SQL Views for each of you access stored querieslink all the SQL tables and views as linked tables in accessreview all your code and SQL in access to cope with the new names....feel free to ask more...Hey Graz - how come I can't subscribe to this topic?Edited by - rrb on 03/06/2002 20:17:29 |
 |
|
|
|
|
|
Migrating from access 95 to mssql server