I tried posting this but got an error the first time.
I have set up SQL server on an XP Pro laptop and transferred 2 databases from another laptop which was sucessfull. I also transferred an access database on this laptop which was successful. Now I need to set up the linked tables in the access database but when I try to link the tables and choose ODBC databases as the source the "Select Data Source" screen will not appear. I have set up my ODBC connections to the SQL databases and they test successfully. I have turned off the Personal Wirewall on my laptop. I have looked at my security settings and I can not see the problem. It all works fine on my old laptop running on WN2000 Pro. I tried to relink through the link table manager and changed the server name to the new laptop name but I cannot link. It must be something with XP but I don't know what. I need to finish a class project this week.
Thank you for your help
Roxanne
26 7416 NeoPa 32,569
Recognized Expert Moderator MVP
I think you're probably right Roxanne.
Although you see this in Access, I wouldn't think that it's an Access problem as such.
With this in mind I'm going to move this thread to the Windows forum and I hope you have better luck there.
Thank you. Hopefully, someone will have an answer.
sashi 1,754
Recognized Expert Top Contributor
I tried posting this but got an error the first time.
I have set up SQL server on an XP Pro laptop and transferred 2 databases from another laptop which was sucessfull. I also transferred an access database on this laptop which was successful. Now I need to set up the linked tables in the access database but when I try to link the tables and choose ODBC databases as the source the "Select Data Source" screen will not appear. I have set up my ODBC connections to the SQL databases and they test successfully. I have turned off the Personal Wirewall on my laptop. I have looked at my security settings and I can not see the problem. It all works fine on my old laptop running on WN2000 Pro. I tried to relink through the link table manager and changed the server name to the new laptop name but I cannot link. It must be something with XP but I don't know what. I need to finish a class project this week.
Thank you for your help
Roxanne
Hi there,
What's the error message / error code/number being thrown? It's will be helpful in terms of providing solution. Take care.
Hi there,
What's the error message / error code/number being thrown? It's will be helpful in terms of providing solution. Take care.
There is no error. When I go to link tables and choose ODBC databases for the type nothing happens. There is no error and no window to select the data source. It I choose another type such as mdb It will continue to the next screen to choose the mdb file but nothing at all happens when I choose ODBC databases.
I tried posting this but got an error the first time.
I have set up SQL server on an XP Pro laptop and transferred 2 databases from another laptop which was sucessfull. I also transferred an access database on this laptop which was successful. Now I need to set up the linked tables in the access database but when I try to link the tables and choose ODBC databases as the source the "Select Data Source" screen will not appear. I have set up my ODBC connections to the SQL databases and they test successfully. I have turned off the Personal Wirewall on my laptop. I have looked at my security settings and I can not see the problem. It all works fine on my old laptop running on WN2000 Pro. I tried to relink through the link table manager and changed the server name to the new laptop name but I cannot link. It must be something with XP but I don't know what. I need to finish a class project this week.
Thank you for your help
Roxanne
Please describe the steps you take when doing this and the version of your access application, thanks.
Please describe the steps you take when doing this and the version of your access application, thanks.
Hi there, i have been searching for a possible solution to this problem, as i have exactly the same problem on my laptop - XP Pro. I am able to use ODBC database connectivity from MS Excel and link to SQL databases that i have set up in the ODBC administrator under Control Panel. However, from MS Access, i can link tables to other files, but when i select to link tables to ODBC databases, nothing happens, no error message or anything, just nothing.
Hopefully someone has some light they could shed on this for me.
Thanks
I am using MS Office 2003 Pro on an XP Pro sp2 laptop. I installed the complete setup when I installed office so that I would get all functionality. Yhe steps are: right click on tables in access,click on link tables, choose ODBC databases as type of data source and absolutely nothing happens. The screeen does not come up as it is supposed to so that I can choose my sql database. My ODBC connection to my sql databases test successfully. I am using MDAC2.8. This is the first XP Pro machine that I have had do this. There has to be some kind of setting somewhere that is causing thisl.
This is really interesting, I am recreating the steps just fine in my database, so here is what I do, I open my database page and under "Objects" on the left side I right click on Tables and chose "Link Tables..." then the screen comes up and on the bottom where is says "Files of type:" I choose "ODBC databases" and "Select Data Source" comes up.
Try doing this and tell me what happens.
Good luck Cyberdyne!
The steps that you list are exactly the steps that I do but nothing happens. There is window that pops up to go any further. If I choose to connect to another mdb then I get the next screen but if I choose ODBC databases, I get nothing. There has to be some setting somewhere preventing the ODBC connection. I am at a lose.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Random Person |
last post by:
Does anyone know how to use VBA to relink tables between two MS Access
databases? We have two databases, one with VBA code and the other with
data tables. The tables are referenced by linked tables in the database
where the code resides. If we move the database with the data tables to
a new directory, the links are no longer valid.
I tried to update the links by changing the Connect property and refreshing:
Set td = db.TableDefs(0)...
|
by: David |
last post by:
Hi,
We have an internal network of 3 users.
Myself & one other currently have individual copies of the front-end
MS Access forms and via our individual ODBC links we have used the:
File > Get External Data > Link Tables > select ODBC Databases
facility to link to our back-end MySQL Server. On both our machines
the tables appear in the window very quickly and if we hit 'Select
All', all the tables start loading really quickly into our...
|
by: ZRexRider |
last post by:
Hi,
I have an application that uses MS-SQL Linked tables. I have a utility
routine that drops all links and re-establishes them. It works great
when my connection string is a DSN connection but I would like to
change it to DSN-Less so users don't have to set up ODBC connections on
each workstation.
If I use the following DSN
|
by: Tim Frawley |
last post by:
I am attempting to change the ODBC Link Provider String in an Access
database linked to an Oracle server using ADOX in VB.NET.
I created some code using the example from post:
http://groups.google.com/groups?q=RefreshLinkedTablesWithADOX()&hl=en&lr=&selm=qb1ctvcdoftenojhpp34lb6fjb9ss8qd9c%404ax.com&rnum=1
My code simply replaces the DSN, UID, PWD and DBQ values in the
ADOXTable.Properties("Jet OLEDB:Link Provider String").Value string...
| |
by: Lisa |
last post by:
I have an Access 2000 application that uses the following function to
re-link my tables when I switch from my Current back end to a Dummy
back end. I also use it to refresh my links.
Function CreateODBCLinkedTables() As Boolean
On Error GoTo CreateODBCLinkedTables_Err
Dim strTblName As String, strConn As String
Dim db As DataBase, rs As Recordset, tbl As TableDef
Dim DatabaseName As String
Dim ServerName As String
|
by: Tracey |
last post by:
I have a Mysql database hosted on a remote server. Previously, I could
always connect to those databases using the 3.51 ODBC connector and
linking the tables in Access. The benefit of this is that I can view
the data from my desktop, export it to spreadsheets if necessary and
print labels.
I guess because of a Mysql upgrade by my host, the 3.51 connector
stopped working (the password hash problem), so I upgraded to the 5.*
ODBC...
|
by: Neil |
last post by:
I just started using Access 2003, and I can't link a SQL Server table. I
right-click on the database window; select Link Tables; and select ODBC
Databases from the Files of Type dropdown. As soon as I select ODBC
Databases from the Files of Type dropdown, the entire dialog box disappears.
No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one, and...
|
by: brucedodds |
last post by:
I've inherited an A2003 application with linked SQL Server 2000 tables
in the back end, using the Microsoft SQL Server ODBC driver.
We've set up a test SQL Server database. I'd like to automate the
process of relinking the application to test/prod.
I've found some code examples here of relinking ODBC back ends to
different databases, but they involve deleting the table before
relinking. My concern is that the primary key information...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |