How this access file connect to another database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
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
 
Back
Top