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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2004-12-04 : 12:36:26
|
| Hi,using sql server, its fairly straight forward how to upgrade a database from e.g. version 1.0 to 1.3but using access, i'm not quite sure how you go about upgradading a database? Is it possible to create a script that will update the database structure etc? |
|
|
jhermiz
3564 Posts |
Posted - 2004-12-04 : 19:58:18
|
| Why ?You should just work with a seperate front end and back end. Make a copy of the front end on your PC and change whatever you like, then simply upload it to the server / client pc's when you're ready to go live.Remember the backend tables simply point to the original front end, so as long as they are not pointing to your end than you can upgrade just fine. As for backend are you talking about major changes to the design of the db ? If so it may be a bit more difficult, kicking everyone out is no option I assume :).In any case it is really easy to just relink the data back when you have completed it, or you can write vb routines to copy the data over if you have some sort of constraints on the new table designs.Jon |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2004-12-05 : 06:01:31
|
| Example: Snitz forum application can run on Access. 1000's of people have downloaded the applicatoin and run websites using the software. Say there is after 6 months there are some changes to the database design, how can you alter the old database to the new structure whilst maitaining the data in the database?With sql server this is fairly straight forward, what are the options in access? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-06 : 16:52:36
|
| The missing point is that database isn't suppose to go offline.And you'd have to make sure you kick all of the users out.You would have to code DDL in access to make the changes, and then execute them in dev. I guess you could write a vb app to connect, execute the code, then disconnect.Then you could release that to production.Brett8-) |
|
|
|
|
|
|
|
|
updating a database