Access Experts: Discussion Thread (06-Jul-2009)
This thread is intended for general discussion among Experts participating in the Access zones.
Discussion topics can include (but are not limited to) Access and zone related issues, tips, tricks, news etc.
This thread is publically visible, so please keep comments professional (eg: no flaming or derogatory comments about other Members). If you do have topics that should be handled offline, please contact me or JDettman at our e-e.com email addresses.
Thanks,
mbizup
Access Zone Advisor
Discussion topics can include (but are not limited to) Access and zone related issues, tips, tricks, news etc.
This thread is publically visible, so please keep comments professional (eg: no flaming or derogatory comments about other Members). If you do have topics that should be handled offline, please contact me or JDettman at our e-e.com email addresses.
Thanks,
mbizup
Access Zone Advisor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"how widely used is Access 2007"
My take ... by developers, not that much. By non-developers, more and more - due to companies upgrading to A2007.
mx
My take ... by developers, not that much. By non-developers, more and more - due to companies upgrading to A2007.
mx
ASKER
Mark,
<how widely used is Access 2007>
I couldnt say for sure, but I'm also interested in how many Experts here are actively using it, if for no other reason than knowing who to contact when A2K7 - specific questions come up.
I've noticed an increasing number of A2K7 questions appearing here.
I do have a copy of it on my home computer that I have been using just to get familiar with it, and to try my hand at answering some of the questions out there that deal with features specific to Access 2007.
We are years away from transitioning to A2K7 at work.
<what would you recommend as the best combo of Access to have running to become really expert in these threads >
At this point I feel that Access 2003 is plenty good enough as a starting point for answering most of the questions posted here. There are some questions that are really specific to Access 2007, but it seems like most of the A2K7 questions can be answered with a good understanding of previous versions of Access.
<how widely used is Access 2007>
I couldnt say for sure, but I'm also interested in how many Experts here are actively using it, if for no other reason than knowing who to contact when A2K7 - specific questions come up.
I've noticed an increasing number of A2K7 questions appearing here.
I do have a copy of it on my home computer that I have been using just to get familiar with it, and to try my hand at answering some of the questions out there that deal with features specific to Access 2007.
We are years away from transitioning to A2K7 at work.
<what would you recommend as the best combo of Access to have running to become really expert in these threads >
At this point I feel that Access 2003 is plenty good enough as a starting point for answering most of the questions posted here. There are some questions that are really specific to Access 2007, but it seems like most of the A2K7 questions can be answered with a good understanding of previous versions of Access.
"I've noticed an increasing number of A2K7 questions appearing here. "
Yes, I meant to say that also re "By non-developers, more and more - due to companies upgrading to A2007."
" .... here are some questions that are really specific to Access 2007, but it seems like most of the A2K7 questions can be answered with a good understanding of previous versions of Access."
Agree.
mx
Yes, I meant to say that also re "By non-developers, more and more - due to companies upgrading to A2007."
" .... here are some questions that are really specific to Access 2007, but it seems like most of the A2K7 questions can be answered with a good understanding of previous versions of Access."
Agree.
mx
ASKER
<do you have it running alongside other versions >
I do have both A2K3 and A2K7 on one rarely used computer, but find the time involved in switching between versions very frustrating.
In general, I use A2K3 at work (real stuff) and A2K7 at home (play).
I do have both A2K3 and A2K7 on one rarely used computer, but find the time involved in switching between versions very frustrating.
In general, I use A2K3 at work (real stuff) and A2K7 at home (play).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't git me started on Ribbons!
mx
mx
Think I will just hang with A2003 and save up to buy A2007 with the next lot of hardware...
I haven't even seen the 2K7 other than screen shots here. I'm XP/02 at work. Right now we are looking to maybe go to 03. But several of our vendors are still not certifying 07.
Of all the Acc07 Q's I have seen here, it looks like a step backwards. Or is that just a bad opinion?
Of all the Acc07 Q's I have seen here, it looks like a step backwards. Or is that just a bad opinion?
"Or is that just a bad opinion?"
Not much of a step forward.
mx
Not much of a step forward.
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And another quote (sorry - but they prompt futher comments ;-)
>> "Do NOT even get me started on multi-valued fields :)"
Well, see - I don't actually hate MVFs.
Would I use them in any database application? Not in a million years.
But the complex data type has, by definition, yielded the Attachment data type - and that does have very real merit. (It could be argued that MS could have just introduced an improved BLOB data functionality to replace OLE Embedding - but they didn't so that's that. lol
They also allow a better alignment with Sharepoint functionality and integration. And, like it or not, Sharepoint is doing big things in the market and Access hanging off that should only help its continuation.
Cheers - again.
>> "Do NOT even get me started on multi-valued fields :)"
Well, see - I don't actually hate MVFs.
Would I use them in any database application? Not in a million years.
But the complex data type has, by definition, yielded the Attachment data type - and that does have very real merit. (It could be argued that MS could have just introduced an improved BLOB data functionality to replace OLE Embedding - but they didn't so that's that. lol
They also allow a better alignment with Sharepoint functionality and integration. And, like it or not, Sharepoint is doing big things in the market and Access hanging off that should only help its continuation.
Cheers - again.
DatabaseMX said:
>>Don't git me started on Ribbons!
The Ribbon makes me feel like an idiot sometimes in Excel 2007 :)
I find very few long-time users who are neutral on Ribbons; folks either love them or hate them.
>>Don't git me started on Ribbons!
The Ribbon makes me feel like an idiot sometimes in Excel 2007 :)
I find very few long-time users who are neutral on Ribbons; folks either love them or hate them.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't use Access 2007 at all and have never even bothered to load it.
<<Well, see - I don't actually hate MVFs.
Would I use them in any database application? Not in a million years.
But the complex data type has, by definition, yielded the Attachment data type - and that does have very real merit. (It could be argued that MS could have just introduced an improved BLOB data functionality to replace OLE Embedding - but they didn't so that's that. lol
They also allow a better alignment with Sharepoint functionality and integration. And, like it or not, Sharepoint is doing big things in the market and Access hanging off that should only help its continuation.>>
MVF's are not actually that; it's just smoke and mirrors on Access's part. The data appears that way, but it's never stored that way. Only reason it was done was to support use in Sharepoint.
JimD.
<<Well, see - I don't actually hate MVFs.
Would I use them in any database application? Not in a million years.
But the complex data type has, by definition, yielded the Attachment data type - and that does have very real merit. (It could be argued that MS could have just introduced an improved BLOB data functionality to replace OLE Embedding - but they didn't so that's that. lol
They also allow a better alignment with Sharepoint functionality and integration. And, like it or not, Sharepoint is doing big things in the market and Access hanging off that should only help its continuation.>>
MVF's are not actually that; it's just smoke and mirrors on Access's part. The data appears that way, but it's never stored that way. Only reason it was done was to support use in Sharepoint.
JimD.
Are not actually what? MVF's?
Yes - MS have expounded upon the fact that the data is stored relationally.
How it's stored isn't a concern though when the access to that data is only through a very prescribed avenue.
Yes - MS have expounded upon the fact that the data is stored relationally.
How it's stored isn't a concern though when the access to that data is only through a very prescribed avenue.
<<Are not actually what? MVF's?
Yes - MS have expounded upon the fact that the data is stored relationally.
How it's stored isn't a concern though when the access to that data is only through a very prescribed avenue.>>
Yes. I just wanted to make sure that people understood that. Their not something to be leery of using because they are stored relationally.
But with all that said, I don't see any great benefit to using them. Like I said, only reason it was added was to support sharepoint.
JimD.
Yes - MS have expounded upon the fact that the data is stored relationally.
How it's stored isn't a concern though when the access to that data is only through a very prescribed avenue.>>
Yes. I just wanted to make sure that people understood that. Their not something to be leery of using because they are stored relationally.
But with all that said, I don't see any great benefit to using them. Like I said, only reason it was added was to support sharepoint.
JimD.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just KNEW pDog would ... have a link, cuz he IS the king of cool links!!
mx
mx
Actually, I've been wondering about VPC (or similar) as an alternative, but I have sooooo many questions.
mx
mx
ASKER
pdb,
I haven't tried Virtual PC myself yet - the system/network admins tell me exactly what goes on my work computer and my home computer tends to get neglected :)
Jim and all,
< We've tried this single threaded discussion before and it didn't work all that well. >
I had the continuing series of threads used by the Excel regulars in mind when posting this. This is an early example:
https://www.experts-exchange.com/questions/22157604/Excel-Experts-Exchange-Regulars-take-3.html
My thought was that this sort of thread could be used as a place for collaboration, brief discussions, milestones, personal acheivements or any other comments between Experts (within reason) that might not warrant their own threads but don't belong on the Expert Notify thread, which is a dedicated help line.
<It's too hard to wade through.>
This is indeed a potential drawback, but I also like the overall community aspect.
If there is interest, I think it is worth another shot.
I haven't tried Virtual PC myself yet - the system/network admins tell me exactly what goes on my work computer and my home computer tends to get neglected :)
Jim and all,
< We've tried this single threaded discussion before and it didn't work all that well. >
I had the continuing series of threads used by the Excel regulars in mind when posting this. This is an early example:
https://www.experts-exchange.com/questions/22157604/Excel-Experts-Exchange-Regulars-take-3.html
My thought was that this sort of thread could be used as a place for collaboration, brief discussions, milestones, personal acheivements or any other comments between Experts (within reason) that might not warrant their own threads but don't belong on the Expert Notify thread, which is a dedicated help line.
<It's too hard to wade through.>
This is indeed a potential drawback, but I also like the overall community aspect.
If there is interest, I think it is worth another shot.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FYI - Microsoft Virtual PC works great. Entire backup process is smooth and loads about as fast as turning on a computer. There are essentially 3 files - one is the descriptor file (.vmc) the other 2 or more are drive C and D, etc.. I put all 3 files together on my D drive in a VM folder so they are completely backed up. Don't backup when the VM is running though.
You can make the disks as big as you need up to up to 16GB (I think). Moving to another place - just copy the files and repoint the VM descriptor using the interface.
You can download at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=04D26402-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en
You can make the disks as big as you need up to up to 16GB (I think). Moving to another place - just copy the files and repoint the VM descriptor using the interface.
You can download at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=04D26402-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en
Just a note on the Virtualization front; while overall things work well at this point (being that most solutions have been around for a while now), I have heard of a few instances where considerable time can be spent a troubleshooting issues involving the hardware (ie. having multiple NIC cards).
I think at this point most solutions are pretty stable and do work well, just don't be surprised if it doesn't come off as easy as it sounds.
FWIW,
JimD.
I think at this point most solutions are pretty stable and do work well, just don't be surprised if it doesn't come off as easy as it sounds.
FWIW,
JimD.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"specially if you kill the ribbon - users don't like it."
:-)
Some groups within our company are apparently being given O2007. Fortunately my group is not, partially due to my request to delay that change over until way later in the year or next year. That would be a major distraction at the moment. A few users I have spoken to do not like the Ribbon.
mx
:-)
Some groups within our company are apparently being given O2007. Fortunately my group is not, partially due to my request to delay that change over until way later in the year or next year. That would be a major distraction at the moment. A few users I have spoken to do not like the Ribbon.
mx
DatabaseMX said:
>>A few users I have spoken to do not like the Ribbon.
My personal impression is that very experienced users are flummoxed by the Ribbon, but that new users
do better with the Ribbon. The term the Microsoft UI guys and gals like to use is "discoverability", and they
are quite right that the Ribbon offers more discoverability of function than the menus ever could.
The problem comes when you have people so used to the menus that they can navigate the menus
without even really thinking about it. Those people (and I would guess just about everyone reading this thread,
or the similar thread over in the Excel zone) feel the pain of having to consciously look for the functions that
we used to just find effortlessly. We don't appreciate the "discoverability" of the Ribbon because we really
don't have a need to discover anything: we know what we want, and we used to know how to find it
intuitively, but our intuition is no longer giving us valid clues.
Eventually we will learn the Ribbon the same way we learned the menu, and MS will also improve the ability
to customize the Ribbon. Folks like us will feel a lot of pain in the meantime.
>>A few users I have spoken to do not like the Ribbon.
My personal impression is that very experienced users are flummoxed by the Ribbon, but that new users
do better with the Ribbon. The term the Microsoft UI guys and gals like to use is "discoverability", and they
are quite right that the Ribbon offers more discoverability of function than the menus ever could.
The problem comes when you have people so used to the menus that they can navigate the menus
without even really thinking about it. Those people (and I would guess just about everyone reading this thread,
or the similar thread over in the Excel zone) feel the pain of having to consciously look for the functions that
we used to just find effortlessly. We don't appreciate the "discoverability" of the Ribbon because we really
don't have a need to discover anything: we know what we want, and we used to know how to find it
intuitively, but our intuition is no longer giving us valid clues.
Eventually we will learn the Ribbon the same way we learned the menu, and MS will also improve the ability
to customize the Ribbon. Folks like us will feel a lot of pain in the meantime.
Image this concept re the Ribbons in A2007. A check box in Options to ... are you ready .... use the old tried and true menu system or the new Ribbon system; and it allows you to switch back and forth for that matter.
With the old system, it was trivial (no code required) to create super cool custom menus, right click menus and tool bars. I don't think that is the case with the XML based Ribbon paradigm ....
mx
With the old system, it was trivial (no code required) to create super cool custom menus, right click menus and tool bars. I don't think that is the case with the XML based Ribbon paradigm ....
mx
DatabaseMX said:
>>Image this concept re the Ribbons in A2007. A check box in Options to ... are you ready .... use the old
>>tried and true menu system or the new Ribbon system; and it allows you to switch back and forth for that
>>matter.
Not. Gonna. Happen. :)
>>With the old system, it was trivial (no code required) to create super cool custom menus, right click
>menus and tool bars. I don't think that is the case with the XML based Ribbon paradigm ....
I manipulated the menus frequently with code. It was easy and nifty.
You can use the XML to create your own Ribbon (I recommend the RibbonX book by Martin, Puls, and
Hennig), but it is fraught with peril, and there is no way to programmatically reload the Ribbon on the fly.
>>Image this concept re the Ribbons in A2007. A check box in Options to ... are you ready .... use the old
>>tried and true menu system or the new Ribbon system; and it allows you to switch back and forth for that
>>matter.
Not. Gonna. Happen. :)
>>With the old system, it was trivial (no code required) to create super cool custom menus, right click
>menus and tool bars. I don't think that is the case with the XML based Ribbon paradigm ....
I manipulated the menus frequently with code. It was easy and nifty.
You can use the XML to create your own Ribbon (I recommend the RibbonX book by Martin, Puls, and
Hennig), but it is fraught with peril, and there is no way to programmatically reload the Ribbon on the fly.
How do you know it's not gonna happen ?
Code or no code ... yes, it was easy to do for sure. And worse, now ... all those custom menus show up on the Add-In Ribbon.
"but it is fraught with peril"
Can you elaborate a bit ?
Of course, we do have this:
http://www.addintools.com/
mx
Code or no code ... yes, it was easy to do for sure. And worse, now ... all those custom menus show up on the Add-In Ribbon.
"but it is fraught with peril"
Can you elaborate a bit ?
Of course, we do have this:
http://www.addintools.com/
mx
DatabaseMX said:
>>How do you know it's not gonna happen ?
Well, everything MS has put in public view has said that:
1) There is no going back
2) There will never be a "compatibility mode"
>>"but it is fraught with peril"
>>Can you elaborate a bit ?
Ken Puls can explain it far better than I can. The gist of it is that some errors in customizing the Ribbon can
cause it to simply unload, and there is no way to recover from that except by killing the Access/Excel/Word
process and relaunching the application.
There are also severe constraints on the ability to modify the Ribbon at will. For example, in Excel 2003 I
can do just about whatever I want, whenever I want to the menus, but with the Ribbon I only get one crack
at it. For now, anyway...
>>How do you know it's not gonna happen ?
Well, everything MS has put in public view has said that:
1) There is no going back
2) There will never be a "compatibility mode"
>>"but it is fraught with peril"
>>Can you elaborate a bit ?
Ken Puls can explain it far better than I can. The gist of it is that some errors in customizing the Ribbon can
cause it to simply unload, and there is no way to recover from that except by killing the Access/Excel/Word
process and relaunching the application.
There are also severe constraints on the ability to modify the Ribbon at will. For example, in Excel 2003 I
can do just about whatever I want, whenever I want to the menus, but with the Ribbon I only get one crack
at it. For now, anyway...
ok ... thx for that. wow!
mx
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just create a standard html HREF tag ... which is accepted here. For example
http:#a24787645
will take you to Leigh's post above.
mx
http:#a24787645
will take you to Leigh's post above.
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just used the Insert Link functionality (the "T" in the formatting toolbar in the Comment box).
Inserted the URL and then the desired display text. Simples. :-)
Inserted the URL and then the desired display text. Simples. :-)
ASKER
Leigh's comment
<Insert Link functionality (the "T" in the formatting toolbar in the Comment box).>
Good stuff! I had pretty much given up on the Rich Text formatting because there were so many issues with it early on.
That is a nice feature.
<Insert Link functionality (the "T" in the formatting toolbar in the Comment box).>
Good stuff! I had pretty much given up on the Rich Text formatting because there were so many issues with it early on.
That is a nice feature.
Great stuff.... thinks very much, will try that :) Also thanks for everyones support / comments on that other thread. Much appreciated.
Back to here : back to here
Back to here : back to here
Scott ... that doesn't work ....
mx
mx
It does in the "Rich Text" mode ... but I guess EE detects the "mode" of the user's post and adjusts from there.
Yes, you would think it would have worked. I don't use the RTF mode ... but http:#a24802263 to jump on the same page works.
mx
mx
Then the other shortcut is http:/Q_24546754.html#24786584 will jump you to another EE question and comment. Note the single slash. These are only good on EE.
If you're semi-lazy https://www.experts-exchange.com/questions/24546754/Expert-Notify-Thread-For-those-answering-questions-in-the-MS-Access-Zones.html#24786584 will work on the general internet back to EE.
If you're semi-lazy https://www.experts-exchange.com/questions/24546754/Expert-Notify-Thread-For-those-answering-questions-in-the-MS-Access-Zones.html#24786584 will work on the general internet back to EE.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nah, save that for the C++ guys (that's safe here isn't it)
The link that is in question at the moment is the <a href="put url here">Click here</a>
The link that is in question at the moment is the <a href="put url here">Click here</a>
(unrelated) Everyone ...FYI:
http://blogs.msdn.com/access/archive/2009/07/06/free-report-wizard-offer-from-gladstone.aspx
free
mx
http://blogs.msdn.com/access/archive/2009/07/06/free-report-wizard-offer-from-gladstone.aspx
free
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Minimal data ... email only really. other fields are not required.
I should note I did not check it out myself. Found out via friends in Access users group who have tried it.
mx
I should note I did not check it out myself. Found out via friends in Access users group who have tried it.
mx
<<Minimal data ... email only really. other fields are not required.>>
Yeah, it's just that when I see "free", I also remember TANSTAAFL; There Ain't No Such Thing As A Free Lunch. Especially when something that was being sold for $995 is now being given away.
While in this case it's probably pretty beign and the data may go no where, it might get sold to some 3rd parties. I didn't see a privacy statement on the site, so I don't bother to download it. Get enough spam already.
JimD.
Yeah, it's just that when I see "free", I also remember TANSTAAFL; There Ain't No Such Thing As A Free Lunch. Especially when something that was being sold for $995 is now being given away.
While in this case it's probably pretty beign and the data may go no where, it might get sold to some 3rd parties. I didn't see a privacy statement on the site, so I don't bother to download it. Get enough spam already.
JimD.
Maybe this was just Brunch, lol. Anyway ... as I noted ... it was mainly an fyi.
mx
mx
Gladstone's Privacy Statement: http://fairsoftware.com/privacy.aspx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> Get enough spam already.
My suggestion is to use gmail as your primary account e-mail account. I get tons of spam to it, but only maybe five a week actually hit my inbox. Then for the throw away sites (ones that nag you consistently to have a sign-on like tek-tips.com, SearchSQLServer.com, etc.) you have a throw away e-mail from Hotmail or Yahoo. Accounts you check once a month -- select all -- delete.
My suggestion is to use gmail as your primary account e-mail account. I get tons of spam to it, but only maybe five a week actually hit my inbox. Then for the throw away sites (ones that nag you consistently to have a sign-on like tek-tips.com, SearchSQLServer.com, etc.) you have a throw away e-mail from Hotmail or Yahoo. Accounts you check once a month -- select all -- delete.
ASKER
Odd ordering in the HOF in the main Access zone today:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/
https://www.experts-exchange.com/Microsoft/Development/MS_Access/
mbizup, that has been noted and EE are already working on a fix...
Yes ... at first it was just on the Month. NOW ... it's only on the Week (out of order). Weird.
mx
mx
I think I have this sorted, but want to see if anyone can truly point to the answer.
The Asker was adding a filed called ItemID to a replicated Acc2K DB. It doesn't show up in the design or datasheet view. But errors trying to re-add it. Turn off the Replication and it is fine.
I can't find "ItemID" in the reserved/keyword lists for Access or JET, but apparently it is. Am I missing a list?
MS Access 2000 Field HIdden in Table View Why?
https://www.experts-exchange.com/questions/24597987/MS-Access-2000-Field-HIdden-in-Table-View-Why.html
Thanks.
The Asker was adding a filed called ItemID to a replicated Acc2K DB. It doesn't show up in the design or datasheet view. But errors trying to re-add it. Turn off the Replication and it is fine.
I can't find "ItemID" in the reserved/keyword lists for Access or JET, but apparently it is. Am I missing a list?
MS Access 2000 Field HIdden in Table View Why?
https://www.experts-exchange.com/questions/24597987/MS-Access-2000-Field-HIdden-in-Table-View-Why.html
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PDB,
Very good link -- have it bookmarked. Thanks
I always just used the following links.
List of reserved words in Access 2002 and in later versions of Access
http://support.microsoft.com/kb/286335/en-us
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/kb/321266
But it seems that it is a different issue after all. I'm not having the same issue. But I also haven't done Acc replication ever.
Very good link -- have it bookmarked. Thanks
I always just used the following links.
List of reserved words in Access 2002 and in later versions of Access
http://support.microsoft.com/kb/286335/en-us
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/kb/321266
But it seems that it is a different issue after all. I'm not having the same issue. But I also haven't done Acc replication ever.
Sometime "Bad is Bad" (Huey Lewis):
A2007:
http://office.microsoft.com/en-us/access/HA100306431033.aspx
A2002 and A2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
A2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187
A97
http://support.microsoft.com/default.aspx?scid=kb;en-us;109312
mx
A2007:
http://office.microsoft.com/en-us/access/HA100306431033.aspx
A2002 and A2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
A2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187
A97
http://support.microsoft.com/default.aspx?scid=kb;en-us;109312
mx
>> I noticed you are showing System objects and I
>> had those Hidden. When I unhide those, then it
>> shows up when I look at the table.
All I can think on this is a bug or feature of replication. Anyone want to chime in?
https://www.experts-exchange.com/questions/24597987/MS-Access-2000-Field-HIdden-in-Table-View-Why.html
>> had those Hidden. When I unhide those, then it
>> shows up when I look at the table.
All I can think on this is a bug or feature of replication. Anyone want to chime in?
https://www.experts-exchange.com/questions/24597987/MS-Access-2000-Field-HIdden-in-Table-View-Why.html
jimpen,
not a bug......changes are made to system tables by design. see this link:
http://office.microsoft.com/en-us/access/HP052167961033.aspx
not a bug......changes are made to system tables by design. see this link:
http://office.microsoft.com/en-us/access/HP052167961033.aspx
Again many thank PDB.
couldn't see a reference in that last link to show why it would be hidden -
PlantID appears to be just a "normal" field and can see the other "system" fields used for replication. Or am I missing something ?
PlantID appears to be just a "normal" field and can see the other "system" fields used for replication. Or am I missing something ?
congratulations jimpen, I'm sure you will prove to be a great ZA...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<Please welcome him aboard and be nice to him. :-)>>
What, were not allowed to throw him to the Lions?
Welcome to the ranks Jim!
JimD.
What, were not allowed to throw him to the Lions?
Welcome to the ranks Jim!
JimD.
ASKER
Hi jaffer,
At present, we have three - Jim D, Jim P and myself.
Miriam
At present, we have three - Jim D, Jim P and myself.
Miriam
>> What, were not allowed to throw him to the Lions?
Don't you mean this pack of jackals? :-p
>> At present, we have three - Jim D, Jim P and myself.
Is A3 a floater then? Or is he doing it more as a Mod?
--------------------------
Many thanks all. I hope I can do this right.
Don't you mean this pack of jackals? :-p
>> At present, we have three - Jim D, Jim P and myself.
Is A3 a floater then? Or is he doing it more as a Mod?
--------------------------
Many thanks all. I hope I can do this right.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jim,
<Is A3 a floater then? Or is he doing it more as a Mod?>
a3 is a Zone Advisor as well (and a very active CV). His focus is more on SQL Server and General Databases, I believe.
Mark_Wills is also a ZA (SQL Server areas if I've got that right :) ) ... He is also a Page Editor (as is Jim D), working with the Articles Feature.
jaffer,
I't nice to see you show up occasionally. Good to know you're around!
Miriam
<Is A3 a floater then? Or is he doing it more as a Mod?>
a3 is a Zone Advisor as well (and a very active CV). His focus is more on SQL Server and General Databases, I believe.
Mark_Wills is also a ZA (SQL Server areas if I've got that right :) ) ... He is also a Page Editor (as is Jim D), working with the Articles Feature.
jaffer,
I't nice to see you show up occasionally. Good to know you're around!
Miriam
>> a3 is a Zone Advisor as well
Ah, thanks.
Ah, thanks.
Very cool !!!!
mx
mx
Jim,
">> What, were not allowed to throw him to the Lions?
Don't you mean this pack of jackals? :-p"
No, the Jackals come *after* the Lions....
JimD.
">> What, were not allowed to throw him to the Lions?
Don't you mean this pack of jackals? :-p"
No, the Jackals come *after* the Lions....
JimD.
>> No, the Jackals come *after* the Lions....
Then where do the tigers, bears and omai fit in?
Then where do the tigers, bears and omai fit in?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> are you talking about us Jim :)
Maybe -- Does that resemble you?
Maybe -- Does that resemble you?
Maybe :)
Let me get this right:
JimD said:
What, were not allowed to throw him to the Lions?
you said
Then where do the tigers, bears and omai fit in?
Hmmmm,
Now I understand what my Dad meant by saying: it's a jungle out there :)
jaffer
Let me get this right:
JimD said:
What, were not allowed to throw him to the Lions?
you said
Then where do the tigers, bears and omai fit in?
Hmmmm,
Now I understand what my Dad meant by saying: it's a jungle out there :)
jaffer
jaffer,
You missed the part about the jackals.
You missed the part about the jackals.
Nah I didn't miss it, JimD didn't miss it either,
>> the Jackals come *after* the Lions :)
jaffer
>> the Jackals come *after* the Lions :)
jaffer
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Really a lot of this has been suggested before but here is my list:
1. Better schwag: options other than t-shirts. The quality is good, but I'd like some other options. Especially professional shirts.
2. Make it a priority to have a professional side (job exchange) board within EE. I'm not saying rent-a-coder class, but some way I can pick up occasional consulting gigs for cash.
3. Throw out more raffles/awards that are "expert" geared and "substancial". (i.e. actual usable stuff)
4. Make sure the community volunteers get recognized. Maybe a shirt/schwag for longevity.
5. This is in a way small, but it helps: take the time to e-mail/MC experts that go beyond the call in their zones.
6. I know this is happening more often, but more willingness to censure PS members for abuse of EE. There was a mention in the ZA thread today of a guy with 30 open Q's. That sort of thing needs a notice even beyond the admin level he needs to change his ways.
Just my $0.03. Hope this helps.
1. Better schwag: options other than t-shirts. The quality is good, but I'd like some other options. Especially professional shirts.
2. Make it a priority to have a professional side (job exchange) board within EE. I'm not saying rent-a-coder class, but some way I can pick up occasional consulting gigs for cash.
3. Throw out more raffles/awards that are "expert" geared and "substancial". (i.e. actual usable stuff)
4. Make sure the community volunteers get recognized. Maybe a shirt/schwag for longevity.
5. This is in a way small, but it helps: take the time to e-mail/MC experts that go beyond the call in their zones.
6. I know this is happening more often, but more willingness to censure PS members for abuse of EE. There was a mention in the ZA thread today of a guy with 30 open Q's. That sort of thing needs a notice even beyond the admin level he needs to change his ways.
Just my $0.03. Hope this helps.
T-Shirts.
I have no problem with the T-Shirts. Black is good. I would never wear the previous blue ones out in public, but they do make good cloth to polish my guitars. I wear the black ones to LA Fitness (almost daily) when I work out. This is good advertising for EE ... since at least 3-4 people has asked "What is Experts Exchange". This is good for me, since it is likely to start a conversation with girls :-)
As Jim mentions above, a professional option would be good, such as a polo type shirt, that could be worn to a business meeting, etc. Again & Black is a must. On pocket would be very desirable, containing the EE logo, *website URL* and expert rank. This would be a classy item. So, you get to select a T-Shirt or Polo shirt possibly some additional options not sure what that would be at this time.
Newsletter:
My personal (duh) opinion of the NL is ... respectfully ... it's 80% filler, the majority of which has little to do with Expert activity here on the site. Wherein some of the articles may be interesting, I certainly do not have the time to read them. So, either there needs to be more content directly related to experts accomplishments (etc.) or ... just drop the filler articles and make the NL shorter, thus quicker to read.
Real Time Ranking System
We *seriously* need to bring back the real time expert ranking system that was removed a few months ago, noting that I personally *never* saw an performance issue - and I accessed that ranking page many times per day. Folks ... the major direct reward (aside from #7 in the survey that NetMinder posted) is a .... Points Based Reward System. I find it ironic that this feature has been removed from a site wherein the reward system is & points based. Frequently accessing that page (for the Access zone) was/is part of the fun and competitive aspect of the overall & experience. At the moment, the only clue is mainly the HOF section.
Raffles mention by jimpen & guess I missed those ???
EE has a very (albeit fragile) business model: Getting people to work for free (lol). Again, there are the subtle benefits of participating on the site, and I have no problem with that. Mainly pointing out that & the business model is fragile & so, *some* kind of rewards are a good thing J
I guess this is enough for the moment. Thanks for posting this question.
joe
I have no problem with the T-Shirts. Black is good. I would never wear the previous blue ones out in public, but they do make good cloth to polish my guitars. I wear the black ones to LA Fitness (almost daily) when I work out. This is good advertising for EE ... since at least 3-4 people has asked "What is Experts Exchange". This is good for me, since it is likely to start a conversation with girls :-)
As Jim mentions above, a professional option would be good, such as a polo type shirt, that could be worn to a business meeting, etc. Again & Black is a must. On pocket would be very desirable, containing the EE logo, *website URL* and expert rank. This would be a classy item. So, you get to select a T-Shirt or Polo shirt possibly some additional options not sure what that would be at this time.
Newsletter:
My personal (duh) opinion of the NL is ... respectfully ... it's 80% filler, the majority of which has little to do with Expert activity here on the site. Wherein some of the articles may be interesting, I certainly do not have the time to read them. So, either there needs to be more content directly related to experts accomplishments (etc.) or ... just drop the filler articles and make the NL shorter, thus quicker to read.
Real Time Ranking System
We *seriously* need to bring back the real time expert ranking system that was removed a few months ago, noting that I personally *never* saw an performance issue - and I accessed that ranking page many times per day. Folks ... the major direct reward (aside from #7 in the survey that NetMinder posted) is a .... Points Based Reward System. I find it ironic that this feature has been removed from a site wherein the reward system is & points based. Frequently accessing that page (for the Access zone) was/is part of the fun and competitive aspect of the overall & experience. At the moment, the only clue is mainly the HOF section.
Raffles mention by jimpen & guess I missed those ???
EE has a very (albeit fragile) business model: Getting people to work for free (lol). Again, there are the subtle benefits of participating on the site, and I have no problem with that. Mainly pointing out that & the business model is fragile & so, *some* kind of rewards are a good thing J
I guess this is enough for the moment. Thanks for posting this question.
joe
Typo above:
"On pocket" s/b "one pocket"
And I have no clue why the funny characters are showing above.
mx
"On pocket" s/b "one pocket"
And I have no clue why the funny characters are showing above.
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"Word seems to be the worst offender."
Yes .... Word via Outlook (email editor).
thx.mx
Yes .... Word via Outlook (email editor).
thx.mx
ASKER
<We *seriously* need to bring back the real time expert ranking system that was removed a few months ago>
Have you tried the Member Rank system lately?
Edit: IMO a vast improvement. I rarely have ever used it, but the slow load time previously killed my interest in it. It seems blazing fast now by comparison.
Have you tried the Member Rank system lately?
Edit: IMO a vast improvement. I rarely have ever used it, but the slow load time previously killed my interest in it. It seems blazing fast now by comparison.
Miriam ... do you mean like here:
https://www.experts-exchange.com/experts.jsp?etIndex=4&expertName=&typeID=10&periodID=4&zoneID=5297&subZoneID=39&submit=#expertTools
If so ... it's not real time. As of right now (15:25 pst) ... it's showing yesterdays results - updated 12:01 am on 8-18. So ... I don't see how this is any different than the HOF on the side of this page?
And as I indicated, I never once saw a performance problem with the original system.
mx
https://www.experts-exchange.com/experts.jsp?etIndex=4&expertName=&typeID=10&periodID=4&zoneID=5297&subZoneID=39&submit=#expertTools
If so ... it's not real time. As of right now (15:25 pst) ... it's showing yesterdays results - updated 12:01 am on 8-18. So ... I don't see how this is any different than the HOF on the side of this page?
And as I indicated, I never once saw a performance problem with the original system.
mx
Helen_Feddema picked up her Access Coding/Macros cert yesterday and her general MS Access cert today.
Congrats Q: https://www.experts-exchange.com/questions/24659731/Congrats-Helen-Feddema-on-Master's-cert.html
Helen_Feddema
https://www.experts-exchange.com/M_4970136.html
Congrats Q: https://www.experts-exchange.com/questions/24659731/Congrats-Helen-Feddema-on-Master's-cert.html
Helen_Feddema
https://www.experts-exchange.com/M_4970136.html
mx,
No it is not real time it gets updated once a day, similar to HOF.
It is different in so much as it shows more member, not just the top few (or top 100 if you go into it).
I for one am so very, very happy it is back - only use it once in a while, but often enough that I did feel a bit like a drug addict waiting for (maybe needing) the next fix each and every time I saw that "Down for Maintenance"... Maybe what we now have is the methadone version, but it satisfies my craving for now...
Helen_Feddema,
Congrats and well done !
No it is not real time it gets updated once a day, similar to HOF.
It is different in so much as it shows more member, not just the top few (or top 100 if you go into it).
I for one am so very, very happy it is back - only use it once in a while, but often enough that I did feel a bit like a drug addict waiting for (maybe needing) the next fix each and every time I saw that "Down for Maintenance"... Maybe what we now have is the methadone version, but it satisfies my craving for now...
Helen_Feddema,
Congrats and well done !
Well still ... I want the real time version back ... what can I say.
mx
mx
<< but often enough that I did feel a bit like a drug addict waiting for (maybe needing) the next fix each and every time I saw that "Down for Maintenance"... Maybe what we now have is the methadone version, but it satisfies my craving for now...>>
<<Well still ... I want the real time version back ... what can I say>>
Best advice I have (for all); forget about the points. You don't get burned out that way. Answer questions at your own pace and the way you want and the points will follow...or not.
And really, when it all comes down to it at the end of the day, does it matter all that much if they are two million vs three million or just to know that you've helped a lot of people?
FWIW,
JimD.
<<Well still ... I want the real time version back ... what can I say>>
Best advice I have (for all); forget about the points. You don't get burned out that way. Answer questions at your own pace and the way you want and the points will follow...or not.
And really, when it all comes down to it at the end of the day, does it matter all that much if they are two million vs three million or just to know that you've helped a lot of people?
FWIW,
JimD.
Yes, who cares. You can't buy anything for the points. All serious questions are set at 500 points. Could as well be 5 and we would save a bunch of zeroes.
Or skip the points and make access to the site more friendly.
Try this: Remove your EE cookie and click the URL to some old question. This is what the average user sees. The question and nothing else except popups with pay pay buy and pay. No wonder that some _exclude_ the EE site when they google for solutions.
Why not have an offer like "subscribe for a day" by one click and record the IP address?
If you wish your goodies to be accessible and helpful for the public, be sure to publish somewhere else than at EE.
/gustav
Or skip the points and make access to the site more friendly.
Try this: Remove your EE cookie and click the URL to some old question. This is what the average user sees. The question and nothing else except popups with pay pay buy and pay. No wonder that some _exclude_ the EE site when they google for solutions.
Why not have an offer like "subscribe for a day" by one click and record the IP address?
If you wish your goodies to be accessible and helpful for the public, be sure to publish somewhere else than at EE.
/gustav
cactus_data said:
>>Why not have an offer like "subscribe for a day" by one click and record the IP address?
Well, there is already a free trial offer :)
>>Why not have an offer like "subscribe for a day" by one click and record the IP address?
Well, there is already a free trial offer :)
<<Yes, who cares. You can't buy anything for the points. All serious questions are set at 500 points. Could as well be 5 and we would save a bunch of zeroes. >>
Well to a certain extent, it is a measure of participation. My point though was that it's best not to get hung up on points per say. You do what you can do.
<<Why not have an offer like "subscribe for a day" by one click and record the IP address?>>
That's a good idea and maybe you should submit it to EE. They do however have the option to try the site out for 30 days as a limited member. However you need to submit a CC up front to get through that. This might be a wise alternative, although I think a day might be too short to really get to know the site.
<<If you wish your goodies to be accessible and helpful for the public, be sure to publish somewhere else than at EE.>>
I don't entirely agree with that. For example, *everything* I did on CompuServe is gone. Mind you a lot of it would not apply at this point, but a lot of my early sample databases still would in terms of techniques. But CompuServe is no longer here.
There is also the platform used to deliver that help. EE is continually trying to make improvements and I'm aware of some things and the vision that will probably make it one of the best if not the best help site on the net. That doesn't happen in a vacuum as a lot of other sites have found out. They are either gone or they have not changed or been updated in any meaningful way.
Look at Dev's site; hasn't changed in format since day one and if you noticed has gotten pretty stale over the past few years. Not much has been added. Or look at Gary Robinson who publishes the vb123Maxout Access newsletter. He's shifted a lot from writing to simply publishing links. He also bought out the Smart Access archives (which went belly up), and is now trying to market them.
Whether you like EE's business model or not, it does take money to keep things going, improving, and growing. EE has been in existence now since 1996 and I fully expect it to be here for long time to come because it owners live in the real world rather then those that believe they can continue without making money and everything should be free.
JimD.
Well to a certain extent, it is a measure of participation. My point though was that it's best not to get hung up on points per say. You do what you can do.
<<Why not have an offer like "subscribe for a day" by one click and record the IP address?>>
That's a good idea and maybe you should submit it to EE. They do however have the option to try the site out for 30 days as a limited member. However you need to submit a CC up front to get through that. This might be a wise alternative, although I think a day might be too short to really get to know the site.
<<If you wish your goodies to be accessible and helpful for the public, be sure to publish somewhere else than at EE.>>
I don't entirely agree with that. For example, *everything* I did on CompuServe is gone. Mind you a lot of it would not apply at this point, but a lot of my early sample databases still would in terms of techniques. But CompuServe is no longer here.
There is also the platform used to deliver that help. EE is continually trying to make improvements and I'm aware of some things and the vision that will probably make it one of the best if not the best help site on the net. That doesn't happen in a vacuum as a lot of other sites have found out. They are either gone or they have not changed or been updated in any meaningful way.
Look at Dev's site; hasn't changed in format since day one and if you noticed has gotten pretty stale over the past few years. Not much has been added. Or look at Gary Robinson who publishes the vb123Maxout Access newsletter. He's shifted a lot from writing to simply publishing links. He also bought out the Smart Access archives (which went belly up), and is now trying to market them.
Whether you like EE's business model or not, it does take money to keep things going, improving, and growing. EE has been in existence now since 1996 and I fully expect it to be here for long time to come because it owners live in the real world rather then those that believe they can continue without making money and everything should be free.
JimD.
<>
Have you used the Share It feature?
Have you used the Share It feature?
Thanks JimD,
It actually isn't the points as much as "what next" at my rate getting to the next level is going to take a few years :)
So, my little game is the next set of 10 working towards top 100. Was figuring by the end of year, but could be next year - it doesn't really matter.
Yes it is all about helping Askers - which coincidently is measured in terms of points. So I do not mind at all watching them at all, and I do like to watch a couple of "friends" rise up through the ranks.
It actually isn't the points as much as "what next" at my rate getting to the next level is going to take a few years :)
So, my little game is the next set of 10 working towards top 100. Was figuring by the end of year, but could be next year - it doesn't really matter.
Yes it is all about helping Askers - which coincidently is measured in terms of points. So I do not mind at all watching them at all, and I do like to watch a couple of "friends" rise up through the ranks.
> Have you used the Share It feature?
No. I know nothing about that.
/gustav
No. I know nothing about that.
/gustav
<<No. I know nothing about that.>>
If you click the "Share it link" on a question, you can provide a link to the page in a logged in view in a number of ways (see attached screenshot).
JimD.
Window-Capture.jpg
If you click the "Share it link" on a question, you can provide a link to the page in a logged in view in a number of ways (see attached screenshot).
JimD.
Window-Capture.jpg
>> It actually isn't the points as much as "what next"
I have an Excel SS that is hooked to my Zone Rank pages. Then to the right are the columns that list off the certs I have and the "targets". Anything over a 100K is gray, less than 100K is black, <25k is blue, and <10K is green.
I use that to decide what I'm going to target next. ;-)
cert-close.jpg
I have an Excel SS that is hooked to my Zone Rank pages. Then to the right are the columns that list off the certs I have and the "targets". Anything over a 100K is gray, less than 100K is black, <25k is blue, and <10K is green.
I use that to decide what I'm going to target next. ;-)
cert-close.jpg
<<I have an Excel SS that is hooked to my Zone Rank pages. Then to the right are the columns that list off the certs I have and the "targets". Anything over a 100K is gray, less than 100K is black, <25k is blue, and <10K is green.
I use that to decide what I'm going to target next. ;-)>>
All I can say is yikes! No wonder I'm gravitating towards the bottom of the list...
JimD.
I use that to decide what I'm going to target next. ;-)>>
All I can say is yikes! No wonder I'm gravitating towards the bottom of the list...
JimD.
>> All I can say is yikes! No wonder I'm gravitating towards the bottom of the list...
Jim D,
You are still way ahead of me in the Access ranks and in Overall ranks in general.
But that's why on some periods you see me just doing my best to rack up all the points in a given zone.
My hunt for the Access genius had me Cranking out roughly 32K a day ;-)
https://www.experts-exchange.com/questions/24507553/I'm-so-fracking-close.html
(25958)/ datediff("d","06/19/09","0
Jim D,
You are still way ahead of me in the Access ranks and in Overall ranks in general.
But that's why on some periods you see me just doing my best to rack up all the points in a given zone.
My hunt for the Access genius had me Cranking out roughly 32K a day ;-)
https://www.experts-exchange.com/questions/24507553/I'm-so-fracking-close.html
(25958)/ datediff("d","06/19/09","0
Don't Shoot The Messenger :-)
mx
mx
Gang,
Engaging in a little shameless self-promotion, please have a look here:
https://www.experts-exchange.com/articles/Programming/Languages/Visual_Basic/Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html
Don't forget to vote on whether you found the article useful (linked at the top of the article).
:)
Cheers,
Patrick
Engaging in a little shameless self-promotion, please have a look here:
https://www.experts-exchange.com/articles/Programming/Languages/Visual_Basic/Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html
Don't forget to vote on whether you found the article useful (linked at the top of the article).
:)
Cheers,
Patrick
"This feature will save Cleanup Volunteers countless hours. "
A most EXCELLENT idea!!!
mx
A most EXCELLENT idea!!!
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
'Unabandoning' this so that I can post a bug report :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All,
webtubbs, the developer of QuickEE has taken the time to put together a very nice outline of the Custom Query part of the Advanced Search feature:
http://www.ee-stuff.com/se
-Miriam
webtubbs, the developer of QuickEE has taken the time to put together a very nice outline of the Custom Query part of the Advanced Search feature:
http://www.ee-stuff.com/se
-Miriam
https://www.experts-exchange.com/questions/24923949/Help-needed-with-query.html
Can't seem to get through to this guy on the difference between importing data from a CSV, and setting up a
linked table from a CSV.
:)
Can't seem to get through to this guy on the difference between importing data from a CSV, and setting up a
linked table from a CSV.
:)
ASKER
One of the regulars here posted a nice thank you note to people who have helped her along in Access, Word and Excel:
http:Q_25017727.html
http:Q_25017727.html
Hey all, just tripped over this comment from Peter Miller:
http://groups.google.com/group/comp.databases.ms-access/msg/e7ffde5a85d91367
on the use of /decompile
All I can say is that I feel vindicated in regards to my views on the regular use of /decompile. Again, there are times when you want to use it and over all it's pretty safe, but it can screw up a database. As always,your mileage may vary.
And I do trust Peter to make accurate comments. He is very passionate about Access and has been involved with it for a considerable time. In fact he was the first to point out to Microsoft (and crack) the large hole that existed in work group security. It was his technique that started the cottage industry in Access workgroup recovery tools.
JimD.
http://groups.google.com/group/comp.databases.ms-access/msg/e7ffde5a85d91367
on the use of /decompile
All I can say is that I feel vindicated in regards to my views on the regular use of /decompile. Again, there are times when you want to use it and over all it's pretty safe, but it can screw up a database. As always,your mileage may vary.
And I do trust Peter to make accurate comments. He is very passionate about Access and has been involved with it for a considerable time. In fact he was the first to point out to Microsoft (and crack) the large hole that existed in work group security. It was his technique that started the cottage industry in Access workgroup recovery tools.
JimD.
"As always,your mileage may vary."
'Green (aka High Mileage) here:-)
I can think of exactly one time that I've had DeCompile corrupt an mdb ... out of the 1000's of times I (and my colleagues) have used it. And of course, I had a *backup* that I created *before* I ran the procedure. And after some fooling around, I was able still able to decompile and fix the issue.
As in many things, sometimes you have to weigh the benefits vs the risks ... and this is certainly one of those cases. Compared to the 1000's of mdbs that decompile has saved (benefit) vs the number of reported results of corruption (risk) that I am aware of ... I would say it's a pretty good bet.
In fact, Peter seems to be referring to a pretty specific case when the decompile might cause a non-function mdb ... and really doesn't seem to be all that 'down' on it's use ... really more of a warning as to what 'could' happen.
mx
'Green (aka High Mileage) here:-)
I can think of exactly one time that I've had DeCompile corrupt an mdb ... out of the 1000's of times I (and my colleagues) have used it. And of course, I had a *backup* that I created *before* I ran the procedure. And after some fooling around, I was able still able to decompile and fix the issue.
As in many things, sometimes you have to weigh the benefits vs the risks ... and this is certainly one of those cases. Compared to the 1000's of mdbs that decompile has saved (benefit) vs the number of reported results of corruption (risk) that I am aware of ... I would say it's a pretty good bet.
In fact, Peter seems to be referring to a pretty specific case when the decompile might cause a non-function mdb ... and really doesn't seem to be all that 'down' on it's use ... really more of a warning as to what 'could' happen.
mx
mx,
<<In fact, Peter seems to be referring to a pretty specific case when the decompile might cause a non-function mdb ... and really doesn't seem to be all that 'down' on it's use ... really more of a warning as to what 'could' happen. >>
Yes, but the point is that it remains undocumented and untested. Personally the fact that Microsoft continues to leave the switch in I think speaks volumes; that it is handy and that it does work 99.9 percent of the time (after all, everything has bugs). But if it really is that beneficial, I'd wish they'd get off the fence and document the thing. I suppose though this is as close as they want to come to admitting they have a problem with Access/VBA.
However given that it remains the way it is, that this is clear evidence that it does have issues, and that importing into a clean DB is a simple task compared to what it was in the past, then I think I will continue to do as I have always done and avoid it's use.
JimD.
<<In fact, Peter seems to be referring to a pretty specific case when the decompile might cause a non-function mdb ... and really doesn't seem to be all that 'down' on it's use ... really more of a warning as to what 'could' happen. >>
Yes, but the point is that it remains undocumented and untested. Personally the fact that Microsoft continues to leave the switch in I think speaks volumes; that it is handy and that it does work 99.9 percent of the time (after all, everything has bugs). But if it really is that beneficial, I'd wish they'd get off the fence and document the thing. I suppose though this is as close as they want to come to admitting they have a problem with Access/VBA.
However given that it remains the way it is, that this is clear evidence that it does have issues, and that importing into a clean DB is a simple task compared to what it was in the past, then I think I will continue to do as I have always done and avoid it's use.
JimD.
"I'd wish they'd get off the fence and document the thing. I suppose though this is as close as they want to come to admitting they have a problem with Access/VBA."
Well, I couldn't agree more there. But then that ... would be admitting that Access can become corrupted - oops! (Catch 22?)
"remains undocumented and untested."
Well, I wouldn't say it hasn't been 'tested'. I fact, it's been 'tested' by a huge part of the Access community (Yes, I know what you mean) :-)
mx
Well, I couldn't agree more there. But then that ... would be admitting that Access can become corrupted - oops! (Catch 22?)
"remains undocumented and untested."
Well, I wouldn't say it hasn't been 'tested'. I fact, it's been 'tested' by a huge part of the Access community (Yes, I know what you mean) :-)
mx
To each his own, I say. I use /decompile only when I need to do so, and not as part of any regular maintenance. Like Jim, I prefer to just move everything to a new, blank database.
I would definitely say it hasn't been tested, since the people who own the source code (and therefore would be able to determine if the process results in an as-expected result) have not vetted it against that source code. The fact that it appears to "work" is anectdotal evidence (at best) that it "works", but doesn't determine whether it "works" according to the specs.
I would definitely say it hasn't been tested, since the people who own the source code (and therefore would be able to determine if the process results in an as-expected result) have not vetted it against that source code. The fact that it appears to "work" is anectdotal evidence (at best) that it "works", but doesn't determine whether it "works" according to the specs.
Well ... I'm not sure of the definition of 'tested' here ... but when I've seen DeCompile fix 100's of otherwise probably not repairable mdb's ... I would call that 'tested'.
And I never mentioned anything about 'regular maintenance'.
mx
And I never mentioned anything about 'regular maintenance'.
mx
If you'll re-read what I wrote, I never said you used it as part of regular maintenance. I said I did.
Anecdotal results provided as complying to some percieved "standard" (i.e. "well, it works") is not what I call testing, but again - to each his own. I'll continue to use decompile since it does seem to work when other methods fail. But it's a last ditch effort in my book, and if I have to decompile a database, I sure as he|| wouldn't trust that database any longer - I'd import to a new container immediately. As JimD said, the fact the MS has not yet vetted it speaks volumes regarding the utility.
Anecdotal results provided as complying to some percieved "standard" (i.e. "well, it works") is not what I call testing, but again - to each his own. I'll continue to use decompile since it does seem to work when other methods fail. But it's a last ditch effort in my book, and if I have to decompile a database, I sure as he|| wouldn't trust that database any longer - I'd import to a new container immediately. As JimD said, the fact the MS has not yet vetted it speaks volumes regarding the utility.
Gang,
I am having trouble getting through to the Asker in https://www.experts-exchange.com/questions/25089306/How-do-I-refer-to-tables-in-VBA-and-correct-an-error-caused-by-a-null-value.html
The heavy lifting is done, but I need some help in articulating to the Asker how to implement the solution. S/he
seems to not understand how to construct the function call in a query.
Thanks,
Patrick
I am having trouble getting through to the Asker in https://www.experts-exchange.com/questions/25089306/How-do-I-refer-to-tables-in-VBA-and-correct-an-error-caused-by-a-null-value.html
The heavy lifting is done, but I need some help in articulating to the Asker how to implement the solution. S/he
seems to not understand how to construct the function call in a query.
Thanks,
Patrick
Hi All,
Just an FYI, but I've noticed an up tick in the number of questions/problems related to Windows Server 2008 64 bit. Check this thread out:
https://www.experts-exchange.com/questions/25091616/MS-Access-runs-slow-as-a-2008-Terminal-Server-RemoteApp.html
Author ended up re-installing in 32 bit and problem went away. Microsoft didn't have any answers.
JimD.
Just an FYI, but I've noticed an up tick in the number of questions/problems related to Windows Server 2008 64 bit. Check this thread out:
https://www.experts-exchange.com/questions/25091616/MS-Access-runs-slow-as-a-2008-Terminal-Server-RemoteApp.html
Author ended up re-installing in 32 bit and problem went away. Microsoft didn't have any answers.
JimD.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<I must be a slow learner. I only now just discovered this thread. Interesting!>>
This drive mes nuts and is probably my biggest complaint with EE (and a very long standing one - 2004 to date); no effective means of contacting experts in a zone.
Some relief for that though is finally coming with the new ability to manage the landing pages and as a PE, actually being able to modify it to point to content that is interesting and informative. Of course, that assumes that everyone will read the landing page <g>.
JimD.
This drive mes nuts and is probably my biggest complaint with EE (and a very long standing one - 2004 to date); no effective means of contacting experts in a zone.
Some relief for that though is finally coming with the new ability to manage the landing pages and as a PE, actually being able to modify it to point to content that is interesting and informative. Of course, that assumes that everyone will read the landing page <g>.
JimD.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Big writeup in Wikipedia.
Jim: I only ever get into EE by opening a post generated Email and clicking on the 'View expert comment' phrase. I never see a landing page per se - I think??
Jim: I only ever get into EE by opening a post generated Email and clicking on the 'View expert comment' phrase. I never see a landing page per se - I think??
<<landing page? I must be slow like GRayL, clue me in.>>
The page you see when you hit the top of a zone (see attached).
<<im: I only ever get into EE by opening a post generated Email and clicking on the 'View expert comment' phrase. I never see a landing page per se - I think??>>
Probably not then. Like I ssaid,only problem will be getting people to see it <g>
JimD.
Region-Capture.JPG
The page you see when you hit the top of a zone (see attached).
<<im: I only ever get into EE by opening a post generated Email and clicking on the 'View expert comment' phrase. I never see a landing page per se - I think??>>
Probably not then. Like I ssaid,only problem will be getting people to see it <g>
JimD.
Region-Capture.JPG
This is my landing zone link (such as it is):
https://www.experts-exchange.com/Microsoft/Development/MS_Access/viewOpenZoneQuestions.jsp?taid=39
This takes me directly to a full page of the latest questions and I use the Premium Skin. I mainly use this page to review Q's when I first start in the am ... instead of plowing through my Outlook inbox for EE.
This is the actual Access landing page:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/
But if you click down aways on 'View More Questions Awaiting Answers' ... you get to the link above - which is a desktop shortcut.
Of course, I get constant email notifys into Outlook wherein like gRay ... I click the Q to access the question. But I do review the link page above often during the day also.
mx
https://www.experts-exchange.com/Microsoft/Development/MS_Access/viewOpenZoneQuestions.jsp?taid=39
This takes me directly to a full page of the latest questions and I use the Premium Skin. I mainly use this page to review Q's when I first start in the am ... instead of plowing through my Outlook inbox for EE.
This is the actual Access landing page:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/
But if you click down aways on 'View More Questions Awaiting Answers' ... you get to the link above - which is a desktop shortcut.
Of course, I get constant email notifys into Outlook wherein like gRay ... I click the Q to access the question. But I do review the link page above often during the day also.
mx
In the picture above search button is a [+/-] sign that collapses the landing zone. It is per browser per computer per user. If you hit the minus, you won't get the landing pages in any zone until you change it back.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, everyone!
mx