Create Access Table with auto number VBA

To create table in access vba

Sub CreateTable()

Dim MySQL As String
autonumber = counter
MySQL = "CREATE TABLE Table2 (ID counter, Name text (50))"
DoCmd.SetWarnings False
DoCmd.RunSQL MySQL
DoCmd.SetWarnings True

End Sub

Link Access Table with MapInfo

In this example, a point map is created from access table. It does require MapInfo.

To download sample database, click on following link.

https://docs.google.com/leaf?id=0B639uEjPRnEzMmI3MmI5YjAtZmU2NS00MDVmLThmNzUtZTI4OTE2YTJiZWU5&hl=en&authkey=CLfHwNUE

Splash Screen

This Sample database displays splash screen at start up. To download, click on the following link.

https://docs.google.com/leaf?id=0B639uEjPRnEzMjBmYzkxYWYtMzM3Ny00ZDM0LWI5ODctZWZlN2ZlODI0N2Zi&hl=en

Once downloaded, unzip to run the application.