| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > Access Runtime Synch-ing with Original Database
Expert: Scottgem
Date: 10/9/2008
Subject: Access Runtime Synch-ing with Original Database
Question
QUESTION: I have created an access database that consists of forms and tables which we intend to use as a testing/screening application. But I am having problems with the runtime version of this application. Here’s what I’ve done:
1. Created database accdb. This works as it should.
2. Followed package and deployment instructions from support.microsoft.com
3. I have the setup file and the msi package.
Only problem is the runtime file accdr – does not talk to the original database and I don’t know how to make a connection to it. For example if I add a test id to the original the runtime doesn’t recognize it. Or if I enter new information into the forms in the runtime version those changes aren’t reflected in the original database. I am new to access, and I know I haven’t explicitly made a connection between the two so I sort of anticipated this problem. What I didn’t expect is how hard it is to find a solution to what should be straightforward since I am sure this functionality is used all the time?
Thanks for the help!
ANSWER: Did you split the database between forn and back ends BEFORE you packaged it? Did you make the connections to the back end using UDC coding rather than a mapped drive letter?
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: How do I make connections using UDC coding? I did try google-ing for an answer for this, but could not find anything. :[
Thanks again!
Answer
Sorry I had a brain fart its UNC coding. The format of which is:
\\servername\sharename\foldername\fielname
If the database is already split, use Linked Table manager and when prompted for a new path, go though the network or type in the exact UNC path.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
Add to this Answer
Ask a Question
|
|
