Tagged Questions
0
votes
1answer
36 views
Using Truncate in SQL Server from MS Access
I've spent several days on this issue, major research and lot's of trial and error attempts to find a solution. Here is what I have and what I need to make work:
Sproc in SQL Server 2008 that ...
2
votes
1answer
114 views
SQL Server Passthrough query stored into an Access VBA recordset
We've recently created and migrated our Access DB backend to SQL Server. I'm trying to, using VBA code, create a connection to the SQL Server backend and run a passthrough query with the results ...
0
votes
0answers
59 views
Importing emails from exchange server
does anybody know if there's a way to get emails from a Microsoft Exchange Server using Microsoft Access/VBA/VB.NET and IMAP?
Connecting Outlook and importing emails is no problem -
I know how to ...
0
votes
1answer
45 views
Int to numeric conversion error in SQL Server
I have a question with converting data. I have a select query made in VBA, how can I convert from varchar value column to nvarchar.
I get this error:
Arithmetic overflow error converting numeric ...
0
votes
0answers
56 views
“Write Conflict” error appears in single user database
Running MS Access 2010 front end under Citrix against SQL Server 2008R2 backend.
I've got a form that's been working for quite some time. The code behind one button has suddenly started generating a ...
-1
votes
1answer
40 views
How can I set a statement for sequence to use 50000 series in VBA?
My Statement:
Ucase([Area] & '-' & [CorCat] & '-' & [Task] & [JobNo] & '-' & [Sequence] & [Suffix])
I want [Sequence] to set as 50000 series. At the moment it is ...
0
votes
0answers
142 views
Improve Performance - Access VBA / Huge number of Inserts / Index / Caching / SQL Server
Bewlow is my Input table , code and Output Table.
For small data InputData having 3 - 4000 records this is completely perfect.
However ,
My Input data table has 90,000 records.
And there can be ...
0
votes
2answers
780 views
Multiple databases in MS Access VBA?
This Microsoft KB article details how to run a query on another database than the current one used by the Access project. However it only states how to connect to DBase, Foxpro, Paradox, BTrieve and ...
0
votes
1answer
529 views
How to link Access table to SQL Server with VBA
I am trying to create a linked (or imported) table in Access with a SQL Server backend. Basically the business users periodically need a copy of the table {SQL Rulesnew] (yes, with the space, sigh) so ...
1
vote
1answer
320 views
why does “SELECT 1 from <table>” cause a LCK_M_IX on another process doing a DELETE
I have a table listing patient_clinic_visits. I have SQLSERVER 2005 backend. Access2010 frontend.
Each morning this table needed refreshing from a data dump from the hospital mainframe.
this data ...
0
votes
0answers
126 views
INSERT trigger from SQL table
I have a database running on a SQL server that handles entries from a piece of commercial software. There are essentially 3 tables that I am interested in (A table, B table, and C table). I am using ...
0
votes
1answer
135 views
Handling a SQL Server Login error msg with VBA?
I'm working in a VBA module for Access that queries linked tables, generates reports based off the data, and then uses a PDF printer to save the reports to disk. There's a timer in the primary form ...
0
votes
1answer
96 views
MS ACCESS MS SQL ODBC DRIVER MANAGER ERROR
I am currently working with a MS ACCESS front end and database that connects to a MSSQL database. This is a closed MDE database that was deployed long before I started working with it and the ...
3
votes
1answer
470 views
Changing connection to SQL Server in Microsoft Access 2003 ade file
I developed an Access 2003 application that is connected to SQL Server.
My problem is that I developed the software on my server, and the application runs on the client network on a different ...
2
votes
1answer
133 views
SQL Stored Procedure times out in Access
The following SP times out when executed from Access VBA. It works fine when executed from the management console. If relevant, the server does has a high ping time:
Dim cnn As ADODB.Connection
Dim ...
