Questions tagged [microsoft-access]

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server and MySQL, can also be used as a database server back end for Access applications.

Filter by
Sorted by
Tagged with
0 votes
1 answer
495 views

How to setup an Azure Windows VM for multiple users to RDP to their unique MS Access file?

I have 2 Azure VMs. One will act as an application server. The application is an Access file. This Access file connects to a separate Microsoft SQL Server database on a different Azure VM which will ...
Darlirium's user avatar
1 vote
2 answers
427 views

Connect Access 2016 to remote SQL Server - SQL Server Error 17

Good morning, I am trying to connect to a SQL server from a remote machine, with ACCESS 2016, using the "External data" option. Both are on the same network. It is important to note that I ...
Andy McRae's user avatar
0 votes
1 answer
897 views

Run batch file to start specific program to open at specific record

I need to be able to run a batch file that opens Access at a specific record. This I can do, but now I need to also run it on either 32 or 64 bit systems. Our company uses a mix of systems. This is ...
jrdnoland's user avatar
0 votes
0 answers
416 views

MS Access database across small company LAN: NAS vs virtualized Windows Server

I'm currently developing a small sized Windows application. For compatibility reasons, I'm limited to use MS Access as DB "backend" (migration to SQL Server planned but not doable yet). In ...
IFrank's user avatar
  • 111
0 votes
0 answers
258 views

How do I import Unicode Data into MySQL?

I'm trying to create a dump file from an MSAccess database to import in to a MySQL database. I can create the dump file, but when I try to import it I get this error Incorrect string value: '\xA325- R....
djack109's user avatar
  • 131
1 vote
0 answers
436 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 ...
skifast's user avatar
  • 21
0 votes
1 answer
29 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 ...
Lifeboy's user avatar
  • 250
2 votes
3 answers
430 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 ...
user522962's user avatar
1 vote
0 answers
48 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 ...
awwhhh_rubbish's user avatar
1 vote
1 answer
151 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. ...
Jacob's user avatar
  • 131
2 votes
1 answer
601 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) ...
Thunderbeef's user avatar
-2 votes
1 answer
61 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 ...
Isac Casapu's user avatar
1 vote
1 answer
11k 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 ...
Adam R. Grey's user avatar
-2 votes
1 answer
338 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 ...
Bassie's user avatar
  • 193
0 votes
1 answer
638 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 `...
Bromox's user avatar
  • 101
1 vote
1 answer
12k 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={...
Zameer Ansari's user avatar
0 votes
1 answer
559 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 ...
user5870571's user avatar
  • 3,144
0 votes
1 answer
96 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 ...
kankamuso's user avatar
  • 487
0 votes
1 answer
436 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 ...
HeatherD's user avatar
3 votes
1 answer
899 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 ...
vic's user avatar
  • 973
5 votes
4 answers
3k 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) ...
Elias's user avatar
  • 103
0 votes
1 answer
163 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 ...
Madison Knight's user avatar
1 vote
1 answer
2k 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 ...
SilentRage47's user avatar
-3 votes
1 answer
479 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 ...
Jim's user avatar
  • 101
0 votes
1 answer
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 ...
Thomas's user avatar
  • 880
1 vote
2 answers
4k 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 ...
Zulakis's user avatar
  • 4,233
0 votes
1 answer
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 ...
I don't know.'s user avatar
1 vote
0 answers
61 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 ...
andrewb's user avatar
  • 151
0 votes
1 answer
566 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 ...
Hoser's user avatar
  • 125
3 votes
2 answers
311 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) ...
leeand00's user avatar
  • 4,919
2 votes
1 answer
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 ...
Mallow's user avatar
  • 144
0 votes
2 answers
195 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 ...
Simon Foster's user avatar
  • 2,652
1 vote
1 answer
302 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 -...
leeand00's user avatar
  • 4,919
2 votes
1 answer
322 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 ...
leeand00's user avatar
  • 4,919
2 votes
1 answer
130 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 ...
Stan's user avatar
  • 241
2 votes
1 answer
4k 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 ...
dasko's user avatar
  • 1,244
0 votes
1 answer
718 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 ...
Kman's user avatar
  • 101
-1 votes
2 answers
523 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 ...
CJ7's user avatar
  • 653
0 votes
1 answer
611 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 ...
Scriptonaut's user avatar
-1 votes
1 answer
272 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, ...
Scriptonaut's user avatar
1 vote
2 answers
4k 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 ...
epalm's user avatar
  • 143
0 votes
2 answers
64 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 ...
user avatar
1 vote
0 answers
1k 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 ...
pdinpr's user avatar
  • 11
0 votes
1 answer
1k 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) ...
JMK's user avatar
  • 778
1 vote
1 answer
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 ...
Johan's user avatar
  • 312
2 votes
2 answers
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 ...
DKNUCKLES's user avatar
  • 4,028
1 vote
1 answer
321 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 ...
Shawn's user avatar
  • 111
2 votes
1 answer
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. ...
Dave Long's user avatar
  • 349
0 votes
1 answer
388 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 ...
Olaf's user avatar
  • 881
0 votes
1 answer
131 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 ...
Gabriel Guimarães's user avatar