Search results

neat! I like your little man sitting there at the computer, just programming away.

To SQL Hell (why do you call yourself hell?) Thanks for all your comments and sharing your knowledge, it is really appreciated.

To pdx man (what's pdx anyway?) Thanks for all your comments, this is really interesting, I'm glad you have been trying to help Dave, and that he is answering your questions. I'm learning a lot from this discussion.

Hi Dave I'm very new with MS-SQL Server, but I'll give it a try anyway. I am thinking that the code you're using between MS-Access and MS-SQL Server might be taking the extra time. What if you you ran it from MS-Access using code with the ADO connection object? (That is referenced around here...

Probably hardly anybody else will encounter this, but I found it interesting anyway. We have a working application back end MS-SQL 2000, front end MS-Access 2003. In one of our procedures, we run the sp_who system procedure to find out who is logged in, and write a table with the entire...

Just a wild guess, but if that table is being written to Access (local table) then it would be much faster that way? Also, what about using a stored procedure to do this, passing parameters and using the ADO connection connection object? That should be (theoretically) pretty fast?

Hi Kodo, Thanks very much. This is just exactly what I was looking for and now I think I've gotten to the bottom of this mystery.

Thanks for your info. If you were going to search for some info on this, how would you search for it? I'm drawing total blanks. Found out that Microsoft has a tool SSMA to do migration from MS-Access to MS-SQL, but haven't been able to find anybody having any specific problems because of SQL...

Hello! You have such an interesting sign-on. So, do you think there are issues with Access 2003 and SQL-Server 2005? Rumor is that Access 2003 is not supported by SQL-Server 2005. We have running applications Access 2003 to SQL Server 2000, and are looking for any hints that would indicate...

Thanks for this, just exactly what I needed to know, you just saved me about 100 pages of reading. We are using this at work already.

That's really incredible! I think people lose these cases 99% of the time. Not only that, but it seems there is some law about commercial inventions that the patents expire after a certain period of time so that they will become generally available. But just what was this "Blackberry"...

Wow, thanks for this too! This sounds like exactly the same concept. This has got to be where the generic ("copyrighted") database came from. Pick and sharepoint both seem to be the very same idea, if I am understanding correctly. I still haven't seen any table design (for pick or...

Thanks, Pat. That's exactly how this works, if I have understood your description correctly (which was much clearer than my attempted description of this database design.) The specific field names are stored as field values, that's the essence of it. The actual field names are generic, so...

Hi again Alan, sorry for the multiple postings, but you got me inspired here. Some more implementations I thought of: Also add company size to the membership information. Add transfer history to membership info? Or handle this with statistics. So another category might be separate for...

Hi Pat, another queestion for you. Could you possibly point me to an example of this "Pick" as well as an example of "Sharepoint" table design, I did search a bit but wasn't able to come up with anything tangible. Or if you could just describe what you know of it?

I'd be very interested in comparing notes with you. Basically, how it works is to categorize things on 3 levels. These levels could be anything. I'll take a travel agency, for example. The first level might be "Tours". The second level might be the starting date /destination, something that...

Hi Alan, Thank you as well for your very informative answer. I think it's pretty safe to say that this is a very grey area, and not something that someone can really have the corner of the market on. Besides, I would make some changes to the design, as well as the implementation and it would...

Hi Doc Man! Thanks very much for your informative answer. I will save it and "chew it" some more. My grandfather having been a patent lawyer, ah well, he is no longer available to ask questions to, but anyway, I think as long as I don't copy his field names, I could use the general idea. I...

Hi Pat, Yes, he did let me analyze it. Thanks for the info on SharePoint, I'll check it out, since it might be good for really small databases, those are the ones I usually work with.

It's not the normal way that you'd see a database designed, it's pretty different. Some things, like address tables are pretty usual, but the rest, the way of marking and tagging things, is very generic, that's what fascinates me about it.