Search results

I need to do automate it using vba because I am creating a frontend for the users. If going to use the DSN-less, what will be the proper code to link from all the tables from the 5 databases. Can you give me example please.

I dont know how to use VB6 yet but I'm learning VB6. In Access, you create your query objects by referring to the table objects. In VB6, how do I create the SQL statement when I dont have the table objects? How do I create a code to create SQL statement? Can someone give me idea or code...

I have problem connecting my Access to SQL. I have this situation wherein I am creating more than one database in a server, let us say 5 databases. How can I make a code that will use and link those tables from those 5 database into my FrontEnd?

K. I will make it now.

wow.....you have some good discussions here. People I have also this problem connecting Access to SQL server. I am creating more than one database in a server, let us say 5 databases. How can I make a code that will use and link those tables from those 5 database into my FrontEnd?

Yes but I would still like to know. Because I think if the data are stored in these "files" then I can moved or copy this file from one computer to another under a server so that I can work with it on the other computer. Am I right?

virtual tables in files? what are these "files"? So the data are in these "files" ?

Hello good day! Newbie here. I want to learn how to use MySQL but first I have basic questions: What is the database of mysql ? and where are the records saved? Is it the same with access that the records are saved in the tables where the tables are in the database file? If not, can you tell...