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
1
vote
2 answers

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 connected to, and constantly interacting with,…
epalm
  • 143
  • 2
  • 5
1
vote
0 answers

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 computers as evidenced by the user experience with the…
pdinpr
  • 11
  • 3
1
vote
1 answer

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 firm belief it's a piece of ehm non-optimal…
Johan
  • 312
  • 3
  • 13
1
vote
1 answer

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 be able to easily compare the state of the…
Shawn
  • 111
  • 4
1
vote
2 answers

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 are open this Access database remotely as it is on…
Manjot
  • 333
  • 3
  • 17
1
vote
3 answers

Is Access connecting to a remote Postgresql database via ODBC usable?

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking through some disaster recovery scenarios, and it…
Guy C
  • 505
  • 1
  • 4
  • 9
1
vote
1 answer

Pull info from a Microsoft Access database into the php and apache web environment?

We have a client who uses a custom build client management system that runs on Microsoft access. The website we have needs to pull some client info from that database. But how do we pull info from a Microsoft Access database into the php and apache…
CodeChap
  • 111
  • 1
1
vote
2 answers

MS Office 2010 Licensing requirements in on Terminal Server

Possible Duplicate: Can you help me with my software licensing question? I have a client that would like to upgrade MS Access on his TS to 2010. From the research I have done, it appears that he needs to actually buy a $160+ copy of MS Access for…
Icode4food
  • 175
  • 1
  • 2
  • 13
1
vote
3 answers

Transform data to a new structure

I've got an Access database from one of our clients and want to import this data into a new MSSQL Server 2008 database structure I designed. It's similar to the Access Database (including all the columns and so on) but I normalized the entire…
Henrik P. Hessel
  • 400
  • 3
  • 18
1
vote
1 answer

XP Virtual Mode in Windows 7, network access for installed apps?

I have the joy of having to manage a Microsoft Access form that was designed in Access 2003. The MDB is converted to an MDE for security reasons. However, I'm running Windows 7 with Office 2007 (including Access 2007). Access 2007 doesn't allow you…
user35709
1
vote
2 answers

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 am connected as a domain verified user. I create a new…
Andy McRae
  • 125
  • 8
1
vote
6 answers

Copy Access tables to MS SQL

I have to copy some tables from an Access 2000 database to a SQL Server 2005 database. What's the easiest way to do this?
Matt Hanson
  • 1,672
  • 1
  • 23
  • 33
1
vote
1 answer

Terminal Services - MS Access Frequently "Not Responding"

Exposition: We use a program built in MS Access that I serve via Terminal Services. I just installed a new TS Server with a Quad Core 2.6GHz Xeon, 8GB RAM, and 4 SATA drives in a RAID 0. In installed Server 2008 R2 (64bit obviously). It's only…
jonfhancock
  • 236
  • 2
  • 6
0
votes
1 answer

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 Build 7601 OSX Remote Desktop v8 and 10.3 MS Access…
Lifeboy
  • 250
  • 2
  • 6
0
votes
1 answer

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 `HWAMembers`.`2016 Memberships` ( `ID` INT(10) NOT NULL, …
Bromox
  • 101
  • 1
1 2
3
4 5 6