Connect to external .mdb

I need to connect to an external .MDB (version 2.0) and run queries against it from within a form. The database requires that I enter a password. Which connection type should I use?

Sponsored Links:

Related Topics

Import external ACCDB/MDB without specifying table name
This should be simple but.

I have an automated function to import external Access tables to my database (there is only ever 1 table in the external ACCDB/MDB), BUT the names of the external tables are different.
How can I import a table without specifying the name? (ie default import the only table abvailable)

DoCmd.TransferDatabase acImport, "Microsoft Access", Me!_txtPath, acTable, TableName, "tbl_MyTable", False


Access Lockdown
If I create an mdb and used this mdb to store all the tables. If I then link these tables to another mdb and use this mdb to write my code.

I have a mdb that has only tables
I have a 2nd mdb that links to these tables and also has all the queries, forms,

Can I modify the 2nd mdb to:

2. Not allow them to view the tables, forms, queries, macros etc.
3. Can I remove the Ribbon.and all tools including the Home, Create, External Data, Database Tools, and Acrobat

Where their only option to click will be within the forms I create?


Access Database - Connect to External Hardware
I have an existing Access database application that I have been asked whether I could connect, via USB, to an external security system from which to read and store data.

At this stage pretty much all I know is that there is a DLL file that will create .TXT files that my database would then be able to read and convert into usable data.

Has anyone any experience or knowledge in this area?

e.g. VB code to pass commands to the external hardware (using/via the DLL perhaps) and calling/creating the required TXT files


Enums as Global Constants
Is there a reason why I cannot create a Global Const of type Enum ?

Public Enum EnvironmentStatus
DevelopmentEnvironment
TestEnvironment
ProductionEnvironment End Enum Global Const g_EnvironmentStatus As EnvironmentStatus = DevelopmentEnvironment Sub ConnectTables()
Dim db As DAO.Database, t As DAO.TableDef
Set db = CurrentDb
For Each t In db.TableDefs
If InStr(1, t.Connect, "CB.mdb") 0 Then
Select Case g_EnvironmentStatus
Case DevelopmentEnvironment
t.Connect = ";DATABASE=P:\DatabaseDevelopment\CB.mdb"
Case ProductionEnvironment
t.Connect = ";DATABASE=P:\CB_Live\CB.mdb"
Case TestEnvironment
t.Connect = ";DATABASE=P:\DatabaseTesting\CB.mdb"
End Select
t.RefreshLink
End If
Next
End Sub


Microsoft Access, Help Connecting to a FTP server
I am trying to figure out how to access a database on a FTP server that requires a username and password while using only microsoft access.
The files that are on the database are in a .mdb file format which is what access uses.
Currently I can connect to the ftp server and view the .mdb files using a cruddy third party vendor software that has no options for reports or sorting (which happens to be why i need to figure out how to connect to the server with Access).
I know all of the information such as the ip address, username, password, port etc.... that is required to connect.... i just dont know "how to connect" using Access. Any help would be appreciated.


