The tag has no wiki summary.

learn more… | top users | synonyms (2)

4
votes
2answers
1k views

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

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 ...
2
votes
5answers
875 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 ...
36
votes
18answers
768 views

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 ...
0
votes
4answers
2k views

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 ...
4
votes
7answers
3k views

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

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?
1
vote
3answers
1k 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 ...