Search results for query: *

Thanks traingamer, I did not even know that there was a Soundex function. I started doing some searching and found the link http://www.dhs.ca.gov/ps/ooa/HIVReporting/soundex/soundex.htm. In combination with the code that you linked-to, I can do my project.

I have just found a link that might help a great deal: http://www.dhs.ca.gov/ps/ooa/HIVReporting/soundex/soundex.htm. On this web page is a Microsoft Access db with code on using Soundex and an Excel spreadsheet with code on using soundex. Good luck

Though I am just starting down this road also and have just seen this post, I have a master database with names in it and data provided in an excel spreadsheet. I was going to use this code to make a table, tbla, that has a these produced keys from the master database, then another,tblb, on the...

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...

You are correct 100% and have helped me a great deal. I just did not realize the effect of roles and local vs remote access. Thanks

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...

I have a very basic question to ask, with the merge of BO and Crystal, is there going to be a Crystal Enterprise or Reports certification in 3 years? I think the answer is no, but any comments, rebuttals, etc. please let me know. Assuming no which has at least a 75% chance of happening, then...

Thanks for this info. I've just finished my MCDBA, knew very well it was not "automatic" especially after paying $125 per exam * 4 exams but I did not know how to proceed. Thanks again

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...

Sorry, I'm not knowledgeable about the MDX query setup but why not just make a dimension and do a count that way? easier then setting up a on-the-fly query!

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...

Thanks ejsmith for your suggestion. As it turns out, I can delete the links 1st and then re-allocate them. The original problem / issue was because of the account I was using, not the normal "sa" account but another sa-look-alike, was not allocated on the server I was having trouble on. I...

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 a 8777Meg DB with autogrow set @ 10 percent. Sorry, but I'm not sure what the auto grow has to do with this type of error; please explain :) FYI, regarding the vendor, I had to FTP a file, 24 Meg, last night and the ftp took almost 2 hours to download, it speaks loads of what what this...

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...

Yes there are DNS's on the machines but I think that cmmrfrds has solve my problem / question. Thanks to everyone for all your help its greatly appreciated.

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...

rhinok, thanks for your help, I did not know that the 501 error was a SMTP error.