I have a master access file that I use to make changes to the database. However, other databases on the server are not updating as they usually do. Any ideas?
I have a master access file that I use to make changes to the database. However, other databases on the server are not updating as they usually do. Any ideas?
The other databases are Access projects with table links to the master? What happened that could cause this change in behavior? Any changes to the server (name, permissions, hardware)? Are the table links still set properly?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sorry, I explained my problem pretty poorly. Here we go again.... I have a database that allows multiple users to modify/enter/delete information (access 2007). I have a master database file that I use to modify forms, reports, queries, and general layout. I'm running SQL Server as the back end and ODBC driver for linked tables. Lately, I've made a few changes to the forms on the master file (added a button, added more dropdowns for comboboxes, etc) and the rest of the user files have not been altered and still look like the old forms. I don't believe I've changed anything... maybe I'm missing a step?
Each user has their own copy of frontend on their workstation? How did the replica frontends update design changes in the past? Design changes do not automatically propagate to copies. This thread describes how I manage split database for multiple users. I don't use ODBC. http://forums.aspfree.com/microsoft-...tc-324677.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.