upgrade VB6 to VB.Net w/Access

[cmazsmith]

I've upgraded a small utility program. It connects to an access database. This database has field names with spaces. This worked fine in VB6 using [] as in myDB![with spaces] but .Net barks at it and the error is Identifier Expected.

I've tried double quotes...curly brackets...no brackets...nothing worked that I thought of.

Any help would be appreciated...
thanks!

[HanneSThEGreaT]

I'm just going to add a few comments.

• using spaces in FieldNames aren't really advised (IMO) - I would much rather recommend using the LNC naming convention
• Using spaces in names, get confusing, especially when Inserting new records etc.

[Hack]

I've upgraded a small utility program. It connects to an access database. This database has field names with spaces. This worked fine in VB6 using [] as in myDB![with spaces] but .Net barks at it and the error is Identifier Expected.

I've tried double quotes...curly brackets...no brackets...nothing worked that I thought of.

Any help would be appreciated...
thanks!

The easiest and least painful solution is to rename your fields and put underscores where there are now spaces.

I just tested this on an Access database and you will not lose any data.