Cannot see attachment datatype in creating table

[dododo]

Hi all,



I am creating table and i want to place attachment file with using attachment datatype but I can't see attachment datatype when I create table.

Please help me. Why?

Thanks and Regards,

Dodo

[June7]

I believe that field type introduced with Access 2007.

[dododo]

Hi,

I got stuck with wirting sql in vba access.

Here is my code:

Dim sqlstr As String
sqlstr = "select id from tblstaff "
DoCmd.RunSQL

Pls correct me. Thanks

[dododo]

Here is my code:

Dim sqlstr As String
sqlstr = "select id from tblstaff "
DoCmd.RunSQL sqlstr

still not correct. got error

[June7]

RunSQL (or CurrentDb.Execute) only works with SQL actions (INSERT, UPDATE, DELETE).

SELECT sql is used to open a recordset object in VBA.

[dododo]

Hi, thanks alot.

But Can you give me example please?

[June7]

Why do you need to open a recordset?

What do you really need to accomplish?

Review:

http://support.microsoft.com/kb/148361

http://allenbrowne.com/ser-29.html