Access File/Get Data can't attach to a SQL table.

Bob C.

In Access 97, I am trying to attach to a table in my SQL Server 2000
db.

I use File/Get Data, which displays all the SQL tables including the
one I can't attach to. (I can attach to all the other SQL tables.)

But, when I select that table I get a message that tells me the name
is invalid. I don't understand this because it gives me the name in
the Get Data dialog, and I don't have to enter it manually.

Any ideas?

Thanks,

Bob C.

Jul 20 '05 #1

Subscribe Reply

2038

Christopher Secord

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Bob C." <bc******@bmgho mes.com> wrote in message
news:2e******** *************** ***@posting.goo gle.com...

But, when I select that table I get a message that tells me the name is invalid. I don't understand this because it gives me the name in the Get Data dialog, and I don't have to enter it manually.

There are two possibilities that I can think of. It could be a
permissions issue with the file, or it could have something to do
with the file name. What is the filename anyway?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32) - WinPT 0.7.96rc1

iD8DBQFAPljWM39 tsRlF0f4RAlXcAJ kBMpWHojQ917bRP ejK6Lr0oX/LAACfdpab
P+ZyeV7v8sku9Jd GzXHvcYY=
=ofVq
-----END PGP SIGNATURE-----

Jul 20 '05 #2

Bob C.

The table name is "CommunityCommi ssionDetail".

Among the possible problems listed in the message, the only one that
made any sense was: filename may be too long.

But, I have two tables with slightly longer names that attached and
work just fine.

Thanks.

Bob C.

Jul 20 '05 #3

Christopher Secord

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

"Bob C." <bc******@bmgho mes.com> wrote in message

news:2e******** *************** ***@posting.goo gle.com...

The table name is "CommunityCommi ssionDetail".

I guess it's not the name then. I just did a little test and was

able to link to a table with that name.

The only other good idea I have is that the table is owned by another

user. What are the permissions on the table in SQL Server?

Also, can you post the create script for it? This is a long shot but

maybe it has something to do with a certain data type.

-----BEGIN PGP SIGNATURE-----

Version: GnuPG v1.2.1 (MingW32) - WinPT 0.7.96rc1

iD8DBQFAP5l5M39 tsRlF0f4RAmFOAJ 4j6/BP9y4NKD0N4VfoX 1ZgyQpKhACfau2C

Ijty++xwLOXqbvx mvznvbSg=

=qK5T

-----END PGP SIGNATURE-----

Jul 20 '05 #4

Similar topics

1936

ASP link back to Access database

by: TrvlOrm | last post by:

I am having great difficulty in these asp scripts, using VBscript and JavaScript. I have 4 files that all need to be linked together. The first file "Books.html" - needs to search for a Book title, author or ISBN number from a Access database called "Books.mdb". When the user clicks Submit from the "Books.html" file (after inputting info in a text box and clicking the required box to define Title, Author or ISBN), the information is...

Javascript

2805

Question on Importing text data to Access

by: D Mat | last post by:

Hi, I'm trying to get MS Access 2000 to automatically import a series of (~200) flat text, tab delimited, data files into a single Access table, with consistent fields and rows. The files have different, but somewhat logical naming structures (ex.Jun01.txt, Jun02.txt, Jul01.txt, etc...). Is there a relatively simple way to accomplish this, considering i'm new to Access. I was especially hoping to do this without having to manually...

Microsoft Access / VBA

3908

docmd.sendobject ...sending a non-Access object

by: jerry.ranch | last post by:

I collect information from my clients with an xls file I import the xls data into my access table. I don't have them put info directly into Access, because, despite the drop downs I have for data validation in my xls sheet, some fields are not suited to drops downs and there is some editing I have to do. Its not a big deal, I do this maybe 20 times a week. So on a tab in my form, I have a make request button which I want them to be...

Microsoft Access / VBA

4425

Ms Access 2003

by: Mell via AccessMonster.com | last post by:

Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...

Microsoft Access / VBA

6554

Attaching files to an Access db

by: Mark | last post by:

I know that you can format url's withing an Access database but can you physically attach Word, Excel or pdf files within one? I need to attach backup documents into a database I am creating. Any suggestions for a workaround or alternative solution? Thanks Mark

Microsoft Access / VBA

3349

Updating Access Report using Excel

by: somanyusernamesaretakenal | last post by:

What I am trying to achieve: Basically I have generated a report in access. This report needs to be updated using excel. (Updating the new data, not changing existing data) What I did was I imported the existing report into Excel (Tools – Office Links – Analyze It with MS Excel). Then I linked the report to the Excel file. (File – Get External Data – Link tables) and a link table was automatically generated. I wanted to test the link,...

Microsoft Access / VBA

6113

Importing Outlook emails into an Access table

by: NEWSGROUPS | last post by:

I know that I can import data from my Outlook inbox by going to File -Get External Data -Import -Select Files Of Type Outlook() etc... using the wizard but can this be done systemically via VBA code similarly to transfer text. I actually need to import data from a group account at work. I have searched hi and low through the Newsgroups and web and have found nothing. Any help would be much appreciated. Thanks to all in advance, Markco

Microsoft Access / VBA

2765

Access 2.0 link to Sql Server

by: Mourad | last post by:

I need to attach (link) a table in SQL Server 2005 database to an Access 2.0 front-end database: On Access 2.0: Click File\Attach Table..., select <SQL Databaseclick OK On the "SQL Data Sources" dialog box, however, I cannot see a "SQL Server" selection!!! So' I'm unable to link!

Microsoft Access / VBA

10600

Problem With Comparison Operator <=> in G++

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...

C / C++

10352

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10354

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10097

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7642

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5535

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4313

transfer the data from one system to another through ip address

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

C# / C Sharp

3835

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3002

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General