Questions tagged as 'ms-access'

Tagged questions
1
answer

Problem connecting to Access in VisualStudio

I created a small database in Access and I am trying to connect to VisualStudio, however it gives the following error message:    Unrecognized database format 'c: \ Users \ wss \ desktop \ dbteste.accdb' How do I fix this?     
asked by 26.09.2017 / 21:28
1
answer

C # Oledb truncating column excel

I'm doing a select in an excel where I have an observation column (open text). The problem is that on some lines it truncates the contents of that column by bringing only one part. try { conn = new OleDbConnection("Provider=Microsoft.ACE.O...
asked by 10.04.2017 / 22:40
1
answer

Update an Access application

What is the easiest way to upgrade a desktop Access application with VBA to a web application with sql server?     
asked by 22.04.2017 / 00:58
1
answer

Export SQL query data to Excel

Good afternoon guys. I created a database to control receipt and delivery of cards. The inclusion of the data is done through a form in excel. This form also has the option to query existing data. the query returns the information in the f...
asked by 30.03.2017 / 17:29
1
answer

Change path linked table ms access

I have 2 databases that I use to copy them from the server to the user's local machine. Between these two banks I have a linked table, so when I copy to the local machine, I need to update the address of that linked table. I saw some forums w...
asked by 28.03.2017 / 20:39
1
answer

Save results from a query to an array

Good afternoon! I need to get the results of this query: sql = "SELECT controle.ID FROM controle WHERE BP = '" & controlectform.nmbpbox.Value & "';" And save to an array. Subsequently I will do a for each in that array and I will...
asked by 03.04.2017 / 21:40
1
answer

Changing customer information via ID

I can not change the customer information through the Code that makes changes to the database public void Atualizar(Contato contato)//metodo para atualizar dados: update { OleDbParameter[] parametros = {...
asked by 15.11.2016 / 18:09
1
answer

How to count how many instances of a program are running from a shared folder?

I'm developing an application that runs from a shared folder. In the same folder is the Access database. To avoid conflicts in Access, it will only be allowed to be run by only one user at a time, so two users on different machines are not allow...
asked by 22.09.2016 / 15:14
1
answer

How to copy multiple excel files into an access 2010 database using vba [closed]

I'm new to VBA programming. I need a vba code in excel that copies several excel files to an access table.     
asked by 18.05.2016 / 20:41
2
answers

Job created in SSIS does not work in SQL SERVER AGENT

I have a job created in SSIS (working perfectly) that does not work in SQL SERVER AGENT. The job extracts some data from an access table, via ODBC, and loads into a sql server local table. The Sql Server and the access database are on different...
asked by 14.01.2016 / 17:03