Questions tagged [microsoft-access]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 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
31 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 ...
0
votes
0answers
28 views

run as administrator,but still access denied when net user newuser password /add

when add new user on win 10 use command prompt,access is denied. my login user is admin and run command prompt as admin,but still access denied. Can anyone tell me why this happened ? how to ...
0
votes
0answers
104 views

SQL Server Linked Server Remove “Allow in Process” Authentication Failure

Have been experiencing issues with linked servers within SQL Server 2014 (64 bit). The linked servers are linked to older legacy .mdb’s but our current version of office is Microsoft Access 2010 (32 ...
1
vote
0answers
21 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
14 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. ...
0
votes
0answers
18 views

MS Access 2000 replication list

I am using an Access 2000 (Version (11.8321.8405) SP3) database on a Windows XP (Version 5.1.2600 Service Pack 3 Build 2600) machine in a production facility. The list of replicated databases contains ...
1
vote
1answer
147 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
53 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
5k 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
103 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
251 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
3k 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
374 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
89 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
320 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
566 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
152 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
463 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
512 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
58 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
465 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
297 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
178 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
284 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
293 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
614 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
497 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
502 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
264 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
955 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
872 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
275 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
298 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
217 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/...