Recent content by DonS100

I'm going to push some raw data into a excel worksheet from access. I then want to have another worksheet that is better formatted for the user but based on the first tab. Lets say the the raw data worksheet has 200 rows with 2 column each. The first column in is for the product description...

I have a user that when she prints one report it looks distorted (the letters in the words are all jumbled together. When I print the report it looks fine, and when this user prints other reports they are fine. Would this be an issue with the printer driver or some setting on the individual...

I'm using SQl Server 2000 reporting services. Twice I have had to restart the server when using reporting services. I see the following error message in the SQL Server log. Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 72, ECID 0, UMS Context 0x250DE7F8. Anyone...

Hello, I have an Access 2003 application that uses SQL Server 2000 as the backend. On my invoice screen I use SQL pass though Queries to load certain combos. Before I enter the invoice screen, I refresh my pass though query using the QueryDef object. In the code below, I set it to use a...

The jetcomp didn't fix it. Don

I tried the transferdatabase code but still get a runtime error 29072. Microsoft Office Access has detected corruption in this file.

Hello, I have an access 2003 mdb file that it say it's corrupted. I tried to repair it but it gives me the same message. I went back to a backup version. I had modified 7 reports since this version of the backup. Is there any way to get the 7 modified reports out of the corrupted mdb. I...

Hello, I have an Access 2003 application that is currently being used from my United States clients. Soon, a UK client is going to start using it though Citrix. They have their regional settings though Citrix set as English (United Kingdom). It's not an option to change their regional...

Hello, I have deployed a Access 2003 mde file on Citrix. It's been working well but today I added another Access 2003 application (which is password protected) to the Citrix system. When the users click on the icon for the first mde file it prompts them for the database password, I'm...

Hello, I have one user that reports that some of her access reports print miniature. She using the Access 2003 runtime. If she directly prints a report it's fine, but when she first previews its(Still looks fine) and then prints from the preview screen it prints miniature. The report is...

How do you create a new database with an existing mdf and ldf file if you don't have a backup file. Thanks DOn

Hello, I have a products database that I need to recreate somewhere else but with no data in the tables. Is the best way to do this, simply using the 'Generate SQL Script' option though Enterprise Manager against the existing database. Are there any objects that will not get created? One...

Hello, I have an Access 2003 application using SQL authentication to access SQL Server 2000. I connect though linked tables and ADO. I'm trying to set the Workstation parameter to the current user. It doesn't seem to update correctly. I've gotten a value to go into the setting but then it...

I would prefer to keep the SQL Authentication for other reasons.

Hello, I have an access application that uses Linked tables to connect to a SQL Server using SQL Server authentication. I'm trying to store the user name somewhere so it will show up in the process section of SQL Server. I'm trying to stored it in the WSID(Workstation ID?) but when I relink...