473,419 Members | 1,842 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,419 software developers and data experts.

Updating DB 2005 cannot connect with Access

I have a database and I am trying to update one of the tables called "members" I use to be able to update my table by upsizing through Access.
I have SQL Server Management Studio Express 2005 and Access 2007.
I can connect and retrieve the table that I have on the DB using Access but I can't upsize.
Is this a MS SQL thing or is it a problem with Access?
And what should I do to fix the problem.
I have over 2500 members and I really don't want to update manually.
Also is there another program I can use to update my DB instead of Access?

Thanks
Aug 26 '10 #1
1 1288
NeoPa
32,556 Expert Mod 16PB
I'd suggest using Data Transformation Services (DTS) to upload your Access table into SQL, then work natively in SQL from within Management Studio.

Welcome to Bytes!
Aug 27 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: bettina | last post by:
Hello, My domain: www.coaster.ch My database: coasters User: bettina In the programm I wrote: <?php $db_server = "www.coaster.ch";
2
by: Hari Om | last post by:
Cannot connect as Internal Hello, I am using IBM AIX 5.1L box for Oracle 9.2.0.1. I cannot connect as internal to my DB INstance - wonder why? Here is what is do:...
6
by: Jeff Sandler | last post by:
I have a database I created in mySQL. I've been entering data every day into the database using a Java application that I wrote. The database and the Java program are on the same Win 98 SE...
1
by: michi | last post by:
Hello there... I am trying to link to my access db on my server over the internet. My Administrator told me that I need to create a shared drive which is accessing the db server via ftp. So...
5
by: smatta | last post by:
I have just installed MySql version 5.0-18 on Red Hat Fedora Core 4. It is running but I cant connect to it using MySql Query Browser running on my pc. >From my pc, I can telnet to the sql...
1
by: bitchanger | last post by:
I have installed an SQL Server 2000 Developer Edition (SP4) on a computer that has Windows Server 2003 on it.The server is connected to the workgroup "WORK" and has no Active Directory. Now I...
3
by: Vino | last post by:
Dear All, I'm running my .net on win xp . When i open a new ASP.NET application, i get an error saying that - Cannot connect to local host on port 80. reasons : localhost access may be denied. ...
2
by: Dedric Starks | last post by:
Hello everyone, I was wondering if anyone else has gotten the error " ODBC- cannot connect to <db name> Failed. Using Access 2000 here.. the db and dsn are supposed to be on the local...
3
by: waw00 | last post by:
hi guys, i wonder whats the problem in my ASP code, I am trying to connect to a MS ACCESS 2k database. Here is my code: <% dim prov dim cnxn dim rs dim str prov="Provider=MSDASQL.1;Persist...
1
by: rubeel | last post by:
I cannot seem to connect to this Instance locally which was i able to in the past. I can connect to the instance from out side. The instance is running and the DBs in the instance are available and...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
tracyyun
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...
0
agi2029
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,...
0
isladogs
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...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.