Questions tagged [microsoft-access]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Updates to Access DB backend don't seem to commit properly

we have an old(ish) IIS server running on 2012R2 with an access 2010 backend. Our Web developer tells me that from time to time when he updates the database (via Access), those records aren't always ...
0
votes
0answers
446 views

Windows Remote Desktop Terminal Server sessions freezing

Running a fresh install of Windows Server 2016 Remote Desktop server. Initial configuration went smoothly, everyone can log in and access the required application. The application is a specialized ...
1
vote
0answers
224 views

Windows server vs Synology

I do network support for SMEs and a client decided to move away from cloud storage/backup and simple file sharing between Windows terminals and install a server. Requirements are data encryption, MS ...
0
votes
1answer
18 views

W2K8 R2 Server session from OSX RDP client poorly renders text in MS Access 16

Windows Server 2008 R2 which is used primarily to run MS Access for browsing and manipulating various databases. OS Name Microsoft Windows Server 2008 R2 Standard Version 6.1.7601 Service Pack 1 ...
2
votes
3answers
158 views

Windows Task Scheduler to click link in access form

I have a label on an Access form. This is a clickable label which will then run an event procedure. This event extracts data and puts it into an excel sheet. A Client has asked for this to be an ...
1
vote
0answers
29 views

Access Runtime 2010 Disappeared from Domain Computers - Deleted GPO

My organization runs a domain with an Access front end based upon and SQL Express Database. 99% of our users are using the 2010 Runtime version of access. The installed DB literally disappeared from ...
1
vote
1answer
18 views

MS Access won't save file when trying to upgrade from 2002-2003 to 2016

We have a customer with a lot of old access files that we are taking a look at. Honestly we don't deal with Access much but they are having performance issues with it so we decided to take a stab. ...
1
vote
1answer
236 views

Conflict when editing new records in Access connected to PostgreSQL by ODBC

I have a setup with Microsoft Access 2010 as a front-end and PostrgreSQL server 9.5.12 running on Linux as a back-end. Windows PC has PostrgreSQL ODBC driver version 10_02_0000 (currently latest) ...
-2
votes
1answer
54 views

Migrating a small office to a Windows cloud environment [closed]

I’m looking for the best way to migrate the IT of a small non-profit which I support to a Windows cloud environment. I’d appreciate your advice on choosing an affordable and friendly cloud provider ...
1
vote
1answer
8k views

System resource exceeded - what resource could that be?

I'm trying to run an asp.net page that connects to an access database via an ODBC Data Source. I'm using the Microsoft Access ODBC Driver. Everything was working fine until a recent power outage ...
-2
votes
1answer
114 views

Queries execute faster when hosted on laptop than on server

I am experiencing a strange issue when publishing an ASP MVC application to Windows Server 2012. The app is fairly simple, and on most of the pages visited it will query an Access database which is ...
0
votes
1answer
334 views

CREATE command denied to user - Access Migration -> MySQL (SQL Workbench)

