Server Fault Stack Exchange
Server Fault Stack Exchange

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.

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.

81 questions
2
votes
1 answer

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 the server and there are some local installed…
dasko
  • 1,244
  • 1
  • 22
  • 29
2
votes
2 answers

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 our file server from Server 2000 to a Server 2008 R2…
DKNUCKLES
  • 4,028
  • 9
  • 45
  • 60
2
votes
1 answer

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. The exact error is: Connection verification…
Dave Long
  • 349
  • 1
  • 4
  • 15
2
votes
4 answers

Need help with Access Database with Front End and Back End really slow with more than 1 user

We have had a consultant install a database for a client that is based on Access 2007 with a front end (on each workstation) and I guess the database back end (on the file server, it is a server 2003 domain controller with very current hardware,…
dasko
  • 1,244
  • 1
  • 22
  • 29
2
votes
3 answers

MS Access gets Disconnected

I have MS Access 2003 application connected to SQL Server 2005 with linked tables. Starting from yesterday when I open a linked tabled and leave it open for a while (5~10 minutes) then the database gets disconnected showing following error message.…
THEn
  • 137
  • 2
  • 8
2
votes
2 answers

Group Policy: Trusted Location in User's My Documents?

I am trying to use group policy to add a subdirectory of the user's home directory as a trusted location for Microsoft Access 2007 (User Configuration/Administrative Templates/Microsoft Office Access 2007/Application Settings/Security/Trust…
Brett G
  • 2,023
  • 1
  • 27
  • 45
1
vote
0 answers

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 Access database sharing with concurrent users,…
skifast
  • 21
  • 1
1
vote
0 answers

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 a few computers this morning. When I try an…
awwhhh_rubbish
  • 11
  • 2
1
vote
1 answer

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. First thing I noticed is all the files are in Access…
Jacob
  • 131
  • 1
  • 3
1
vote
1 answer

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 caused us to have to reboot the server. The problem…
Adam R. Grey
  • 111
  • 1
  • 1
  • 5
1
vote
1 answer

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={ODBC Driver 13 for SQL…
Zameer Ansari
  • 143
  • 1
  • 3
  • 11
1
vote
1 answer

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 Access databasess which are used in a poorly coded…
SilentRage47
  • 125
  • 5
1
vote
2 answers

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 TCP/IP. It's not possible to link all the tables…
Zulakis
  • 4,191
  • 14
  • 44
  • 75
1
vote
0 answers

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

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 queries are saved in the front end as I've only…
andrewb
  • 151
  • 8
1
vote
1 answer

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 -dest: $dstDB | Out-Null #Run this command and wait…
leeand00
  • 4,807
  • 13
  • 64
  • 106
1
2
3 4 5 6