| |
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: 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
|
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...
|
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: 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
|
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: 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...
|
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: 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: 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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
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,...
|
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: 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...
|
| |
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
14,534
