Search results for query: *

I have a problem in using MS Access to perform a name recognition and lookup. My data to find may looklike - BenAround. I have to somehow match / find data that may looklike a) Ben Around b) Ben Arou c) or any number of other unususual combination in a SQL database. What I am lookign for is an...

I have installed AS, allocated a cube local to a server. I have allocated a local cube, processed with dims and measures, etc. no problem. I can do Crystal Reports, etc. no problem. When I try to do any remote access, from the Administrator account only, I can only get the FoodMart cube; other...

Anyone have any info on the Microsoft SQL 2005 cert? I've just completed the MCDBA cert by taking the 70-305 exam this past weekend plus the other 3 exams for the full cert. I feel its going to require a .NET MCP exam in addition to Admin and Design, any guess's / comments welcomed. FYI...

In running MS Analysis developer services,the doc's imply that you need to be running a) local or b) with a Domain setup to be able to have network users access a cube. We run workgroup here with Novel 6.0, so that implies I need to make .CUB files if I want a network user to access Cube data...

I have done some Analysis Services but have not had to create a local .CUB file, because of using Windows Domain setup. Now I need to setup a .cub file because we are running Novel, Workgroup (not Domain), Win 2k server sp4, Novel 6.0. When I try to access the AS from a local Developer PC, it...

Having to maintain 9 databases, I use access to run reports 9 times. I have some code to re-link tables from 1 DB to another but I have to logoff 1st before I go onto the next database. If you would supply a hint or some code I would greatly appreciate the help.

We have installed MS SQL 2000, yes no service packs due to a vendor requirement, and are having a SQL 17803 Insufficient Memory available problem. I have looked around and found that having Auto Shrink on, may cause / lead to this type of problem but seem to point to SQL 7 versus SQL 2000. I...

I could really use some VB Access 2000 code to create an ODBC link to a MS SQL database. We have 9 SQL db's, that run many of the same reports, this code will help out a great deal in streamling reporting. I've looked at TableDefs and other methods but am lost on how to proceed. Please do...

Anyone have Microsoft Access 2000 Visual Basic code where I can create an ODBC link to a SQL 2000 database in a MS Access dataabase? I know its been done, like 2mill times, but now I actually have a need for the code and am having problems. Thanks ahead of time for any help, its greatly...

When running a Crystal 10 report with CE 10, I get an error message : address error. CrystalEnterprise.Smtp: (501). It is a valid reprot and runs OK when not doing SMTP e-mails. When I turn on the notification area and have an e-mail sent when an error is encountered, it sends an e-mail...

I am using CE 10 and have created a business foundation in / under Business Views. Is there a way to copy the business foundation to another name, not rename? Thanks for your help

I am using CE 10 and have created a business foundation in / under Business Views. Is there a way to copy the business foundation to another name, not rename? Thanks for your help

We are using CR 8.5 and 10 to output a file so that it can go into a OCR (old crappy whatever) optical car reader system. The input file cannot have "hard" returns nad be of some text format. I ahve tried .txt files / format, .RIF and others. Anyone ahve any experience in this area?

I am new to CE 10 and have installed CE10. I have run a report OK but cannot get CE10 to run and print a report. I have gone to the Schedule tab, under format and made sure that the report is set to Crystal Report, then gone to the destination to see the drop down for a printer option, but...

We are going to install CR10 and CE 10. I am hoping that with the 9 databases we have, that CR/CE 10 will give us better data access across 9 databases that we run daily reports on. Ideally we would like to see a single report for maintenance reasons. Today, we have a small unsupported...

I'm using CR 8.5 and trying to suppress a report when there is no data. I'm using the Suppress Blank section, with and without a condition, isnull({fielda}). The report and sections still print blank text lines. Any help is greatly appreciated.

hi all, i'm trying to get sql mail to work. I have installed outlook, have a mail profile, etc. but when I do a xp_startmail in QA I get this message: xp_startmail: Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account ro run...

Sorry, I'm having a brain freeze day, in doing a insert into tbl1 (field1, field2) select fielda, fieldb from tbl2 I dont want duplicate data for field2. Please help, thanks

I have many txt files to import into SQL and there are duplicate records based on a telephone number. I only want the 1st one in the data file, the rest dont matter. What is a way to do this? I heard that there was a first record property but I have not found where I can use it in dts...

Anyone ever look at Web Matrix as a beginning / get-your-feet wet / just starting out .NET developer product? I am aware of the difference in programming that has to be done, if Visual Studion is installed at a later date and not being able to do so many of the VS features. I am wide open to...