If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Has anyone EVER seen this message?
Im trying to create a form using the design wizard. when i
go to open the form i get this message: "The Wizard is unable to open your form in Form view or Datasheet view, possibly because another user has a source table open in exclusive mode. Your form will be opened in Design view." What does this mean? |
#2
|
|||
|
|||
Has anyone EVER seen this message?
"Jerry" wrote:
Im trying to create a form using the design wizard. when i go to open the form i get this message: "The Wizard is unable to open your form in Form view or Datasheet view, possibly because another user has a source table open in exclusive mode. Your form will be opened in Design view." What does this mean? You are sharing the MDB with other users. That works ok, although prone to corruptions, until you want to change an object such as you are now attempting to do. Access 2000 and newer won't let multiple people in the same MDB when objects are being updated. You want to split the MDB into a front end containing the queries, forms, reports, macros and modules with just the tables and relationships. The FE is copied to each network users computer. The FE MDB is linked to the tables in the back end MDB which resides on a server. You make updates to the FE MDB and distribute them to the users, likely as an MDE. See the "Splitting your app into a front end and back end Tips" page at http://www.granite.ab.ca/access/splitapp/ for more info. See the Auto FE Updater downloads page http://www.granite.ab.ca/access/autofe.htm to make this relatively painless.. It also supports Terminal Server/Citrix quite nicely. 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 |
Thread Tools | |
Display Modes | |
|
|