473,799 Members | 2,885 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to link odbc tables using VBA

MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi everyone

I am using this as a test question to test the new Rate up/down feature for threads and posts. For anyone looking for a legitimate answer to this question please check out this insight.

Now anyone can post a reply here either commenting on the answer or anything else (withing site rules) and others can use the new up/down feature. Please feel free to post as many comments as you wish so we can thoroughly check out this feature.

Mary
ADMIN

BTW the icons don't always load on page refresh (bug to be fixed) but if you refresh a second time you should see them.
Apr 7 '10
81 6423
Frinavale
9,735 Recognized Expert Moderator Expert
When I click the vote "thumbs" I get the error message.
Apr 8 '10 #31
Niheel
2,456 Recognized Expert Moderator Top Contributor
yep, i'm just debugging the creation of the PM, thanks for the help ;-)
Apr 8 '10 #32
RedSon
5,000 Recognized Expert Expert
this is why the internet invented test servers... things are "beta" for a reason.
Apr 8 '10 #33
Niheel
2,456 Recognized Expert Moderator Top Contributor
please what else can go wrong today,
Apr 8 '10 #34
Niheel
2,456 Recognized Expert Moderator Top Contributor
@redson, just think of htis as beta, it's not available to the rest of the site, just you my special one ;-)
Apr 8 '10 #35
Niheel
2,456 Recognized Expert Moderator Top Contributor
so by now someone of you got the special, you've been upvoted messages ;-)
Apr 8 '10 #36
Niheel
2,456 Recognized Expert Moderator Top Contributor
if i could, i would upvote you all for helping test this ;)

someone suggested, we should changed it to . . . "i love you" | "i love you not"
Apr 8 '10 #37
Niheel
2,456 Recognized Expert Moderator Top Contributor
I suspect when we unleash this, it's going to crash the servers, it's just one of those days . . . when all things that could go wrong, will go wrong
Apr 8 '10 #38
RedSon
5,000 Recognized Expert Expert
seriously kub, if i get more than one of these "you've been upvoted" messages per day, I'm adding bytes to my spam filter. Then I'll be writing a greasemonkey script to prevent vBullitin from popping up something telling me that i have a new PM.
Apr 8 '10 #39
MMcCarthy
14,534 Recognized Expert Moderator MVP
@KUB Now you're just tempting fate :D
Apr 8 '10 #40

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

Similar topics

2
3356
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...
3
1928
by: David | last post by:
Hi, We a have a small office network of 3 users. Each user has their own copy of an MS Access Front-End which is linked via their own local ODBC connection to our server's MySQL database (Linux Machine) 2 of our 3 users machines can import/link the data back into their front-ends instantly. The third machines will connect, but it is so ultra slow that you just cannot import all the tables and use the
1
3802
by: Paul | last post by:
Hello, I am converting an Access database on our network to a sql 2000 backend and keeping access as the front end. The access database has evolved and been a solution to collect data but now we want to move the tables over to sql 2000. We have successfully done that but are now having difficulties with an ODBC connection. Initiall linking the tables is not an issue and I am able to connect with no problem. However after closing down...
8
16238
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
2
8658
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...
0
2577
by: RLN | last post by:
I have a Microsoft Access2002 database that needs to connect to an Oracle Database. I need to map 2 tables from the Oracle DB to retrieve the proper data. I read somewhere (quite a while back) that if you use ADO in Access, you can connect without the need for ODBC, TNSNAMES.ORA and the Oracle client installed on the user's desktop. If I use the Microsoft driver for Oracle, is it possible to connect to an Oracle DB using straight VBA
7
4087
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
4
4032
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...
26
7432
by: Troyerrm | last post by:
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...
8
3045
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...
0
9685
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, 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...
0
9538
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,...
0
10249
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10219
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10025
tracyyun
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...
1
7563
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6804
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5584
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3755
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.