473,386 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Access Table Links

4
I recently installed and configured an Oracle ODBC driver, I have
successfully created a SQL-Pass Thru Query to an oracle table....

When I attempt to create a linked oracle table in access - select files of
type ODBC Databases()....no Select Data Source selection occurs -
the Link dialog box closes?
Mar 1 '07 #1
7 1605
MMcCarthy
14,534 Expert Mod 8TB
I recently installed and configured an Oracle ODBC driver, I have
successfully created a SQL-Pass Thru Query to an oracle table....

When I attempt to create a linked oracle table in access - select files of
type ODBC Databases()....no Select Data Source selection occurs -
the Link dialog box closes?
That's strange. So when you try to Get External Date - Link tables and change the data type to ODBC Databases the DSN window doesn't open?

Mary
Mar 1 '07 #2
BROWNL
4
That's strange. So when you try to Get External Date - Link tables and change the data type to ODBC Databases the DSN window doesn't open?

Mary
If I select File\Get External Data\Link Tables the link dialog box launches
(LINK command button is greyed out), if I enter ODBC Databases the DSN
window doesn't open?
Mar 1 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
If I select File\Get External Data\Link Tables the link dialog box launches
(LINK command button is greyed out), if I enter ODBC Databases the DSN
window doesn't open?
When you say enter ODBC Databases you mean change the file type?
Mar 1 '07 #4
BROWNL
4
When you say enter ODBC Databases you mean change the file type?
Yes, I meant change the file type
Mar 1 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
Yes, I meant change the file type
It sounds like something is wrong with your installation. Even without the oracle ODBC the standard ODBC data sources should be available.

Mary
Mar 1 '07 #6
BROWNL
4
It sounds like something is wrong with your installation. Even without the oracle ODBC the standard ODBC data sources should be available.

Mary

My apologies - not sure what you mean by that?
Mar 1 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
My apologies - not sure what you mean by that?
I'm not sure what version of Access you are using but it's not behaving as it should.

Open a blank database and try to link tables with an odbc database connection as before. If it's still not working then I think you have a problem with your Access installation and you may need to reinstall it. However, try this first and then I will ask some other experts to have a look to see if they can think of any other reason for this behavior. Can you also state what version of Access you are using and which Windows Operating System.

Mary
Mar 1 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: dananrg | last post by:
I've created a small company database where the tables reside in a SQL Server database. I'm using Access 2000 forms for a front end. I've got a System DSN set-up to SQL Server and am using links...
5
by: dave71 | last post by:
Hi Could someone please advise me how to remove the schema name from linked tables within Access. For example when I connect to a Oracle database via Microsoft ODCB for Oracle the list of...
9
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly...
4
by: Timothy Golden | last post by:
Can anyone tell me what goes on beneath the hood with table linking in Access? We have a speed issue with our database. It uses access for the front end and the back end. Prior to splitting the...
0
by: heruti | last post by:
Hi, is there a way to integrate NT Authentication into an MS Access front end, which uses table links to SQL Server 2000? currently our frontend has 22 users, and uses full access SQL server DSN...
1
by: Terry | last post by:
Hello, Has anyone experienced the following problem following an Upsize from Access 97 to SQL 2000 using the MS Upsize Wizard? Or can anyone see what the problem might be. Before Upsize...
11
by: trinitypete | last post by:
Hi all, I have a user control that uses control literal to build a heading with a link, and a div containing links below. As the link heading is hit, I want to change the style of the div,...
8
by: rdemyan via AccessMonster.com | last post by:
I've converted my application from A2K format to A2003 format. I tried to follow Allen Browne's protocol in getting my app into A2003 (although I was unable to find informtion on the conversion...
12
by: rdemyan via AccessMonster.com | last post by:
I'm having a complicated linking problem. Before I get into the particulars, I'd like to know how Access links to the back-end file at startup, AFTER I've distributed my application to the client....
12
by: slinky | last post by:
Can an Excel spreadsheet or a section of one be embedded into an Access form and serve as a subform from which other parts of the Access form can get data? Thanks!
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.