Access Idiot seeks help 1

[RonRepp]

Hi all:

I'm used to doing this stuff in SQL Server, and Access is driving me batty.

I'm simply trying to create a table, but it keeps telling me that the syntax is wrong.

Would someone please show me where?

Dim dbs As Database
    Dim s As String
    s = "CREATE TABLE Oct08 ([ID] AutoNumber [Long Integer], " & _
        "Keywords Text, CurrentMonth Number [Double], " & _
        "[Annual Monthly Search] Number [Double], [Global Return] Number [Double], " & _
        "[CurrentMonth Return] Number [Double], [Month 1] Text, [Month 2] Text, " & _
        "[Month 3] Text, [Month 4] Text, [Month 5] Text, " & _
        "[Month 6] Text, [Month 7] Text, [Month 8] Text, " & _
        "[Month 9] Text, [Month 10] Text, [Month 11] Text, [Month 12] Text); "
    Set dbs = CurrentDb
    dbs.Execute s

Thanks,

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[dBjason]

place set dbs = currentdb as your first line of code, under you declare (dim) statements).

if your database is sqlserver, you'll need a connection string. post again if you have problems!

-jason

 

[RonRepp]

Jason:

I do have set dbs=currentDb

It's the 2nd to last line.

The error I'm getting says that there's a problem with the SQL syntax.

Thanks,


Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[RonRepp]

The problem is in the AutoNumber.

Any suggestions?

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[PHV]

Replace this:
([ID] AutoNumber [Long Integer],
with this:
([ID] COUNTER(1,1),

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RonRepp]

Thanks.

I knew it was something easy...just not used to Access. Haven't used it in 8 years.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net