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
0
votes
1 answer

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 authentication. I have created a System DSN on the…
user5870571
  • 2,900
  • 2
  • 11
  • 33
0
votes
1 answer

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 currently using Access, some doubts about migration,…
kankamuso
  • 485
  • 6
  • 14
0
votes
1 answer

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 front-end database contains linked tables to a…
HeatherD
  • 1
0
votes
1 answer

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 next record and type the exact same thing, the…
Madison Knight
  • 121
  • 5
0
votes
2 answers

Database with MS JET after migration

I am migrating a bunch of sites which each use an Access database (or whatever an MDB file is). If I try to load the site, I get the following error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen…
Zimmy-DUB-Zongy-Zong-DUBBY
  • 1,549
  • 3
  • 16
  • 29
0
votes
1 answer

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 query or table. Pressing F5 refreshes the…
Thomas
  • 868
  • 4
  • 17
  • 35
0
votes
0 answers

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 database as a remote app they can't sort of filter…
Litrick
  • 1
0
votes
1 answer

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 records into a table, close the db and the size of…
I don't know.
  • 275
  • 3
  • 6
  • 17
0
votes
1 answer

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 small website off this server and using a Microsoft…
Hoser
  • 125
  • 5
0
votes
2 answers

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 to copy the files to the all users desktop folder.…
Simon Foster
  • 2,572
  • 6
  • 36
  • 54
0
votes
1 answer

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 registered on the local machine. Connectionstring used…
Kman
  • 101
  • 2
0
votes
1 answer

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 SQL Server. I'm using the wizard, and trying to…
Scriptonaut
  • 137
  • 6
0
votes
2 answers

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 a bunch of Access DBs (over 100) that currently…
KenDGreen
0
votes
4 answers

Troubleshooting MS-Access on slow windows fileshare?

We have an MS-Access DB on a file share. We're getting slow performance and error messages we suspect have to do with file access being so slow. What would be the first things to check to find out what the bottle neck is? It works fine locally, so…
MatthewMartin
  • 289
  • 1
  • 6
  • 14
0
votes
1 answer

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) and then after they close out, the LACCDB sticks…
JMK
  • 778
  • 1
  • 7
  • 19
1 2 3
4
5 6