all combo box change to text box

[mayapple]

hi guys,

I am new with sql server to be BE of access.

previously I use access only with all of tables and forms, now I want use access to be only FE, and sql server to be my BE.

I use The free Microsoft SQL Server Migration Assistant (SSMA) to migrate all of my data from local access to sql server.

and after migration, I use ODBC to connect with sql server. all of data can be linked to my local access, but in the table columns where it should be combo box, change to text box all. so I can't choose from the combo box any more.

is there anyone knows how to solve this problem?

 

[Mr. B]

You should never be attempting to interact directly with the tables. You need to build forms for the user interface and you can design the combo boxes into the form.

 

[mayapple]

thank you for your reply.

yes I know that, but when in form, when I "add existing fields", previously it's combo box directly, but now I need to change it from text box to combo box, and add row source by myself. it looks like a little bit strange, isn't it?

i use godaddy.com for sql server, and in their background system I can't see the relationship between tables, that's also strange.

You should never be attempting to interact directly with the tables. You need to build forms for the user interface and you can design the combo boxes into the form.