All Questions
Tagged with connection-string ms-access
119
questions
73
votes
2
answers
117k
views
Persist Security Info Property=true and Persist Security Info Property=false
For the properties:
Persist Security Info=true
and
Persist Security Info=false
Can you tell me what is the difference between them, and if I don't put it in my connection what will happen?
...
- 761
42
votes
8
answers
202k
views
Error: "Could Not Find Installable ISAM"
I've written some VBA code in an Excel workbook to retrieve data from an Access database in the same directory on a desktop. It works fine on my machine and several other machines running Windows XP, ...
- 1,488
18
votes
1
answer
1k
views
ODBC problems in SQL 2000 --> 2005 Upgrade
This wiki post outlines both a problem and a solution. I wanted to post this for others that may be having similar problems, as I couldn't find anything specifically to solve this problem elsewhere.
...
13
votes
2
answers
31k
views
Readonly connection string to an access database
I'm trying to connect to an Access database file using a System.Data.OleDb.OleDbConnection. I need to connect in readonly mode because another application uses it at the same time. I can connect to ...
- 371
9
votes
3
answers
21k
views
Entity Framework with Microsoft Access
I use .accdb file. I created class
using System.Data.Entity;
class MSADbContext:DbContext
{
public DbSet<Product> Products { get; set; }
}
and add connectionString
<...
- 384
8
votes
3
answers
22k
views
With VBA, find the version of the MySQL ODBC driver installed in Windows
Using Visual Basic for Applications, how can I find out which version of the MySQL ODBC driver is installed in Windows on a user's machine?
I have a Microsoft Access application that uses the MySQL ...
- 32.8k
6
votes
4
answers
15k
views
Excel Data Connection Locks Access DB, Prevents Second Connection's Refresh
I have two data connections to different queries in the same Access DB. The second one always fails (regardless of which I run first).
When I look at the database, I notice that it has a lock file, ...
- 645
5
votes
1
answer
38k
views
ADODB Connection String: Workgroup Information file is Missing?
I have a few data sources in access that I need to connect to programatically to do things with behind the scenes and keep visibility away from users.
Said datasource has a password 'pass' as I'm ...
- 1,627
5
votes
3
answers
22k
views
The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine
Iam using ms access as a database .mdb file
how to get the ms access drivers 2007 .
i got the error :The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.
4
votes
1
answer
7k
views
Using a relative path in connection string for Access DB in C#
I'm trying to get this line in my web.config file to use a relative path instead of hardcoded one, but nothing seems to be working. I can only find stuff for SQL and mySQL DBs
<connectionStrings&...
- 169
4
votes
5
answers
8k
views
Connecting MS Access to PostgreSQL Server
I'm having trouble with connecting to our postgres server. I was given the code used to connect ms access to our SQL Server. It shall be DSN-less, I have installed an ODBC-driver and now I'm stuck ...
- 183
3
votes
3
answers
4k
views
SQL Server does not exist or access denied (intermittently)
I use a Microsoft Access 2010 front end with linked tables on an SQL Server 2012 installation. Local network.
When Access Starts, a VBA script runs which connects to the SQL server and performs some ...
- 724
3
votes
3
answers
6k
views
What is the ConnectionString to create a OdbcConnection for an access mdb file
I want to connect from c# to an Access MDB file by using Odbc.
When I try to execute
OdbcConnection con = new OdbcConnection(
"Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\temp\\test.mdb;");
...
- 3,177
3
votes
2
answers
7k
views
Changing SQL connection information for DSN-less Access frontend
I've got a mission-critical Access 2003 database that changed from a local MDB, to an MDB frontend with the backend on MS SQL Server 2005, using the Microsoft SQL Server Database Migration Assistant (...
- 51
3
votes
0
answers
2k
views
Prevent opening data sources Read-only when refreshing pivot table with external connection
Normally I have all my questions answerred with topics from Stack Overflow, but now I ran into some difficulty to which I cannot find me a working answer.
Brief explanation what I am trying to ...
- 31
3
votes
0
answers
1k
views
DSN-Less connection in VBA to two different iSeries LPARS generates Error 3011 to one of them
This question is not about dsn-less connection strings in MS Access per se (which I can build successfully). The following string worked just fine last week when connecting to our iSeries from MS ...
- 51
3
votes
1
answer
3k
views
Is it possible to use VBA to change the Current accdb/e Database password
I have a personal DB app that was initially designed using the mdb format in Access 2007. For security reasons I've converted it to .accdb. All functions converted fine except the change DB password ...
- 171
2
votes
4
answers
27k
views
how to open access database with password in C#?
how can I open an MS Access 2007 database with a password in c# ?
I have tried this: Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\BioDB.mdb ;Password=1966;");
but it ...
- 61.9k
2
votes
4
answers
8k
views
What will be connection string to Access database file with PHP
I installed WAMP, I have access database file in project folder, but don't have installed Access on my computer.
Can I read and update Access file with PHP even I don't have installed Access?
And ...
- 1,804
2
votes
3
answers
1k
views
Moving ms access driven site from sql server to jabry.com - connection string problems
I've done a fair bit of mysql php programming but am pretty new to asp/access etc.
This will either be incredibly easy or impossible!
SUMMARY:
I'm trying to transfer a web application from a ...
- 2,112
2
votes
2
answers
18k
views
Connection string for opening linked table Access -> SQL server (vba)
I've been looking for the answer as there are many similar questions, but haven´t found this particular case.
I have an SQL server, and an Access File (front-end). This Access file has linked tables, ...
- 171
2
votes
2
answers
9k
views
Attempting to connect to Excel spreadsheet in C#
I am trying to pull a bunch of data from a spreadsheet, however I am not able to make a successful connection in my C# code. B
Below is the connection string and the code that I am using to make the ...
- 10.5k
2
votes
1
answer
193
views
TableDefs.Connect missing semicolon: "ODBCDRIVER=" instead of "ODBC;DRIVER="
Just noticed this morning that when I try to get the connection string from a SQL Server linked table in VBA, it starts with "ODBCDRIVER=" instead of "ODBC;DRIVER=". I am getting ...
- 35
2
votes
2
answers
2k
views
Using non-ascii characters in connection string password
I'm writing a utility to work with a bunch of legacy Access '97 .MDB files. I need to connect to them programmatically, and I am not allowed to convert the files to a newer version of Access. So far,...
- 153
2
votes
1
answer
10k
views
how to connect to access 2007 with c#
hey,
i am new at connecting to dataBases and for some reason each time i use those following lines my program collapse:
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;DataSource=|...
- 2,657
2
votes
1
answer
48
views
Looking for a different SQL provider / connection string
I want to connect to a Microsoft Access 2007 Database file (.accdb). I use the following provider to connect to the database and it works fine:
OleDbConnection con = new OleDbConnection();
...
- 601
2
votes
1
answer
318
views
Most reliable solution to determine whether to use ACE or OLEDB in connection string?
I'm handed a path of an access 2000(/2003 (edit)), or access 2007 database:
C:\database.mdb
or
C:\database.accdb
I have to determine a suitable connection string, using either ACE or JET, to ...
- 2,677
1
vote
1
answer
1k
views
How to connect with a database on Access inside a intranet
I have made connection with sql server but i have never done a connection with access and
now this isn't in the computer local, if not it is going to be in a server
users are going to full the form ...
- 4,552
1
vote
1
answer
808
views
Connection String for Ms Access in ADF Linked Service
I have been trying to create MS Access Database Linked Service in Azure Data Factory.
The format I have been using is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\server\share\folder\myAccessFile....
1
vote
2
answers
3k
views
MS Access - prevent SQL injection in connection string
I have an Access database that must connect to Oracle programmatically to create a linked table. The connection string is of the form:
ODBC;Driver={Microsoft ODBC for Oracle};Pwd=<Password>;UID=...
1
vote
1
answer
781
views
Error connecting MS SQL Server 2005 View with MS Access 2003 query
Problem: Could not find installable ISAM
I am executing a query from MS Access in order to pull information from MS SQL Server 2005.
When I attempt to open a linked ODBC connection to the table ...
- 4,970
1
vote
1
answer
8k
views
DSN-less connection to mysql server in ms-access not remembering user name and password
For ease of distribution I want all the mysql linked tables to be DSN-less. I also want to be able to relink the tables to a different server easily (for test purposes), so I'm doing the link setup in ...
- 2,191
1
vote
1
answer
501
views
problem connecting to access database in asp.net 2.0
hi im trying to get a dataset from an access database
im using this connection string:
<connectionStrings>
<add name="SiteConnString" connectionString="Data Source=c:\inetpub\vhosts\db\...
- 4,700
1
vote
3
answers
442
views
vb access database password
how can one create a password on a visual basic access database when you have a vb datagrid
kwame nkrumah
1
vote
1
answer
44
views
"dbo_" Missing From DNS-Less Connected Tables
I've had a DNS-less connection to my SQL Servers for years... but all of a sudden some (not all) of the tables are coming across WITHOUT the "dbo_" in the table name. I need the "dbo_&...
- 35
1
vote
1
answer
2k
views
Retrieve password connection string Microsoft access ODBC
I have an old Microsoft Access program for old client in my company and they forget the connection string. I have linked tables to SQL server database using ODBC - can I retrieve username and password?...
1
vote
2
answers
1k
views
Query data from SQL to MS Access: Local Tables vs Pass-Through Tables
I've created an application that uses the following logic to query data from SQL to my MS Access App.
Using an ODBC connection I execute a stored procedure
Using This is assigned as a Pass-Through ...
- 972
1
vote
1
answer
2k
views
Could not find installable ISAM
i need help. i encountered error after compiling my system in vb.net
Here is my code
Dim dtStudentPermit As DataTable
Dim dtExcelData As DataTable
Public constring As String = "Provider=Microsoft....
- 119
1
vote
1
answer
666
views
Get db path outside of web app folder on server using Asp.Net
I published a web app to a server and I would like to access a database file (.mdb) that is also stored on the server in a different location outside of mine. How can I do this in the web.config file ...
- 1,810
1
vote
1
answer
3k
views
Log in and password using VB6 and Access 2007
I'm trying to create a VB6 application linking to Microsoft Access 2007. I'm going to save account names and passwords in Access 2007. I'm using VB6 as the front end. Would somebody help me on the ...
- 235
1
vote
0
answers
127
views
File already in use with database MS-ACCESS in VB.NET
I'm trying to open the database by access and then I run the application in vb.net then an error appears
File already in use.
If I don't open the MS-ACCESS database then running the application has no ...
user22579796
1
vote
1
answer
1k
views
Error when opening ADODB recordset using odbc dsn in MS Access
I have a MS Access application that has been in use for at least 10 years. Recently I moved my work to a new development machine with Office 365 and SQL Server Express 2019 installed. The machine OS ...
- 129
1
vote
0
answers
364
views
Connection string with a network password
I have a problem when centralizing a database. (I will not use MySQL etc.. since this is only a small application. I will use access only.)
Problem: Code won't run because there is a password on a ...
- 73
1
vote
2
answers
938
views
OleDb connection to an Access database
I've been trying to write to a database and save to the file but I cant get it to work, can't tell why either.
The error I get is:
Exception thrown: 'System.Data.OleDb.OleDbException' in System....
- 115
1
vote
1
answer
561
views
Excel 2010 compatibility with Access 2013
We created an Excel application using Excel 2013 that connects to an Access 2013 database that's stored on a network drive (all associates have access to). It uses "Microsoft Access Database" ...
- 3,729
1
vote
2
answers
1k
views
how to Connect a C# project with database on the local network to edit and view?
I have a Data Entry C# Project,
I want to make it run on three computers on the same network and make their database on the network so everyone can see the edit of the others on the file i am using ...
- 117
1
vote
1
answer
409
views
ConnectionString property. The connection's current state
Here is the current coding for my login form
Option Strict On
'-------------------------------------------
' Imports required for DB Connectivity
'------------------------------------------
Imports ...
- 81
1
vote
1
answer
226
views
How to connect a MS acess file(MDB file) to asp.net webform?
Is this connection string correct?
con.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=k:\Users\kaarthick\documents\visual studio 2012\WebSites\WebSite8\Database\Database1.mdb;";
...
- 821
1
vote
0
answers
93
views
connection string to db access
I have a finished project in aspx.cs everything it's working. It's time to see the light, time to publish.
I also have a folder with the database "db/database.accdb"
however before publish I need ...
- 112
1
vote
1
answer
3k
views
What is the ConnectionString to create a OdbcConnection for an access mdb file in x64?
Extending on this question What is the ConnectionString to create a OdbcConnection for an access mdb file , I'ld like to know how to write the connectionstring to connect to an .mdb file from a 64bit ...
- 3,177