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
|
|||
|
|||
Upload New Data Structure
Is there a way I can upload a new access database structure without
overwriting all of the data inside the current database? |
#2
|
|||
|
|||
On Mon, 31 Jan 2005 10:17:11 -0800, "Erica"
wrote: Is there a way I can upload a new access database structure without overwriting all of the data inside the current database? Your best bet is to use a "split" database: one .mdb file containing only the tables (the "backend"), with a separate .mdb or .mde file containing the Forms, Reports, Queries etc. with the tables linked to the backend (the "frontend"). The database splitter wizard will set this up for you. With this design you only need to give each user a new copy of the frontend, relink the tables if necessary, and off they go; the data stays in the backend, untouched. It's a MAJOR pain if you have not done so. You'll need to open (each!) user's database and use File... Get External Data... Import to import the changed forms or reports, delete the old versions, rename forms which got a 1 appended to the name because it would have been a duplicate, etc. etc. John W. Vinson[MVP] |
#3
|
|||
|
|||
Can you use the splitter to give access to only certain forms and reports to
users? If so how? Thanks! "John Vinson" wrote: On Mon, 31 Jan 2005 10:17:11 -0800, "Erica" wrote: Is there a way I can upload a new access database structure without overwriting all of the data inside the current database? Your best bet is to use a "split" database: one .mdb file containing only the tables (the "backend"), with a separate .mdb or .mde file containing the Forms, Reports, Queries etc. with the tables linked to the backend (the "frontend"). The database splitter wizard will set this up for you. With this design you only need to give each user a new copy of the frontend, relink the tables if necessary, and off they go; the data stays in the backend, untouched. It's a MAJOR pain if you have not done so. You'll need to open (each!) user's database and use File... Get External Data... Import to import the changed forms or reports, delete the old versions, rename forms which got a 1 appended to the name because it would have been a duplicate, etc. etc. John W. Vinson[MVP] |
#4
|
|||
|
|||
On Tue, 1 Feb 2005 12:15:02 -0800, Sam
wrote: Can you use the splitter to give access to only certain forms and reports to users? If so how? Thanks! Sure. You can give Fred a frontend database with one set of forms and reports, and Janet a frontend database with a different set, and Alfredo a frontend with everything. They can all be linked to the same backend. Makes for more maintenance work on your part but it's certainly possible. Alternatively, implement Access Security on the frontend and assign permissions to user groups. Read the Security Whitepaper from Microsoft's website. Read it TWICE... *carefully*. Then follow it TO THE LETTER. It's not hard to do security right, but it's also pretty easy to do it drastically wrong! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Charting data ranges that change | mikelee101 | Charts and Charting | 2 | December 16th, 2004 11:07 PM |
Data Source issues | Philippe | Database Design | 1 | October 10th, 2004 09:45 PM |
Graph-like data structure | JB Jordan | Database Design | 1 | September 15th, 2004 06:07 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |