The ms-access tag has no wiki summary.
-2
votes
0answers
34 views
Searching for the best Database solution [closed]
I am new to this field and trying to learn the best possible way to maintain a database for my company. I am looking for the best option (cheap and reliable) to manage all the documents and contacts.
...
1
vote
1answer
100 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
105 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 ...
0
votes
0answers
68 views
MS Access Front-end accessed via RDP gives an error when printing?
We have a server with a MS-Access Front End that is used as the shell of an RDP connection instead of explorer.exe:
alternate shell:s:"D:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" ...
0
votes
0answers
41 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, ...
0
votes
0answers
55 views
MS Access Slow on Networked Server
I have a server with MS Access installed, and Via Remote Data Connection, the response time is excellent. The database is 1.3 gb, and the queries use a series of ODBC links to acquire data throughout ...
0
votes
1answer
146 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 ...
0
votes
0answers
367 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 ...
3
votes
2answers
140 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
1k 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
66 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
0answers
11 views
Ended tasks in task scheduler, but locks and processes persist - MS Access 2003 and Windows Server 2003 [duplicate]
Possible Duplicate:
How to determine what has a lock on a particular file in Windows?
I have three scheduled jobs that run MS-Access macros that have been stalled since Monday (it is now ...
1
vote
1answer
112 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 ...
2
votes
1answer
109 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 ...
2
votes
1answer
68 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
586 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 ...
0
votes
1answer
105 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
289 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
197 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
153 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
345 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
54 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 ...
1
vote
0answers
340 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
199 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) ...
0
votes
1answer
2k 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
2answers
955 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
124 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
116 views
How to recover Ms Access 2003 mdb files after crash [closed]
A friend of mine has had his .MDB file crash and need help with recovery? Any tools/utility to help with this?
0
votes
0answers
150 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
28 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
892 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
90 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 ...
0
votes
1answer
68 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
99 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
2answers
277 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 ...
0
votes
1answer
115 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
619 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
90 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 ...
1
vote
1answer
494 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 ...
0
votes
1answer
126 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 ...
2
votes
3answers
1k 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
3answers
111 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
2answers
13k 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 ...
2
votes
3answers
2k 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
3answers
325 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
24 views
Resrtict MS Access creation
Is it possible to restrict MS Access creation but still be able to view and execute Access files.
1
vote
3answers
71 views
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 ...
1
vote
2answers
902 views
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 ...
1
vote
1answer
2k views
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 ...
