Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Split Database < Nested Subforms | Update Query >
Split Your Database
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   2 years ago

Back to Split Your Database

Relinking Tables Upload Images   Link  
Elaine Heltman 
2 years ago
Hi Richard. I have the admin copy of the split database on my desktop, with the backend and encrypted frontend on the server. I'll be distributing the encrypted frontend to users. After I make changes to the admin copy, I'm having issues relinking the new encrypted frontend (SavedAs from the admin desktop copy to the server) to the backend on the server folder. I do not receive the right-hand options to relink, etc., only to refresh. What am I missing in this process? Thank you!
Richard Rost
2 years ago
You can't make that kind of a change in the encrypted ACCDE front-end. You need to relink the tables in YOUR ACCDB then make a new ACCDE file.
Elaine Heltman
2 years ago
So, if I understand correctly, I relink the frontend admin desktop version with the Server BE, then make the encrypted ACCDE file savedAs to the server?
Richard Rost
2 years ago
You shouldn't really have to RELINK anything unless you MOVE the backend database. When you split the database, specify your SHARED SERVER FOLDER as the location for the backend tables. Once that's done, you can change your frontend all you want. Make a new ACCDE and the linked table references will stay the same.
Elaine Heltman
2 years ago
I'm having problems again with the double-clk DoCmd.openform code working in ACCDE files. The link address is correct, I double check it, and I've also tried linking using the IP address for the server. The code works flawlessly on the ACCDB file, regardless of its location - server folder or desktop. Thanks again!
Richard Rost
2 years ago
Interesting. What are you trying to open? Does it work on ANY system or is it a machine thing?
Elaine Heltman
2 years ago
From a form, I'm trying to open another form by double-clicking a selection in a combo box. The ACCDE file does not work on any system. I've tested with both the FE and BE on my desktop; linking FE on Desktop to BE on the server (via VPN); and from a Citrix server (not via VPN). Thanks!
Richard Rost
2 years ago
Can you MsgBox something from the same event? Do other events work?
Elaine Heltman
2 years ago
Good call. Looks like it's only VBA code that's not running. Certain forms do not open to a blank record, via DoCmd.GoToRecord , , acNewRec, as well as the many DoCmd.OpenForm codes I have in most forms. But, a MsgBox that runs from a Command button that prints a report of a file, does work.
Richard Rost
2 years ago
Trust issues? Are you running the database from a Trusted Folder?

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Split Your Database Comments

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

6/30/2022Sales Chart
6/27/2022Rounding Errors
6/26/2022Calendar Seminar Students Only
6/24/2022Multi Combo One Field
6/23/2022Modal & Popup
6/21/2022Week of Year
6/16/2022Value List Combo
6/14/2022Project Budgets
6/14/2022Find Record

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn