The tag has no wiki summary.

learn more… | top users | synonyms (2)

-3
votes
1answer
27 views

Hosting Access Database

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 ...
1
vote
0answers
24 views

Cannot split Access 2010 database, cannot export or import either. [closed]

I have an access db that I need to split. It was not created properly and there have been multiple users trying to access it unsuccessfully. I made a backup then went into access 2010 and tried to ...
1
vote
0answers
75 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 ...
0
votes
0answers
76 views

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 ...
0
votes
0answers
580 views

[Microsoft][ODBC Driver Manager] Invalid string or buffer length (HRESULT: 80131500)

I am having an intermittent problem with a Spotfire Server accessing information models which connect to Microsoft Access databases via ODBC. The server is a Windows Server 2008 R2 64bit, we have ...
1
vote
2answers
421 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
1answer
239 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
0answers
48 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, ...
1
vote
1answer
170 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 ...
0
votes
1answer
204 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
2answers
175 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
1answer
2k 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
1answer
108 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 ...
0
votes
1answer
143 views

MS Access XP/2002 Runtime Force A4 Page Size

We use an ERP system that we are deploying in Europe. The system is built by a US based company and currently all of the reporting is based on MS Access reports. It installs with the MS Access ...
0
votes
1answer
3k 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
1answer
148 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 ...
3
votes
2answers
4k views

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 ...
2
votes
1answer
88 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
1answer
1k 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 ...
2
votes
3answers
2k views

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?
0
votes
1answer
150 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
2answers
368 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
1answer
285 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
1answer
195 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
2answers
750 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
2answers
57 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 ...
4
votes
2answers
6k views

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 ...
1
vote
0answers
458 views

Slow connection to a shared .mdb file over a LAN on some machines only (SOLVED)

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
1answer
288 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) ...
2
votes
2answers
1k 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
1answer
151 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 ...
0
votes
1answer
77 views

Connecting and Viewing a remote MS ACCESS database

I'm trying to test a connection to a remote MS access database this is being held at a specific IP. How do I do that? What application do I use?
0
votes
1answer
901 views

Can I create an oracle ODBC driver without installing the Oracle Client?

recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't ...
0
votes
1answer
96 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 ...
2
votes
3answers
3k views

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 ...
0
votes
0answers
186 views

SQL 2005 linked server to MS Access 2003 breaks after a while

On our production server, I linked to an unsecured Access 2003 mdb file which worked nicely for a few days. EXEC sp_addlinkedserver 'NUWDB', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', ...
1
vote
2answers
30 views

MSAccess doesn't see sql2005 dataset

I have a sql2005 setup on a windows7 machine. I am able to see the dataset in SSMS, but am unable to create a connection string that will see the dataset from MSAccess. I am able to connect to the ...
2
votes
1answer
1k 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
1answer
139 views

MS Access Security Issue (WRITE Access on a Trusted Connection?!!!)

Not sure if this is the right place for this question (Perhaps SuperUser), but I'm sure there are some Access gurus here on ServerFault. Anyway, we support some legacy MS Access apps and recently a ...
0
votes
1answer
115 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 ...
1
vote
1answer
596 views

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 ...
1
vote
2answers
15k views

MS Office 2010 Licensing requirements in on Terminal Server [duplicate]

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

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 ...
2
votes
5answers
857 views

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

forcing EDIT of access backend database

here is my situation: http://stackoverflow.com/questions/3962892/forcing-edit-of-access-backend-database i am wondering if there is a permissions solution. perhaps i can have the network guy remove ...
0
votes
2answers
2k views

Running a MS-SQL Server Stored Procedure from MS Access?

I have an Access 2010 front-end to an SQL-Server 2008 database. I'd like to use the stored procedures already on the server via the front-end! Is this even possible? (Bit of a newb so go easy on me ...
0
votes
3answers
461 views

Migrate reports from MS Access to OOo Base

I'm currently looking at upgrading our office machines from Office XP to Office 2010. For most users the standard edition is fine but just a few of us use Access. There are only a couple of standalone ...
0
votes
1answer
25 views

Resrtict MS Access creation

Is it possible to restrict MS Access creation but still be able to view and execute Access files.
0
votes
3answers
126 views

Identify Access databases linked to a specific SQL server

Is there a way to parse .mdb files from the command line (findstr or via a WSH script) to identify database links? I am attempting to identify all .mdb files within a large file share that link to a ...
1
vote
3answers
947 views

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 ...