Value into text
When I connect a mdb to excel certain collumns in excel contain number (1,2,3).
These numbers represent text 'value1', 'value2','value3'
Is it possible tot connect these text to the value from the excel sheet (table in access)
(the sheet is a dumpfile from another system, and I dont wont to change the values in excel, only in mdb, preferably by a query


User always appear to connect with exclusive rights
We have an access DB that has the default security on it so that anyone that connects to it they connect as 'Admin'. The front end of the app is using Access forms and the data is in sql so their are link tables defined.

mdb file, the NAVIGATION form comes up and they can goto where they need to go. The problem were having is if user A, opens the .mdb file it is always trying to connect with exclusive access.

If no one else is in the app when user A opens it, she is able to but then if user B or user C and so forth tries to open it when user A was the first one to open it, they are locked out.

Now, if user B opens it first users C and so forth can get in with no problem, but User A gets messages that she doesn't have exclusive rights and any changes if made could be lost.

What I can't figure out is why User A keeps trying to connect exclusively when she is not even the user that created the applicationand when user A tries to open it, how do I change her to open it with shared access.


How to select from MDB file through external tools
Is there any way I can make use of the T-SQL command to select from 1 or more MDB files? At the same time, export the result to an csv/notepad.

In my environment, I am using Access Viewer only


Manipulating Import Specs
I use a range of Import Specs to connect external (text and csv) data to an mdb database. This works fine.

However, I would like to create and adapt these specifications using VBA and am not sure how to handle this. Are there (maybe?) internal/system tables that handle these specifications? And is it possible to access these programmatically?

Many thanks for any tips/links/howtos that you can give me.
Alan Searle
Cologne and Bonn


Access connection errors, Drivers Failed
When trying to connect an external database from another software with Access 2007, I get the following Access error message: Error! Unable to connect to database: [Microsoft] [ODBCMicrosoft Access Driver] General Error Unable to open registry key Temporary (volatile) Ace DSN for process 0x179c Thread 0x11c8 DBC 0x18e7b614 Jet'.

When I open the ODBC data Source administrator and double click on the Microsoft Access Driver, I get the following error message: Microsoft ODBC Administrator. The Setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC driver could not be found. Please re-install the driver.

When I then click OK, I get the following error message: Driver's ConfigDSN, ConfigDriver, or ConfigTranslator Failed. The Specified DSN contains an architecture mismatch between the Driver and Application.


Connecting to Access ODBC behind a router
I've set up a calendar interface in javascript/php that reads data from an Access DB. Right now it works fine on our intranet, but I want it to set it up to be accessed by external users on the web. If I move the front-end javascript/php hosting to an external host, how would the php connect to the Access 2007 DB on our server?

The Access server is running windows XP, it is behind a router, has only been used in an intranet capacity thus far, and I'm not sure how to make it's ODBC connection visible to external users...


SQL MAX function not working correctly with external data
Access 2010

I am trying to produce a query to return the highest value in a list of dates:

SELECT max(Table1.checkin) as maxcheckin
FROM Table1

The strange thing is, that whilst this works on a local table, if I try to run the query on an external table from an old version of access (I think 2000) with a .mdb extension,

It is always the same wrong value although I have not been able to establish why it picks the value it does. There are over 19000 records with timestamps like this:

checkin
24/07/2012 18:28:08
24/07/2012 18:20:45
24/07/2012 18:15:35
24/07/2012 18:06:56
24/07/2012 18:06:39
24/07/2012 18:06:35

is there a known problem with the SQL MAX function when using external data?


DSN Less connection string for Access Database
I am using Access 2010 database and have installed Access Database engine X64 in windows 7 64 bit machine.

I want to connect the database with DSN less connection string.

Connection string that I have made is like this :

CDatabase m_db;
CString strConn = _T("{Driver={Microsoft Access Driver (*.mdb,*.accdb)};Dbq = C:\\TestFolder\\TesDB.mdb");
m_db.OpenEx(strConn, CDatabase::noOdbcDialog);

I am not being able to connect the database. Does anybody knows the connection string format for connecting with Access 2010 database using DSN Less connection.


Pull Info From ACCDB
I'm pretty new to SQL in general so please bare with me. I've done simple SQL queries on MDB files before but never on a database this complex before.

If I can just connect to it, I will try and stumble my way toward picking data out but first I need help with the connection.

I have SQL Server 2008 R2 Enterprise installed. Can I use that to connect to an Access 2010 database file?

Anyway, this is some code I have been trying to modify to work with the Access 2010 DB:


Connect To SQL Server
I have Msacces 2002 .mdb and I use the adodb connection with MSDE.
On my machin it works FINE.
On the uther machin it also Fine. befor I compile it.
After compilation on my mashin it also warks but it not warks on an uther mashin. connect error
But if I compilling on the uther machin. program wark fine on both machin.
I dont anderstend wy


Using Access2003 to link to Paradox DB files
I have used an Access 2003 MDB to link to two .db files in a Paradox Database while the PC is running with Windows XP.
The Paradox Database is located within a sub-folder in "Program Files". There has been no problem, so far.

I have now transferred both the Access MDB and the Paradox database to a new PC running with Vista Home Premium.
The Paradox Database is located within C:\Users\Public\Public Documents (by the Program which normally reads/writes to them, and still works) and the Access MDB is located in a sub-folder on a D:\ Drive.

I can open the MDB and attempt to re-link to the .db files, but an error is flagged up by the Linked Table Manager "Unexpected error from external database driver (11265)" with an OK button to close.

I have tried copying the Database and the Access MDB together to a folder on the D:\ drive, but the same error message appears.

I am unable to find any mention of this message in Microsoft Knowledgebase - can anybody advise, please


Updating a Database Automatically
I have Database.mdb, with several copies of FrontDatabase.mdb, on different machines, all of which use linked tables from Database.mdb.

Both are still in the construction stage - essential features work, but I am constantly modifying reports/queries to correct bugs and adding reports/queries as requested.

At the moment, I have to modify the database on my computer, then go round and copy it across to theirs.

What I would like to do is:

1) When I fix a bug in a query, for example, export it to directory [LINK] as a file.

2) Send them an email, prompting them to press a button, or run a saved "Import External Data" procedure that will look at this folder and copy in any reports/queries that arethere: replacing existing ones if they have the same name.

3) Ultimately, when the database is a little more final, I would like this to happen automatically when it is opened.


How to connect to the tables
I just changed the linked tables from "C:/Access/my_be.mdb" to" //Server/Access/my_be.mdb"

I did it in the office while connected to the "Server"

Now away from the office I need to make some changes to the "front end" but can't access the linked tables and "my_fe.mdb" won't start


Administer ODBC data sources
Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server. This article contains general information about ODBC data sources, how to create them, and how to connect to them by using Microsoft Office Access 2007. The procedure steps might vary depending on the specific database products and ODBC drivers used.


using mdb files which are backed up hourly into zip files
I am new to access and am seeking advice on how to deal with the the following: Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.
What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?