Edit / Update of DataBase Column in MsysObject

[Fred Lindsley]

i would like to avoid the slow essentially single user process of relinking
tables in the front end database to the data file on the server. If i could
write to the msysobjects table this would save my customers hours of time
when they about.
We have about 5000 users now and this would greatly expedite updating. I
have found ways to read this information but not to write it.

Can anyone help with this?

 

[Tony Toews [MVP]]

i would like to avoid the slow essentially single user process of relinking
tables in the front end database to the data file on the server.

I'm not sure what you mean by the "essentially single user process of
relinking tables".

However the slow part can be solved by the following. Once you've
relinked the first table open a recordset based on that table. Now
relink the rest of the tables. Then close that recordset. This
helps by keeping the .ldb file open during the relinking process.

If i could
write to the msysobjects table this would save my customers hours of time
when they about.

We have about 5000 users now and this would greatly expedite updating. I
have found ways to read this information but not to write it.

Interesting idea but I don't think it's practical. Access keeps all
kinds of cached information about the table in the FE. Error -1517
is one example of this behavior. Thus not at all suggested.
http://www.granite.ab.ca/access/reservederror1517.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Fred Lindsley]

thanks, i will try your idea. i had noticed that relinking a front end when
others are accessing the back end already slows down the relink. much faster
relink when done in single user mode. does your idea have anything to do with
this?

 

[Tony Toews [MVP]]

thanks, i will try your idea. i had noticed that relinking a front end when
others are accessing the back end already slows down the relink. much faster
relink when done in single user mode. does your idea have anything to do with
this?

In a sense. Access knows that no one else is using the backend when
linking to a BE MDB with no other users on it. So Access doesn't
bother putting locks on the LDB file because it doesn't even exist.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/