Search results

Hi Listers, I have to move MS DB from one machine to another but I have to modify ODBC river also. I know the DB user dsn file my question is: How I know which dsn file is used by the dabase? Can I edit the dsn file in text editor and modify(change driver)? Thanks in advance for your help...

Great! Many thanks David. Your inputs are very heplful for me and I appreciate that. Have a nice day, Kader

OK! Thanks David. Now I have another question. I have two access databases. One has the front end applications (forms, reports, etc...) and another with extension md.mdb, I guess where data resides (sorry I inebriated this MS applications, I neophyte). The problem, I can't open the md.mdb file...

Hi Galaxiom, Thanks for your reply. My question what does linked access table? If the table is linked to the external database (Oracle, SQL Server) it appears as OBDC linked table, that's right? The acces linked table does mean the table is linked to another access table? Kader

Hi Gurus, I understand the ODBC linked table (that's the table is linked to the external database table), but what does mean access linked table and how can I see (explore!) the definition of the table that is linked to? Thanks in advance for your reply, Kader

Hi boblarson, Thanks a lot boblarson! I got it! Thanks again for your prompt reply. Have a nice a day, Kader

Hi Listers, I’m new to MS Access and I’m using MS Access 97. On the query tab I see my query and I don’t know how to see the query content (the sql script). I have only menu with options: Open which see me the result of the query and Design which displays the tables used to build the query...

Hi pbaldy, F11, that's what I missed! Thanks you. Now I can what WayneRyan was taking about. Many thanks for you guys. Kader

Hi WayneRyan, Thanks a lot for your prompt reply. My problem I don't know how I access Tables, Queries, Forms, Reports, Macros and Modules! When I open the mdb file I can see only the form view or form design the properties menus no other options or tabs. Have a nice week end, Kader

Hi Listers, I'm very new to MS Access and VB. I inherited Access application and try to find where the queries reside and other objects. I find the following code on the event commands: .... Dim stDocName As String stDocName = "Account Financial Snapshot" DoCmd.Maximize...