Doing a MS Access to MySQL Migration with SQL Workbench. At the create Schema point I am getting the following error for all tables (9): WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `...
1
vote
1answer
5k views

Windows logins are not supported in this version of SQL Server

All of the suggestions given here are already tried. Inside our Azure Windows Server 2012 VM, we've got an Azure SQL database. The ODBC connection string obtained from the Azure portal is: Driver={...
0
votes
1answer
481 views

ODBC--connection to 'systemDSN' failed

We have a Microsoft Access 2010 database (ACCDB). This ACCDB file is just a front end to a Microsoft SQL Server 2008 database. Authentication to the database is accomplished by Windows integrated ...
0
votes
1answer
92 views

Office 365 and Access doubts

We are planning to move from an on-premises solution to a hosted one for our office applications. Office 365 includes Access for some of its Enterprise plans (namely, E3 and E5 I think). As we are ...
0
votes
1answer
349 views

Setting up End-User Connection to ODBC Data Source

I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access ...
3
votes
1answer
685 views

What kind of file and folder permissions are necessary for ODBC?

In our network, we are using an application that connects to an *.mdb access database through ODBC (User DSN). The mdb is based on a subfolder of a share that is locally mapped to W: What kind of ...
4
votes
4answers
2k views

Windows 2008 R2 Not Printing From Scheduled Task

Problem Since the end of support is coming on July 14th for Windows servers 2003 we are moving all of our scheduled tasks to a Windows 2008 R2 server. We use a Microsoft(MS) Access 2003(mdb) ...
0
votes
1answer
155 views

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the ...
1
vote
1answer
1k views

MS Access DB performance on a VMware virtual machine

In our office, we have a Windows 2008 virtual machine hosted on an HP ProLient ML350 G6. This VM has access to all of the resources available on the host. On this machine there are some Microsoft ...
-3
votes
1answer
466 views

Hosting Access Database [closed]

Attempting to host an Access database on a server running Windows Server 2012 R2. In the past I've always used services where database access was fairly preconfigured and am doing this one from ...
0
votes
1answer
3k views

MS Access, Query list doesn't refresh, GUI doesn't update

We have some users running MS Access 2010 (don't ask me why, we have MSSQL licenses they could use) and have recently run into a problem. Symptoms: Query list does not refresh when they create a new ...
0
votes
0answers
527 views

Terminal Server: Remote Application MS Access issue

We have a terminal server 2008 r2 in the cloud. Hosted at a service provider. We have several users that use ms access 2010 on that server as a remote app published on the server. When they open the ...
1
vote
2answers
3k views

make microsoft access use TCP/IP instead of Named Pipes

I got a Microsoft Access database which is constantly trying to contact the corresponding Microsoft SQL Server using named pipes, even though only TCP/IP is available and the ODBC is configured to use ...
0
votes
1answer
1k views

Robocopy for Microsoft Access Files MIR switch

We are using robocopy with MIR switch to backup our Microsoft Access Databases, i.e., .accdb, and .mdb files. Interesting thing with Access database files is that you can open a database, add a few ...
1
vote
0answers
59 views

My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Databases I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, all the ...
0
votes
1answer
481 views

Confused with creating an ODBC connection, apparently I have two separate odbcad32.exe files?

Alright, this is my first time working with this so forgive me if I'm a little confusing or vague. I have a server with Windows Server 2008 Standard without Hyper-v (6.0, Build 6002). I'm running a ...
3
votes
2answers
302 views

Can splitting an access database cause printer and reporting issues?

We have a setup in which our users log into an access database using MS Access 2003 over an RDP connection. The backend database (.mdb) is accessed by our users with their frontend database (.mde) ...
2
votes
1answer
5k views

How could I make a MsAccess Frontend and Mysql Backend more user aware?

I have a distributed MsAccess front-end database which uses a mysql backend. It uses the Windows System DSN ODBC connections to connect to the server. All my Linked tables refer to that ODBC ...
0
votes
2answers
179 views

What is the most reliable way to copy access front end files to client PCs

I have several in house databases which have access 2003 front ends, either adp or ade files. I need to copy these from my server to every client machine. In the past I have used a rollout scripts ...
1
vote
1answer
287 views

Powershell and long-running external tools?

I'm trying to compact a MS-Access database using JetComp.exe using a powershell script. Here is the operative lines: # 4. Run JetComp LogWrite("Begin: Running JetComp") .\JETCOMP.EXE -src: $srcDB -...
2
votes
1answer
296 views

Filesize monitoring powershell script safe to run against a multiuser Access 2003 database?

I'm try to monitor the size of an MS Access Database file which corrupts when the size reaches 2GB. I found the following powershell script which monitors the size of a file, and then runs a ...
2
votes
1answer
123 views

Access front end SQL back end secure connection

I need to have an Access front end and SQL 2005 back end for a client. I would like to require them to have a static IP and I'll open a port for that IP. But they also want to be mobile, so their IP ...
2
votes
1answer
3k views

MS Access Database slower than normal all of a sudden

I have a client with an Access Database that has been experiencing slow queries in the past few days. Here is some background first. it is currently running on Windows Server 2008 the mdb file is on ...
0
votes
1answer
642 views

Deploy MS ACCESS driver to connect in ASP.NET (shared hosting)

I've tried to deploy a small website (ASP.NET) which is using an MS ACCESS 2010 db. Deploying the website on the server I get the following error: The 'Microsoft.ACE.OLEDB.12.0' provider is not ...
-1
votes
2answers
505 views

MDB database file moved off-site

A large client that uses my MDB based application has moved the MDB file off-site so that my application connects to it over a WAN. How can I convince them to put the MDB file back on-site on to the ...
0
votes
1answer
524 views

Create ODBC Connection from Access to SQL Server

I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
-1
votes
1answer
266 views

How Do I Configure SQL Server 2005 Backend? [closed]

I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I'm going to store the records on the server, ...
1
vote
2answers
3k views

How should I back up multiple in-use MS Access databases?

Disclaimer: I'm a software engineer, not an IT professional, sorry if some of my suggestions are silly or otherwise ridiculous. A windows application, which will remaining running at all times, is ...
0
votes
2answers
62 views

Project to replace desktops with a server

This may sound crazy, I've gotten a few horrified looks when explaining it to others before, but here's the setup right now: We have A a group of desktops dedicated to running reports all day, using ...
1
vote
0answers
993 views

Slow connection to a shared .mdb file over a LAN on some machines only

A single client program on each of about 10 computers are sharing a .mdb file on a windows 7 machine. The network is cabled and has a switch. For no obvious reason the connection on 2 of these ...
0
votes
1answer
910 views

I have an LACCDB (Microsoft Access Lock File) on a shared Linux drive that I want to delete so that I can amend the database

I'm running Windows myself, but the drive is hosted on a Linux server. Basically, people map this drive to their Windows machine, open ACCDB files (which they're not supposed to do, we use ACCDE's) ...
1
vote
1answer
9k views

The 32-bit ODBC client for MS-access does not work and installing the 64-bit client is not allowed, what to do?

I have a 64-bit Windows 7 laptop that I use for development. I have office 2003 installed, because I have a client that works with Office 2003. Microsoft Access is not installed, because it's my ...
2
votes
2answers
5k views

Slow access to Access Database after Server Migration

I'll preface this question with the fact I know about This question but unfortunately it was no help to me as "don't run the database over the network" is just not an option. Last week we migrated ...
1
vote
1answer
277 views

How can I compare the state of an SQL Server database before and after a transaction?

I'm about to run a query in Access 2002 which will make all sorts of changes to the SQL Server 2000 database it's plugged into (the changes are only in the data, not the structure). What I want is to ...
2
votes
1answer
2k views

Access ODBC Driver

I need to migrate a bunch of data from an Access database to a MySQL server. I wrote a migration in ColdFusion, but when I went to create the ODBC connection on the CF Administrator, I got an error. ...
0
votes
1answer
323 views

Can MS Access Projects be run by different users on a Windows terminal-server simultaneously via RDP?

An existing MS Access 2003 project frontend with a MS Sql Server 2005 backend needs to be accessed from different locations (not just one LAN anymore). Instead of implementing a VPN, we are thinking ...
0
votes
1answer
127 views

Block SQL 2008 R2 Insert Access on anything for user in MS ACCESS on AD Group

Hi I would like to block access to insert any data on SQL when a User from a determined Active Directory Group access SQL from MS ACCESS. Is this possible? if not is there any alternative? I've ...
1
vote
2answers
1k views

using remote MS Access database which connects to remote SQL server

We have a Microsoft Access database + application (on Server A) which connects to a remote SQL server (Server B) using System DSN ODBC connection (on Server A) to the SQL database server. The users ...
-1
votes
1answer
218 views

MS Access XP/2002 Runtime Force A4 Page Size [closed]

We use an ERP system that we are deploying in Europe. The system is built by a US based company and currently all of the reporting is based on MS Access reports. It installs with the MS Access XP/...