AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, October 19, 2011

Microsoft Access and SQL Azure

Great resource for developers, have interest in SQL Azure, by

Patrick Wood, Access MVP:

Microsoft Access and SQL Azure Information Center for Developers

And check out other useful stuff in Free Downloads and Free Code

Labels:

Wednesday, October 12, 2011

How to remove VBA project password

Originally it was posted for  Excel VBA, but apparently works for Access.

  • Make backup.
  • Open the file with a hexadecimal editor, find the string "DPB" and change it to "DPx".
  • Then you open the file in Excel, switch to the VBA project and change the password (don't remove it, just change it). Save the file, reopen it, go to VBA project (using the password you've just created) and remove the password.

Labels: ,

Saturday, October 01, 2011

How to link FoxPro tables

In Access 97 FoxPro ISAM was included in setup, and linking FoxPro table was as easy as Access or DBF table. It was even a nice fox icon to linked FoxPro table:

clip_image001

Then it was deprecated in Access 2002 (or 2000?), and now you can only connect using ODBC.

First you need to install Visual FoxPro ODBC Driver. Then try to create new DSN to some FoxPro table using ODBC Data Source Administrator. If it works – you can link FoxPro table to Access database.

Following code shows how to create linked table using VBA:

Set tdf = dbs.CreateTableDef(strTableName, 

   _ dbAttachExclusive,

   _ strFileName,

   _ "ODBC;DSN=Visual FoxPro Tables;SourceDB=" & strFolder &

   _ ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;" &

   _ "Collate=Machine;Null=Yes;Deleted=Yes;" &

   _ "TABLE=" & strFileName)

dbs.TableDefs.Append tdf dbs.TableDefs.Refresh

Labels: