Here's the setup: MS Access has a linked table to SQL Server. SQL Server has a password on it. Trying to use Excel VBA to query this linked table in Access, but I can't get the connection string co
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. How can i solved this problem??
Hi, I am a new for VBA programer. Basiclly I want connect MS access database from MS excel. I use MS access 2010 and MS excel 2010 at Windows XP. But I get an error say: Run-time error '3706'
I have Access 2010 installed on Win8/64-bit machine. Am using a VBscript in a .HTA file. Trying to connect to .ACCDB using ODBC. I know I'm accessing the database as I am getting a field count corre
I am using Access 2010 accdb database and wants to connect a C# program using the oledb provider 'Microsoft.ACE.OLEDB.14.0' but it does not seem to work as I get this error. The 'Microsoft.ACE.OLE
I've got an application in Visual Studio, that uses an Access database and I want to be able to save the database file on Dropbox. How do I get the connection string for an access database file locat
I've got an application in Visual Studio, that uses an Access database and I want to be able to save the database file on Skydrive. How do I get the connection string for an access database file loca
I have a VBA application running under MSWord 2007... reads and writes strings, integers and dates to Access 2007 accdb saved on a Sharepoint network location. Performance is great. Exactly the same
Sir, I am New in VB. I am using MS Access v2003 and VB v2008 I want Step by Step Help for Opening a password protected MS Access through VB.Net v2008. Please Help me in detail. Thanking You Saubhik
Im having a connection issue for Microsoft Access 2013 to my visual studio 2013. When I try to connect my access 2013 it pop up message: Microsoft.ACE.OLEDB.12.0 was not registered.
I know MS removed the DBF import export, but hopefully someone knows of a workaround. I use Access to import/export dbf files as needed for our presort software. The code is: DoCmd.TransferDatabase a
I have an access database frontend installed on multiple workstations on the network. The backend (containing the tables) is stored on a network drive. Beint new to access, and VBA, I am not sure how
Hello! I'm having an issue with connecting to my Access 2010 database through SQL Server 2008 Report Builder 3.0. I attempted using the 2007 connection string but it keeps failing. I have it set up th
I used the Access 2010 upsize Wizard to put a table on our SQL Server (2008 r2)and still use the 2010 Access database for the frontend. It works fine on my computer because I setup a data source from
Hi! (sorry for bad english) I get an error code that says (translated from swedish) "Wrong SQL expression, use Delete, Select, Insert...." Error Code -2147217900 (80040e14) rs.Open i marked The thi
Good Day Sir, Thanks for your articles on connection strings. They are quite educative and useful for beginners and experienced users. Please I have an issues that goes as follows: I have a 32
Hi, I'm having windows application and ms access database as backend.... I want to use IP address of machine, where my ms access database resides, in datasource property of appsettings in app.conf
How to connect access 2007 or 2010 with vb 6, thanks for your help. attn. gerardo g
I am currently testing the conversion to Access 2007 from Access 1997. I have discovered an anomaly in the external access process to Access 2007 databases. If you connect to the Access 2007 databas
Have a small ap that otheres want to use. Originally the ap was connected to SQLServer Express R8 via odbc with linked tables (only use 2 of the 50 tables in the db) and it works fine. Now that others
Hi there.! I've been working on our Software Analysis Development project for how many days and sleepless nights, the application is an Online Shopping. I'm using Microsoft Visual Studio 2010 as my en
When I attempt to connect to an MS Access database with the following connection string, "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;User ID=Admin;Data Source=" + strDatabasePath
I have a web site which is a subset of another web site (that's what the client wanted). I want to share the Access database between the two. What would the connection string look like? Help most
Dear guys, can i interact with database on a web space via ftp or http from my winform application? if so then whats the starting point? Why i want to do this is becuase i have A client server applica
hi all - first post - unfamiliar territory - looking for a helping hand been trying to open/use an old app - dev'd about 5 or 6 yrs ago - uses an export/import function to an Access db. I'm on Vista H
Bonjour, J'arrive pas à me connecter sur ma base de donnée ACCESS, voici le message d'erreur : le fournisseur "microsoft.jet.oledb.4.0" n'est pas inscrit dans l'ordinateur local voici la cha
Hi, I'm trying to add an RC4-128 encripted Access 2007 DataSource to my VB2010 Windows Forms Project through the Add New Data Source Wizard but, when I click the Test Connection button, I am gettin
sorry if this is a duplicate post Okay, I am using some older tools here and what I want to do should be easy but I can't get the connection right. I have a access.db setup on a godaddy hosted w
Hi all I have a question, we have been entering data into a database that has sQL Server 2005 in the background and Access 2007 on the front end for over a year. We connect to it by entering in our us
Sir, The problem on the subject sited above is resloved as per your advice for which i am indebted your credit that will never forget. Sir, another problem related to it is that report cannot gene