Re: How does this file know where to connect

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the answer again. Now that I see the Link Table manager, and yes,
I see all the table connections are there.

But when I try to change it, I ask me to browse to other access file. Is
there any way I can make it link to a database on SQL server?

Thank you very much for the help.

"Robin" wrote:

There are a number of Access startup options, such as removing toolbars,
that may have been set by the author of your database. You might find
opening the file with the shift key held down does the trick, since this
bypasses those startup options.

Robin

"Charlie Brown" <CharlieBrown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4EAF8D2-F3ED-4199-A6DF-BEC0F13C4096@xxxxxxxxxxxxxxxx
Thanks for the answer. But the problem is, this file A, when I open it,
the
menu bar is very limited. And it only shows the first form. This form,
when
you click the buttons, will link to other forms that add/edit data.

There is no "Tools", and from "File", only has "Close". And I try to
customize toolbar and it doesn't show more.

I try to open the file as "open exclusive" and it doesn't change anything.


Only thing I can do is to right click the form and change it to design
form
view and work from there. That's how I can view some codes.



"Robin" wrote:

Open file A and look in the Tools menu under Database Utilities. You
should
find "Linked Table Manager". This will show you the location of tables
in
File B, and will allow you to change the location of those linked tables.

"Linked Table Manager" is an optional component at the time of Access
installation - if it's not listed in your tools menu you can add this
from
the Access or Microsoft Office installation CD.

Robin

"Charlie Brown" <CharlieBrown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5FB873E1-558E-48BB-850D-54BB60484B2A@xxxxxxxxxxxxxxxx
I have 2 Access mdb files. (File A and B)

One contains all forms that edit the data in File B. It contains forms
only.(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?






.

Relevant Pages

  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 Tools
    ... I have warned the manager again via email of the risk of doing this and he ... things yet he requested the password from me to access the server and poke ... around the database and doing all sorts. ... You'll need to enable the ports and protocols using the SQL Server ...
    (microsoft.public.sqlserver.connect)
  • RE: unable to create new content database in WSS 3.0
    ... I tried creating a content database on a different SQL server (also sql ... You can send feedback directly to my manager at: ... Exception Type: System.ArgumentNullException Exception Message: Value ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Backup Question
    ... Make sure the SQL Server Agent service is running. ... Database Maintenance ... > You can create a Maintenance Plan to do this. ... In Enterprise Manager goto ...
    (microsoft.public.sqlserver.setup)
  • Re: How does this file know where to connect
    ... Try holding the Shift key down when you open the database. ... If you right click on the menu bar, ... connect to the database in SQL server instead to File B. ... I try to view all the codes in Visual Basic view, ...
    (microsoft.public.access.modulesdaovba)