Updating Db without exclusive access

[newguy86]

Is there a way to update objects in a database without having exclusive access to the database, so that others can use the database and get the most updated version the next time they open the file? What I want to do is whenever I need to update something in my database I need to be able to go in and implement the update and if others are in the database at the time they will still have access to the old setup until they close the file and reopen it, which at that time will display the updated objects.

Any assistance would be greatly appreciated. And if I need to clarify anything just let me know.

Travis

http://www.enterprise.com

 

[danvlas]

Are you sure you posted the question in the right forum?
Adp is an Access front-end to a SQL Server back-end.

If yes: of course it is possible, by using DDL. You can run scripts for anything, provided you logged on as a user with the necessary privileges.

You can write your script like the following line:
CurrentProject.Connection.Execute("alter table tblname add SomeColumn int")

If the answer is 'no', you should post the question in Access Modules or Access Other Topics forum.
Before that, if your application is not yet split, consider splitting it, as this will give you much better control over everything.



Daniel Vlas
Systems Consultant

 

[jeffshex]

Definately split them up if multiple users are getting in there. I remember there being a post from Bob Larson I think about an auto updater that you can put in your split front end. I have been using that and I love it. I just change the version number in the table and next time a user opens it up, it runs a script that deletes the old and downloads the new file to the desktop. Works like a champ.
That way, you can always hop in and update your "master" front end that only a select few should be able to write to.

HTH,
Jeff

 

[newguy86]

I think I did post in the wrong forum because my setup is an Access Db back-end that feeds into an Access Db front-end. No SQL-Server setup.

And I assume that when you all talk about splitting the database you mean having a front-end and a back-end.

Travis

http://www.enterprise.com

 

[danvlas]

Yes, that's it.
Nevertheless, DDL can be used against your Access back end as well, by using an ADO connection.
See you in the other forum.





Daniel Vlas
Systems Consultant