How this access file connect to another database? Charlie Brown 14.07.2006 04:38:55 I have 2 Access mdb files. (File A and B) One contains all forms that edit the data in File B. (File A) Another contains the actual data and tables. (File B) However, I didn't created these files. Now we are trying to move all the data and tables into the SQL server. So I need to update File A to make it connect to the database in SQL server instead to File B. However, I can't found out where in this file it specify how it connect to database. I try to view all the codes in Visual Basic view, all the Access Class Objects and even the Modules. But no where in those codes secify which database it connects. So where else can this file A know where to connect to?

Re: How this access file connect to another database? Nikos Yannacopoulos <nyannacoREMOVETHISBIT[ at ]in.gr> 14.07.2006 07:45:04 Charlie, If there is no connection to the back end (what you refer to as file B) done through code, then the tables must be simply linked in the front end (what you refer to as file A, in which you should see them in the database window as normal Access tables with an arrow on the left side). If this is indeed the case, then it is as simple as using the upsizing wizard (Tools > Database Utilities > Upsizing Wizard) from within your front end; this will migrate the tables to the SQL server and maintain the links in the FE. HTH, Nikos

Re: How this access file connect to another database? Charlie Brown 14.07.2006 20:27:02 Thank you very much for answering the question. But when file A is opened, it only shows a form, in form view. Only thing I can do is to change it to design view by right clicking the form. It looks like the creator of this file limit the functions a user can access. Even the functions in menu bar is limited. So, how do I edit the "front end"? I even tried to "open exclusive" and it doesn't make a difference. "Nikos Yannacopoulos" wrote: [Quoted Text] > Charlie, > > If there is no connection to the back end (what you refer to as file B) > done through code, then the tables must be simply linked in the front > end (what you refer to as file A, in which you should see them in the > database window as normal Access tables with an arrow on the left side). > If this is indeed the case, then it is as simple as using the upsizing > wizard (Tools > Database Utilities > Upsizing Wizard) from within your > front end; this will migrate the tables to the SQL server and maintain > the links in the FE. > > HTH, > Nikos >

Re: How this access file connect to another database? Nikos Yannacopoulos <nyannacoREMOVETHIS[ at ]gmail.com> 17.07.2006 06:19:54 Charlie, How much you can do depends on what format your front end is in. If it is an .mde then what you can do with it is limited... you must be lucky, though, in your original post you say: "I try to view all the codes in Visual Basic view, all the Access Class Objects and even the Modules. But no where in those codes secify which database it connects." which implies that you can actually see the code, so you have the .mdb file, which you can do anything on. The fact that you only get a form and a limited menu is most likely the result of some startup settings (found under Tools > Startup), which can be by-passed by keeping the Shift key pressed while you open the file; this prevents all startup settings from taking effect, as well as the autoexec macro (if one exists) or any code from running, and you get full access to the front end. HTH, Nikos