Access 2010 Questionssubmit your own question

I have local .NET program with Access DB running on Windows 10 local computer. I want the DB to be on web site www.xyz.com/files/db.accdb and the local Win program will be able to read/write from/to it.

I'm setting up new pc workstations with office 365 for business which includes Access. For year's i've been linking FoxPro database files to access accdb files.

Is it possible to supply a database password that is let's say supplied when the user logs into the website. Example "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\MyName\Documents\mywebsite_assets\database\database.mdb; Jet OLEDB:Database Password=" + strPassword

Fingers crossed someone can help. I am looking for a connection string to use in MS Access 2010 to connect to Oracle using SqlSriverConnect so that I can specify SQLDRIVERNOPROMPT. My attempts to format a connection string to date have been unsuccessful. Please accept my thanks in advance.

Trying to create an updatable form in Access 2010 connected to sql server 2014. I Don't want to use linked tables as many results will be provided by stored procedures. Using

I have an access database on a web server with CPANEL and I want to connect an application created in Visual Basic .Net 2010, I want to be able to connect to it and modify data, but I can not find the connection string ... I hope your answer thanks!

Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .

Access 2010 includes an option checkbox "Open databases by using record-level locking" (under Client Settings). Is there an ODBC connection string to enable or disable this option from a program?

I am using Access 2010 accdb database and wants to connect a C# program using the oledb provider 'Microsoft.ACE.OLEDB.12.0' but it does not seem to work as I get this error.

Good afternoon, we're using SSRS reports and have a C# .dll to run the reports from an Access code program. the server name has a '\' in it, and when trying to run the report through the dll, it's raising an error.

I have a problem that I don't understand. I have two VS 2008 programs one gives me a Crystal Report just the way it should work. connection string in App.Config "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\QBData\racklist.accdb"

I have an MS Access 2010 32-bit database that is primarily a front-end. The data is stored in an SQL Server 2008 R2 managed by my company's IT.

I am using .NET Framework 4.5,Microsoft Access 2010 64 bit. I've getting an error in asp.net when it is connecting with access. I've also installed 64 bit ACE engine from this link:-

I have installed IIS 8.5 on my laptop with Windows 8.1. I have placed my website in c:\inetpub\wwwroot and given all the security permissions required. I am using MS Access database 2010 and configured all the features required.

Wonna select table-rows in sql-server (2012) from access (2010) 3 different ways testet, but all dont function: SELECT * FROM 1) [Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=H:\Temp\REALUMSATZ.accdb;

Hi! Problem: I have been linking programmatically to DBF files for 15+ years in different Access versions (currently 2010) OK. The client outputs the DBF files via R:BASE . . . previously DOS version, now upgraded to a Windows version.

Hello Background: I'm running an ASP Classic website with Access 2007 databases. In the local site (which is now failing as per below) I'm under IIS7.5 and Windows Home Pro 7.

First for some background on my situation: I am working in Access 2010 user frontend with a Microsoft SQL Server 2008 backend. I have a stored procedure that inserts new values(supplied by the parameters) into a table.

hai I am getting an error called 'UserInfo' is not a member of 'User'. in the following code Select <% Dim i As Integer For i = 4 To 7

I have a back of my base on ftp. Now I working on my base using front which is in local network. But I would like to work online. So I have to connect to my base from the Internet. I read about connection string.

Hello there, I have developed an application and throughout looking on the web, I couldn't find the solution to my problem. I am using Visual Studio 2013, Office 2010 32-bit and Win7 64-bit to devel

I have an 2010 Access Database where I am using a connection string to link (via MA Access Query) to a table on our SQL Server. I am using the connection string below. and it pulls back the table jus

Hi, how looks like the connection string ???? for SQLite with ftp via VBA conn.Open "DRIVER=SQLite3 ODBC Driver;Database=???????????;Password=xxxxx;" Thanks

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

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