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.
78
questions
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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.
...
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) ...
-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 ...
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 ...
-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 ...
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 `...
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={...
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 ...
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 ...
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 ...
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 ...
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) ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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) ...
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 ...
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 ...
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 -...
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 ...
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 ...
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 ...
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 ...
-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 ...
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 ...
-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, ...
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 ...
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 ...
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 ...
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) ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...