How To Link Access To Sql Db Help?

May 18, 2005

I need help with changing data source/which database my Access application connects to.
We got this application from overseas,it is a Access front with an SQL db, I have restored the database, so we have the database, however as soon as I click to do anything in the program I get an error because I need to change the database it looks for.

I was told to open the application and go Tools-Database Utility Manager and Linked Table Manager and get all the tables and select the tick box to "Prompt for a new location" however I have no tables to be selected once I open Linked Table Manager.

I have never done this before, if this sounds familiar to anybody I would appreciate any help.

Thanks all

View Replies


ADVERTISEMENT

Outlook And Access Link!!

Sep 22, 2005

Can anyone tell me if it is possible to link access to outlook so that access can send out reminders through outlook to people regarding different information??

View 1 Replies View Related

Link Tables From Another Access Db

Nov 9, 2004

Is it possible to retrieve table information from an external Access db. Then append chosen tables to the current access db by linking them?

View 8 Replies View Related

Link Between Access And Excel

May 16, 2006

Hello
Im having trouble with access and im kinda new to it so ne nice ;)
Ive searched the forum and i havent found anything helpfull...

I want to link a single cell in excel, another file, to my access query... how can i do this?? Thank you in advance. :)

View 6 Replies View Related

Ms Access And Ms Outlook (is There A Way To Link Them?)

Jan 30, 2006

Hello,

Is there a way in Access to create a database that stores (a list of) Ms Outlook emails? And then, is there a way I could drag and drop an email from Outlook into the access database?

Thanks...

Willchum.

View 3 Replies View Related

Link To Pdf File Within Access

Jul 21, 2006

Hello..

Here is what I would like to do. I have a folder say with 100 pdf's. What I would like to do is from an access folder be able to point to the specific pdf and have it create a link within the access form to the pdf they point to... Does this make sense?

Is there a way from within an access form that you can have a button that lets the end user look in a folder and select the pdf... and then create and store the link in an access form???

Thanks
R~

View 10 Replies View Related

Access/Oracle Link HELP!

Jun 28, 2004

I was hired to write some reports in Access 2000 for a small company (max of 6 users at a time). The database was created by someone else and he decided that moving to Oracle was the answer to some of their issues (losing data due to record locking). The guy did not know Access at all so that DB is screwed up (another issue all together). I had no problem creating the reports and they ran fine on my home and work computer. When I imported the reports into the Access DB at this company they ran fine (but VERY slow). I then got a call 3 days later from them saying the reports wouldn’t run. The owner decided to upgrade to Access 2003 to see if that would help but that created another set of new error messages. When I try to run the report it gives two messages: "can not perform action/make changes in record primary key" and "record not found". These reports are based on simple select queries. Trying to run the reports freezes the application. I even tried to open the tables and it either freezes the app or takes about 15 minutes to open. These tables are linked to Oracle 8i. The newest OBDC drivers have been installed and the newest Oracle 8I edition has been installed. Since I can run the reports in Access I assume the issue is the link with Oracle. I have very little Oracle knowledge. From what I can tell the data is stored in Oracle and Access pulls the data via the links. Has anyone experienced this? Does anyone know how to fix the issue? Your help is very much appreciated!

View 4 Replies View Related

How To Link 2 Combobox In The Access

Feb 22, 2014

i want to know how to link 2 combobox in the access like id i chose a department in the other combobox show me the list under that department and the other think how i can create a search button to the date and to the department i want and how to create a button to calculate from many tables.

View 2 Replies View Related

How To Link An Access Databse With A Mac User

Jan 17, 2006

I thought I new enought about access databases. I've used the Time & Billing database as a template for my sister to use, but her partner uses a MAC. How can I get the MAC to access the database? I believe the MAC can use Excel but how can I link these two, if at all.

View 4 Replies View Related

Link Table From .mdf (sql Srv) File Into Access Db

Mar 8, 2006

i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?

View 1 Replies View Related

Link To Back-end In Access 2007

Oct 29, 2007

Hello people,

Before I ask my questio I want to let you know that I have searched the forums for an anwser but I just couldnt find it. Or the code didnt work.

What I want is pretty simple for the most of you guys....but not for me. lol

I have a front-end and a back-end.
I want to perform a check if the back-end is still in the same place.
When its not it should promt the user for the new location.

Who can help me please?

View 14 Replies View Related

Can I Link Access To Cognis Impromptu?

Nov 22, 2007

Guys,

I have just been shown the delights of a Business Intelligence tool called Cognis Impromptu, a report building tool, reports are built up like tables, very similar to using SQL query builder in Excel.

Reports that I have built can be saved with a .IMR extension, so when they are opened the Impromtu tool refreshes them.

My question is threefold;

Can I link Access to these tables, so as to use them in a database?

If I can link them, when Access opens them, will they automatically refresh?

When I open the reports manually, they refresh, but I have to OK a security dialogue box, nothing really critical, just really a check box. If Access will refresh these reports when they are opened, how can I bypass the check dialogue box?

Hope you guys can help, as I feel that I have a potential to do some really good work by using Access in conjunction with Impromptu... :cool:

View 3 Replies View Related

Link To Website (MS Access Database)

Sep 16, 2005

