Access 2007 Question:  How do I link Microsoft database to an area on the server.

Posted on 2012-08-13
Last Modified: 2012-08-14
Hi Everyone,

I would like to know how can I link to a machine address or server code automatically to a input form so the user would not have to add the code to input screen when they order. I have attached two screens displaying the input form and the initial table that the form relates to. Your help would be greatly appreciated.

Question by:jjc9809
    LVL 84
    Do you mean you want to link your database to a server-based datafile? If so, you need to create Linked Tables.

    See the section titled "Link to SQL Server Data", about halfway through the document.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Not sure of your terminology here ("machine address or server code"?) but you can use a function like this to get the Network User Name:

    Then you can insert this value automatically when a new record is created;
    On the current event of the form, do something like this:

    If me.NewRecord then
    end if
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    In the big picture, the vendor should be "Logging In" to the database, then any information associated with the vendor can be passed to the form automatically.
    The Vendor ID will be stored, but the Vendor Name will be displayed
    LVL 74

    Accepted Solution

    Or if the "User" is selecting the vendor, then you can use something like this...
    (See attached database)

    In the end, you need to provide us with more information on this system.

    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Here is a sample of a "Log In" form system
    (When you click the new record button the VendorID is added to the table and the Vendor Name is displayed)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now