AccessBlog.net
News, links, downloads, tips and tricks on Microsoft Access and related
About Me | Search |
Friday, April 29, 2005
Can be downloaded here. Now you can select which modules to translate, and Translator collect all string arguments from MsgBox() functions, found in these modules. Be careful with this, always make a backup before running this function.
Friday, April 22, 2005
XML for ASP.NET Developers
This site has a lot of samples manipulating XML in .NET, also web services staff.
Thursday, April 21, 2005
Internet connection sharing on Windows 2003 server SP1
I did not find exact way how to solve this problem with ICS, but recently i looked at a Microsoft traning lab on Windows firewall in SP1, and looks like answer is there - you have to enable this service (or disable a prohibite of using it, don't remember exactly) in Group Polices Editor.
Copyright protection in Access
Jeff Conrad posted a collection of links for copyright protection in Access in Microsoft public newsgroups, here bit revised list:
Here are some links/samples that should help with this topic
http://members.shaw.ca/glenk/access2000.html
Look for the downloads:
"Updated have Database Expire After 30 Days Of Use"
"Updated have Database Expire After 30 Days Of First Being Opened."
MVP Tony Toews' thoughts on demos/expiration coding:
http://www.granite.ab.ca/access/demo.htm
Peter De Baets has a product called KeyedAccess that will do this I believe:
http://www.peterssoftware.com/ka.htm
Paul Overway has something similar here:
http://www.logico-solutions.com/
--Go to Add-ins/Extras area and look for "Logico Solutions MDB Lock"
Also try here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName=
And for copyright protection these may be of help as well:
Google Directory
http://www.crypkey.com/products/copyprot/copyprot.html
http://www.copyprotection.com/
Also I would add a SageKey Security Package
If you know some good staff to add to this list - please let me know.
Here are some links/samples that should help with this topic
http://members.shaw.ca/glenk/access2000.html
Look for the downloads:
"Updated have Database Expire After 30 Days Of Use"
"Updated have Database Expire After 30 Days Of First Being Opened."
MVP Tony Toews' thoughts on demos/expiration coding:
http://www.granite.ab.ca/access/demo.htm
Peter De Baets has a product called KeyedAccess that will do this I believe:
http://www.peterssoftware.com/ka.htm
Paul Overway has something similar here:
http://www.logico-solutions.com/
--Go to Add-ins/Extras area and look for "Logico Solutions MDB Lock"
Also try here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName=
And for copyright protection these may be of help as well:
Google Directory
http://www.crypkey.com/products/copyprot/copyprot.html
http://www.copyprotection.com/
Also I would add a SageKey Security Package
If you know some good staff to add to this list - please let me know.
Query from Access
New Com Add-in was recently released - Query from Access. You just select database, select query in it and query result in your active spreadsheet. Easy!
Tuesday, April 19, 2005
Microsoft car computer
Sounds cool! Microsoft’s new TBox car computer is almost ready to hit the road! And it will be fitted in all 23 Fiat, Lancia and Alfa Romeo models! Wow! Some new bugs in Alfa Romeo Microsoft? No problem, we get used :-)
Monday, April 18, 2005
Encryption functions in SQL Server 2000
SQL Server MVP Alexander Gladchenko shows an example using these functions: pwdencrypt and pwdcompare. We had to write xp_ for same few years ago...
Truth
One must never regret telling the truth. The truth is enlightening and help us become courageous.
Aldo Moro
Wednesday, April 13, 2005
More on problems with Windows 2003 Server SP1
Vamsoft have published an article - Windows 2003 SP1 Issues, which helps to resolve issue with ORF software.
Tuesday, April 12, 2005
My problems with Windows 2003 Server SP1
Well, this was the first time i had to uninstall SP. I was bit busy, but anyway - i think it is something wrong with it. Better to say - something wrong with deployment scenario. What i got after installation of SP1:
- some new error messages in Events log; ok can live with it
- internet connection sharing (ICS) stop working. And it settings are gone in Advanced tab. I think this is something with new security policies, but found nothing in KB and at google. Also i found that i was not the only one who got this problem.
- Vamsoft ORF spam filter stops working. No error messages, nothing, but it does not work. Just all spam now arrives to my mialbox. This is really critical. Have to check Vamsoft website.
How to import password-protected excel spreadsheet
If you would try to import password-protected Excel file into Access, using DoCmd.TransferSpreadsheet - method will fail. You can use following workaround - open protected excel file in Excel using automation, then run DoCmd.TransferSpreadsheet and then close file. Here a sample procedure to perform such task:
Public Sub ImportProtected(strFile As String, _
strPassword As String)
Dim oExcel As Object, oWb As Object
Set oExcel = CreateObject("Excel.Application")
Set oWb = oExcel.Workbooks.Open(FileName:=strFile, _
Password:=strPassword)
DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "Import", strFile, -1
oWb.Close SaveChanges:=False
oExcel.Quit
Set oExcel = Nothing
End Sub
To run this procudere:
ImportProtected "C:\MyFile.xls", "123"
Public Sub ImportProtected(strFile As String, _
strPassword As String)
Dim oExcel As Object, oWb As Object
Set oExcel = CreateObject("Excel.Application")
Set oWb = oExcel.Workbooks.Open(FileName:=strFile, _
Password:=strPassword)
DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "Import", strFile, -1
oWb.Close SaveChanges:=False
oExcel.Quit
Set oExcel = Nothing
End Sub
To run this procudere:
ImportProtected "C:\MyFile.xls", "123"
Wednesday, April 06, 2005
Localized Access version problem
I always tell my colleagues – use only English Access (and other Microsoft tools) version to develop applications, but sometimes this occur...
I asked my colleague to make a small prototype – one form with Janus GridEx. It works great at me, and I have sent to my client together with instructions how to register new ActiveX control. He reported that nothing works and he got a lot of error messages like “UnboundReadData generate an error when communicating with the OLE-server or the Active X-control”. First I thought that control is not registered, or some other components missing – still does not work. Ok, I have installed a Virtual PC with same environment like client has (Windows XP and Access 2000) – and got same error! Hmm, how come? Code does not work even for a simple form inserted on a main form as a subform. Ok, I quickly recreated both forms in Access 2000 – everything start working. But why it did not? I asked my colleague about Access version he used and he told that it was Access 2003 Russian! This could be a problem! I started my Virtual PC again, Control panel-Regional and Language options-Advanced and set “Select a language to match the language version of the non-Unicode program you want to use” to Russian. After restart – it works!
I saved a form to text using hidden SaveAsText method, looked at the text and yes - detail section was named there as “область данных”! This was a reason.
So rule is simple – use only English character in object names and code – variables, functions, etc. Then it will work on any language settings.
I asked my colleague to make a small prototype – one form with Janus GridEx. It works great at me, and I have sent to my client together with instructions how to register new ActiveX control. He reported that nothing works and he got a lot of error messages like “UnboundReadData generate an error when communicating with the OLE-server or the Active X-control”. First I thought that control is not registered, or some other components missing – still does not work. Ok, I have installed a Virtual PC with same environment like client has (Windows XP and Access 2000) – and got same error! Hmm, how come? Code does not work even for a simple form inserted on a main form as a subform. Ok, I quickly recreated both forms in Access 2000 – everything start working. But why it did not? I asked my colleague about Access version he used and he told that it was Access 2003 Russian! This could be a problem! I started my Virtual PC again, Control panel-Regional and Language options-Advanced and set “Select a language to match the language version of the non-Unicode program you want to use” to Russian. After restart – it works!
I saved a form to text using hidden SaveAsText method, looked at the text and yes - detail section was named there as “область данных”! This was a reason.
So rule is simple – use only English character in object names and code – variables, functions, etc. Then it will work on any language settings.