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
39
votes
18 answers

Poor internal database - replace it or chuck hardware at it?

So - we have an internal company database, the usual kind of stuff: manages clients, phone calls, sales deals and client agreements/schemes. It's an Access 2000 front-end, and an SQL Server 2000 Standard back-end. Single server, dual Xeon 3.2GHz,…
tomfanning
  • 3,308
  • 6
  • 33
  • 34
11
votes
3 answers

Creating a sql dump of Microsoft Access tables

Is it possible to generate a sql script that contains CREATE and INSERT statements for some tables within an Access database?
digiarnie
  • 253
  • 1
  • 2
  • 6
4
votes
4 answers

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) database to handle various backend processes that…
Elias
  • 93
  • 1
  • 9
4
votes
7 answers

Migrating an Access Database into SharePoint 2007

To my surprise and delight I read that an adminsitrator can import (nearly directly) an Access 2007 database into a sharepoint site. Automagically, the database in transformed into lists and views with some table lookup thrown in for good measure.…
Mike T
  • 271
  • 1
  • 4
  • 11
4
votes
2 answers

How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?

I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented. I cannot convert the Access database to a…
Brad Knowles
  • 71
  • 1
  • 3
4
votes
2 answers

Can I use Active Directory for user-level security in an Access application? Pretty Please?

My company makes fairly extensive use of an Access + MySQL application that would probably see some significant traffic on the Daily WTF if I posted the source code. The management of users and their permissions is getting out of hand, and I seem…
atroon
  • 498
  • 3
  • 10
  • 23
3
votes
1 answer

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 minimum permissions do I have to give users on the…
vic
  • 973
  • 1
  • 9
  • 21
3
votes
2 answers

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) and secured through a security database…
leeand00
  • 4,807
  • 13
  • 64
  • 106
3
votes
2 answers

SSIS: How to create and export data to Microsoft Access 2003 database?

Goals - Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package) There is no "Access DB Destination" in BI toolbox. So the question is, How can I create an…
dance2die
  • 1,961
  • 7
  • 31
  • 40
2
votes
3 answers

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 automatic task running each day without a the user…
user522962
  • 21
  • 1
2
votes
1 answer

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) installed. The connection is Unicode-based,…
Thunderbeef
  • 161
  • 5
2
votes
5 answers

Copy data from Access to SQL

I have a an access DB that is to be eventually be replaced by a SQL DB with a web front end. The web application is currently in development. I have copied the Access DB to SQL using the Migration Assistant, unfortunately we can't just link the…
Sam Cogan
  • 38,158
  • 6
  • 77
  • 113
2
votes
1 answer

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 connection. The thing is though, they all use the same…
Mallow
  • 144
  • 2
  • 9
2
votes
1 answer

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 command. The script uses (Get-ChildItem…
leeand00
  • 4,807
  • 13
  • 64
  • 106
2
votes
1 answer

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 will change when they aren't in their office. Is…
Stan
  • 231
  • 1
  • 2
  • 3
1
2 3 4 5 6