Search results for query: *

I have a small single-user app (one main data entry screen with subforms and several reports with export to Excel option) that was written and deployed in Access 2000. Amazingly the app is still in use and they recently requested a few report modifications so I am opening the code for the first...

I’m trying to design an archive strategy for a large SQL Server 2008 application database (that I didn’t create). The database has two types of tables: static and run-specific. Static tables don’t change frequently but run-specific tables are completely refreshed once per month. Data from...

I have an Access 2007 app running in a Windows 7/Access 2010 environment. The back end database lives on a network server. The users connect wirelessly to the network on tablets (no other option). Currently each user has a personal copy of the front end application database (with tables linked...

One form in my Access application is behaving badly. It normally opens in Data Entry mode to a new blank record, but today it is opening on the first record in the table with all 5900 records available to view. I have a drop-down that filters these records to Last Day, Last 7 Days or Last 30...

I have an application developed in Access 2007/Windows ME and running on Access 2010/Windows 7. The Back End shared database lives on a network server. Version 1 deployed a year ago and suffered from periodic corruption. I finally discovered that it had not been deployed as intended and...

I can send screen shots if you need proof:) In my table, the first column is an AutoNumber field and the second column is long integer with a unique index (Primary Key=No, Unique=Yes, Ignore Nulls=No). I can see two records with the same first column value and the same second column value. How...

I created an Access application in Access 2007 on a Vista machine. Now it is being distributed in an Access 2010 and Windows 7 environment. The shared database lives on the network and works fine. The front-end application database file is distributed by placing it on the network share and then...

I rely on Verizon MiFi wireless for my home internet. I am routinely online with two laptops (one XP and one Vista) and one desktop running Windows 7. Just this week, the Win7 desktop slowed to half its normal speed. The two laptops are still running their usual speed. The desktop has always had...

I’ve built successful Access apps for years, but this one is throwing more errors than all my previous projects combined and it’s still in User Acceptance Testing. I’m looking for any and all angles to explore with this. App is built and maintained in Access 2007 on Windows Vista home premium...

I have a Word 2010 document in which I have pasted pictures from my friends’ Facebook pages. On each picture, I have right-clicked to add a Hyperlink and pasted the link from each friend’s home page. Then to view, I click on the picture, right-click and select “Open Hyperlink.” For about 70%...

When my users launch the Access 2007 app I distributed in ACCDE format, it hides all the standard menus/ribbon. This is just a database setting where I unchecked “allow full menus” in the source ACCDB file. So far so good. Then when the same user opens an Access 2003 MDB file, the menus are...

I am deploying an Access 2007 app where I have converted the backend tables into Sharepoint lists. My users will have a copy of the Access frontend with forms to edit and query data in these lists. How do I hide the lists on my Sharepoint site from these users who can otherwise access this...

--- Posting same thread on MS Access: Other and MS Sharepoint forums --- I have an MS Access app that I need to deploy to multiple users who don’t share a single network drive. Their best common access point is via Sharepoint. What I’ve read to date suggests that publishing the Access app fully...

--- Posting same thread on MS Access: Other and MS Sharepoint forums --- I have an MS Access app that I need to deploy to multiple users who don’t share a single network drive. Their best common access point is via Sharepoint. What I’ve read to date suggests that publishing the Access app fully...

My original MDB was 220 MB with 1 table. Table had 26 fields: 1 DATE, 2 LONG, rest CHAR of varying size. New MDB with 1 table is 1.9 GB!!! Table has 155 fields: 24 DATE, 15 LONG, 9 SINGLE, rest CHAR of varying size (sum of all char sizes = 1307) All of the "extra" fields introduced in the new...

My original MDB was 220 MB with 1 table. Table had 26 fields: 1 DATE, 2 LONG, rest CHAR of varying size. New MDB with 1 table is 1.9 GB!!! Table has 155 fields: 24 DATE, 15 LONG, 9 SINGLE, rest CHAR of varying size (sum of all char sizes = 1307) All of the "extra" fields introduced in the new...

My dept is building a data warehouse and evaluating web-based reporting tools to put on top of the data. Cognos is a leading contender but here's my concern: the DW/reporting product is not for our internal use--it is for our clients, and will be installed at our client sites because the data...

I am pushing data to Word from Access 2003. This code and subsequent document manipulation all works IF I have Word already open with any document (the 'GetObject'piece works). If I DON'T have Word open, it drops to the 'CreateObject' code and always fails on this line with Err.Number =...

I am starting a SQL Server 2005 database project that involves replicating work currently done using large SAS datasets (20 - 30 GB total). Can I estimate the initial size of my SQL Server database using the size of the SAS datasets and perhaps some adjustment factor? Just looking for a...

I've been tasked to rebuild an existing reporting tool on an ASP.NET/SQL Server 2000 platform. The existing tool has the data and user interface in Access 2000 and the reports in Excel 2000. I'm trying to determine whether I can utilize Analysis Services here to improve performance or...