I just started using Access 2003, and I can't link a SQL Server table. I
right-click on the database window; select Link Tables; and select ODBC
Databases from the Files of Type dropdown. As soon as I select ODBC
Databases from the Files of Type dropdown, the entire dialog box disappears.
No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one, and
the results are the same. So it's definitely something in my system, not the
database. I also tried it on another computer I have running Access 2003,
and it works fine. But on this computer, it won't link ODBC.
I applied the SP3 patch last night, but the results are the same.
Any ideas about what I can try, or perhaps a file I can copy from my other
PC, in which Link Tables works?
Thanks!
Neil 8 3040
Quite likely, this is your antiviruses at work. Deactivate any protection
related to Office, VBScript or ActiveScript and you should be OK. Later,
when you'll have finished etablishing your linked tables, you can reenable
this protection.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Neil" <no****@nospam. netwrote in message
news:BE******** **********@news svr29.news.prod igy.net...
>I just started using Access 2003, and I can't link a SQL Server table. I right-click on the database window; select Link Tables; and select ODBC Databases from the Files of Type dropdown. As soon as I select ODBC Databases from the Files of Type dropdown, the entire dialog box disappears. No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one,
and the results are the same. So it's definitely something in my system,
not the database. I also tried it on another computer I have running
Access 2003, and it works fine. But on this computer, it won't link ODBC.
I applied the SP3 patch last night, but the results are the same.
Any ideas about what I can try, or perhaps a file I can copy from my other
PC, in which Link Tables works?
Thanks!
Neil
The only security I have is my Norton Internet Security, which includes
Norton Antivirus. (This, by the way, is the same product I have on my other
computer, the one with no problems in this regard.) I disabled Norton
Internet Security, but the problem remained. I also checked Windows
Firewall, and it is turned off.
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:uk******** *****@TK2MSFTNG P06.phx.gbl...
Quite likely, this is your antiviruses at work. Deactivate any protection
related to Office, VBScript or ActiveScript and you should be OK. Later,
when you'll have finished etablishing your linked tables, you can reenable
this protection.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Neil" <no****@nospam. netwrote in message
news:BE******** **********@news svr29.news.prod igy.net...
>>I just started using Access 2003, and I can't link a SQL Server table. I right-click on the database window; select Link Tables; and select ODBC Databases from the Files of Type dropdown. As soon as I select ODBC Databases from the Files of Type dropdown, the entire dialog box disappears. No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one, and the results are the same. So it's definitely something in my system, not the database. I also tried it on another computer I have running Access 2003, and it works fine. But on this computer, it won't link ODBC.
I applied the SP3 patch last night, but the results are the same.
Any ideas about what I can try, or perhaps a file I can copy from my other PC, in which Link Tables works?
Thanks!
Neil
"Neil" <no****@nospam. netwrote in message
news:BE******** **********@news svr29.news.prod igy.net...
>I just started using Access 2003, and I can't link a SQL Server table. I right-click on the database window; select Link Tables; and select ODBC Databases from the Files of Type dropdown. As soon as I select ODBC Databases from the Files of Type dropdown, the entire dialog box disappears. No error message. Just disappears, and I'm back at the database window.
I have tried this with other databases, including a brand new blank one,
and the results are the same. So it's definitely something in my system,
not the database. I also tried it on another computer I have running
Access 2003, and it works fine. But on this computer, it won't link ODBC.
I applied the SP3 patch last night, but the results are the same.
Any ideas about what I can try, or perhaps a file I can copy from my other
PC, in which Link Tables works?
Hi Neil,
If this were AccessXP, I might try checking the following
(not sure about Access 2003):
Close all Access programs.
1) try to find these 3 files on hard drive:
Acwzmain.mde
Acwztool.mde
Acwzlib.mde
{probably in C:\Program Files\Microsoft Office\Office10 \ if Access XP}
Do they exist?
2) If so, then start 2 Window Searches
in one, search for Regsvr32.exe
in second, search for accwiz.dll
Drag-and-drop accwiz.dll onto Regsvr32.exe
You should get a message that reg successful.
Does it work properly now?
If not, you might try unregistering the dll,
then reregister.
Like I said before, I am unsure about Access 2003.
good luck,
gary
Hi,
Neil wrote:
I think you're confusing Norton Internet Security with Norton
Firewall. Norton Internet Security is not simply a firewall; it's an
integration of Norton Firewall, Norton Antivirus, Norton Antispam,
etc., into one module. Disabling Norton Internet Security disables
Norton Antivirus.
However, to make the point, I explicitly disabled the Antivirus
module. Results are the same. So I'm sure that's not it.
Take a look at this thread, and you can read that it's not enough to disable
NAV: http://groups.google.com/group/comp....fa0a14b03dcaf3
Regards
Jens
Well, that resolved it. Thanks so much!
Strange because:
a) didn't have this problem on my other computer with the same configuration
(is an older computer, so I must have disabled that option years ago)
b) didn't have this problem with Access 2000, even with that option turned
on.
Anyway, all is good now. Thanks again!
Neil
"Jens Schilling" <je************ ************@fi ssership.dewrot e in message
news:fr******** *****@news.t-online.com...
Hi,
Neil wrote:
>I think you're confusing Norton Internet Security with Norton Firewall. Norton Internet Security is not simply a firewall; it's an integration of Norton Firewall, Norton Antivirus, Norton Antispam, etc., into one module. Disabling Norton Internet Security disables Norton Antivirus. However, to make the point, I explicitly disabled the Antivirus module. Results are the same. So I'm sure that's not it.
Take a look at this thread, and you can read that it's not enough to
disable NAV:
http://groups.google.com/group/comp....fa0a14b03dcaf3
Regards
Jens
Hi,
Neil wrote:
b) didn't have this problem with Access 2000, even with that option
turned on.
It seems that only A03 shows this behaviour - I didn't noticed it for
another version.
Regards
Jens
It seems that only A03 shows this behaviour - I didn't noticed it for
another version.
*shaking fist at Microsoft*
On Mar 11, 10:23*am, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)wrote:
Well, the last version of Norton that I've bought was the 2003; so I might
be a little confused with all these name changes that Norton and Symantec
have brought to their list of products.
However, as far as I know, all people who have been confronted with the same
problem as you have found that the cause was their antivirus and in most
cases, it was NAV who was involved. *I think that I remember some peoples
having problems with other antiviruses but I'm not sure. I don't remember
anyone who had the same problem as you but with a cause that was rooted into
something else than an antivirus.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Neil" <nos...@nospam. netwrote in message
news:Gf******** ***********@new ssvr12.news.pro digy.net...>I think you're confusing Norton Internet Security with Norton Firewall.
Norton Internet Security is not simply a firewall; it's an integration of
Norton Firewall, Norton Antivirus, Norton Antispam, etc., into one module..
Disabling Norton Internet Security disables Norton Antivirus.
However, to make the point, I explicitly disabled the Antivirus module.
Results are the same. So I'm sure that's not it.
Thanks, though.
Neil
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in messagenews:ej* *************@T K2MSFTNGP06.phx .gbl...
If you have NAV 2006, deactivate the Office Plug-in that you will find
under the Miscellaneous tab; if you have NAV 2007, deactivate the
Scanning for Microsoft Office Documents. *More info at:
>http://support.microsoft.com/kb/329820/en-us
If you don't find the right item, simply deactivate (temporarily) the
whole anti-viruse package. The Norton Internet Security is simply a
firewall and has nothing to do with this problem (and neither the Windows
Firewall). (However, the firewall can give trouble later when accessing
the data through a linked table.)
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Neil" <nos...@nospam. netwrote in message news:9i******* ************@ne wssvr14.news.pr odigy.net... The only security I have is my Norton Internet Security, which includes Norton Antivirus. (This, by the way, is the same product I have on my other computer, the one with no problems in this regard.) I disabled Norton Internet Security, but the problem remained. I also checked Windows Firewall, and it is turned off.
>"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in messagenews:uk* ************@TK 2MSFTNGP06.phx. gbl... Quite likely, this is your antiviruses at work. *Deactivate any protection related to Office, VBScript or ActiveScript and you should be OK. *Later, when you'll have finished etablishing your linked tables, you can reenable this protection.
>>-- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: sylvain aei ca (fill the blanks, no spam please)
>>"Neil" <nos...@nospam. netwrote in message news:BE***** *************@n ewssvr29.news.p rodigy.net... I just started using Access 2003, and I can't link a SQL Server table.. I right-click on the database window; select Link Tables; and select ODBC Databases from the Files of Type dropdown. As soon as I select ODBC Databases from the Files of Type dropdown, the entire dialog box disappear s. No error message. Just disappears, and I'm back at the database window.
>>>I have tried this with other databases, including a brand new blank one, and the results are the same. So it's definitely something in my system, not the database. I also tried it on another computer I have running Access 2003, and it works fine. But on this computer, it won't link ODBC.
>>>I applied the SP3 patch last night, but the results are the same.
>>>Any ideas about what I can try, or perhaps a file I can copy from my other PC, in which Link Tables works?
>>>Thanks!
>>>Neil
For details on disabling the Norton Office Plug-in on various Norton
installs, see http://support.microsoft.com/kb/329820. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David |
last post by:
Hi,
We have an internal network of 3 users.
Myself & one other currently have individual copies of the front-end
MS Access forms and via our individual ODBC links we have used the:
File > Get External Data > Link Tables > select ODBC Databases
facility to link to our back-end MySQL Server. On both our machines
the tables appear in the window very quickly and if we hit 'Select
All', all the tables start loading really quickly into our...
|
by: Me |
last post by:
Hi all,
Each new login to the PC, all the ODBC links to the SQL Server tables
fail
with the error
"Connection failed"
SQL Server Error 10061
Connection Open
(connect())
Connection failed:
|
by: Paul |
last post by:
Hello,
I am converting an Access database on our network to a sql 2000
backend and keeping access as the front end. The access database has
evolved and been a solution to collect data but now we want to move
the tables over to sql 2000. We have successfully done that but are
now having difficulties with an ODBC connection. Initiall linking the
tables is not an issue and I am able to connect with no problem.
However after closing down...
|
by: ZRexRider |
last post by:
Hi,
I have an application that uses MS-SQL Linked tables. I have a utility
routine that drops all links and re-establishes them. It works great
when my connection string is a DSN connection but I would like to
change it to DSN-Less so users don't have to set up ODBC connections on
each workstation.
If I use the following DSN
|
by: Tim Frawley |
last post by:
I am attempting to change the ODBC Link Provider String in an Access
database linked to an Oracle server using ADOX in VB.NET.
I created some code using the example from post:
http://groups.google.com/groups?q=RefreshLinkedTablesWithADOX()&hl=en&lr=&selm=qb1ctvcdoftenojhpp34lb6fjb9ss8qd9c%404ax.com&rnum=1
My code simply replaces the DSN, UID, PWD and DBQ values in the
ADOXTable.Properties("Jet OLEDB:Link Provider String").Value string...
| |
by: 111mike |
last post by:
Hello,
Here's my problem. I cannot connect to mysql database using odbc string
connections or dns. I keep getting a "cannot connect to mysql server localhost." I'm running windows XP Pro and have installed IIS as my server. I have installed Mysql 5.0 and mysql ODBC driver 3.51.12 in their default locations. Database is up and running okay, as I've been able to create databases and tables and access
them via the command prompt and...
|
by: ApexData |
last post by:
Hello
I currently Link the FE/BE using the LinkTables Option and the Linked
Table Manager. Any time I need to move the BE to another location, I
have to go through this process over again. I need the flexibility of
being able to move the BE data to wherever I want, without manually
going through this process. I just want to change the Path/Filename
that I keep in a FE Table.
I want to be able to place a Path/Filename in a FE Table...
|
by: Neil |
last post by:
I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.
However, an associate of mine has reported that he had problems running his
A03 mdb in A07. Apprently, whenever he opened a form using the acDialog
property, the form opened as a single horizontal line (a "slither," as he
called it). He then resized the from in A07 and saved it in A07,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |