asked on

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

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.

jjc9809
Initial-Entry-Screen.png
Initial-input-table.png

Scott McDaniel (EE MVE )

Do you mean you want to link your database to a server-based datafile? If so, you need to create Linked Tables.

http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx

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

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:
http://access.mvps.org/access/api/api0008.htm

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
me.Vendor=fOSUserName()
end if

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

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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)
Database211.mdb