Hi,
How I can link to website MS Access database?
File->Link Tables doesn't understand http or ftp.
Provider doesn't support MS Access.
Thanks for your advice.

View 2 Replies View Related

Link Queries In Access 2002

Aug 29, 2006

Hi,

Is it possible to link a query in access 2002? It gives me only tables in the menu. Thanks in advance.

Max

View 1 Replies View Related

Link One Table From MS Access To Outlook

Dec 11, 2005

Hi,

I have a question.

Can MS Access table link to Outlook?

Suppose there are Tom and Sue persons:

Sue manage the acc.mdb database file, The database has one table which is called "input", Sue made the form, the form is come from "input" table info. and also Sue made one button to send the specific record to the Tom via outlook, once Sue send out, the mail has created a link, which link can open the document (NOT attached file). Once Tom receive the mail from Sue, Tom will click the link to open the document, and also fill out one signature inside the document, after filled it out, then the signature will automatically populate in the specific field of the "input" table in the acc.mdb database file.

Can MS Access and Outlook do above situation?

Please let me know, thanks a lot.

View 2 Replies View Related

Link Access To Word Documents

Feb 18, 2006

Hi all..

I am new to Access and currently implementing a small company database.

Is it possible to link Access to Word documents?

I wish to create a button on a form that when clicked it opens the word document according to what have been selected in the combo box in the form.

thanks :o

View 8 Replies View Related

General :: Link Access To Word

Apr 8, 2013

If I have a link setup from an access 2010 table to a word 2010 document, is there a way to export the hyperlink address in the table to word as an executable link. Rather than having to insert the link manually as a hyperlink.

View 1 Replies View Related

Sending Email Containing A Link To Access?

Aug 6, 2014

I have a system automated that, when our warranty team receives a warranty part that somebody else has requested information for, will email that person letting them know it has been received.

I want to include a hyperlink in the email that points to the database, opens it with 2 argument containing 2 variables in which one of the forms can auto populate and the information be shown immediately.

So first, I would like to know how to create a hyperlink within the code that sends the email. Second, I would like to know how have the database check for arguments upon opening. I can do the rest.

For instance, John Smith requested part number 123456 on claim number 55555, serial number 7777777. The database is located at "S:SharedWarranty ReturnsWarranty Returns.accdb". Therefore, the hyperlink would aim at the location and carry the arguments 55555 and 7777777.

Current emailing code (obviously variables are passed into the function):

Code:

Function sendemail(msg As String, subj As String, recipients As String, ccrecipients As String, xclaim As Integer, claims() As Variant, serials() As Variant)Dim rsnote As Recordset
Set cdomsg = CreateObject("CDO.message")
If recipients <> "" Then
With cdomsg.Configuration.Fields

[code]....

View 14 Replies View Related

How Do I Link Email Text To An Access Database?

Feb 3, 2006

I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.

Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?

View 2 Replies View Related

Link To Both Oracle Tables & Access Backend

Nov 30, 2006

Is it possible in access to link to both oracle AND access tables in the same
access application?

View 2 Replies View Related

Link To A File Or Folder From An Access Form

Jan 12, 2006

Hi Di Hi

I am new to Microsoft Access and have a little problem. I have searched the forum and nearly found the fix but I didnt quite understand what to do, so im creating a new thread.

I have a Access Database and have a client page that stores all the information about that client. We produce reports (scanned word/pdf) for each client and we store the report files in a client folder using the Client ID taken from Access.

My question is can I somehow produce a link from the Client Form in Access to the Client Folder or Files in explorer. I have seen the Hyperlink option but that is only availabe in Design View.

Hope someone can help. Thanks in advance,.

View 11 Replies View Related

Dymo Labeller Link To Access 2003 MDB

Jun 21, 2006

I am using a networked database built by somebody else. I have added a networked DYMO labeller which runs via a simple report in Access 2003.

The probelm I am having is that the default label type I specified in the report (30321) keeps changing, it will change intermitantly and to any available Dymo label listed in the paper size. Nobody else has access to the reports to change it.

One day I come in and the label has changed to a Video Top (30326) label the next day it is a File Folder (30330) label.....the Dymo is having no probelm in any other applications and it doesnt seem to be a probelm in any of the databases I have built which are also networked.

Any ideas would be appreciated....getting sick of wasting labels and resetting the default all the time.:mad: :mad: :mad: :mad: :mad: :mad: :confused:

View 1 Replies View Related

How To Create Drill Through Report Link In Access

Oct 1, 2004

I have a Summary report and a detailed report in MS Access. Upon clicking one of the records in the Summary report should open the detailed version for that record only. Lets say the Summary report has a list of employees. Upon clicking an employee record/link in the summary report should open the detailed report containing the details for that employee alone.

View 1 Replies View Related

Code To Link From Access To Company System

Oct 21, 2004

Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?

View 2 Replies View Related

Modules & VBA :: Link Access To Active Directory

May 8, 2014

I want to link into the active directory to get a list of staff usernames, so it will update the user table as new members of staff are created etc. We currently have around 130 staff, so rather than manually updating the user table i want it to pick up the usernames from AD?

View 3 Replies View Related

General :: Link Excel Files To Access DB

Sep 11, 2012

So I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.

We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.

Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved