Anyone have a good 'how to' for upsizing access 2002 for use as an import data
onto SQL server, we keep throwing errors.
Thanks
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracki
We are currently trying to figure out how much space will be taken up by an
Access DB that is around 250MB when we switch to an SQL Server DB. Anybody
have any general guidelines as to how much space we'll save by converting?
We need to know to price out hosting...
Thanks!
Ray
http://www.crys
The source is not a string, its a number. The destination would be a string
(varchar).
:-)
_
From: Casey C Cook [mailto:[EMAIL PROTECTED]
Sent: Friday, January 16, 2004 5:57 PM
To: CF-Talk
Subject: RE: Access to SQL
Ensure proper size/length of the destination field. If both data
Ensure proper size/length of the destination field. If both data elements
are treated as strings at source and destination and the destination
length is sufficient, Im not sure what the cause may be.
CC
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
: Access to SQL
Are you storing the zip in SQL as a numeric, int, char, or varchar?
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, January 16, 2004 4:47 PM
To: CF-Talk
Subject: OT: Access to SQL
Ok everyone, I have been unsuccessful in my attempts to
Are you storing the zip in SQL as a numeric, int, char, or varchar?
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, January 16, 2004 4:47 PM
To: CF-Talk
Subject: OT: Access to SQL
Ok everyone, I have been unsuccessful in my attempts to transfer a
Ok everyone, I have been unsuccessful in my attempts to transfer a table
from access to SQL Server and preserve the Zip Code from access when
bringing it into SQL Server. I tried DTS, and explored the books online,
etc.. To no avail... The leading and trailing zeros get truncated.
Would someone
if someone who has a moment, and can upsize an access db to sql server,
please email me offlist, i do not have access :) thanks if you can!!!
and those who cant/wont/think im a jerk for even asking :) thanks too :)
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb De
Just got back from lunch. I receive a lot of help from this list and I am
just glad that I could return one.
Josh
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 2:07 PM
To: CF-Talk
Subject: RE: Access to SQL discrepancy in transfer of
Thanks Joshua, that worked like a charm.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 1:45 PM
To: CF-Talk
Subject: RE: Access to SQL discrepancy in transfer of data
select fullname, role
fromdbo.tbl_users
essage-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 1:37 PM
To: CF-Talk
Subject: Access to SQL discrepancy in transfer of data
What a surprise, NOT!!
I have a QUERY in a QUERY that works fine in MS-Access 97, but bombs in SQL
SERVER 2000.
Here is the query:
What a surprise, NOT!!
I have a QUERY in a QUERY that works fine in MS-Access 97, but bombs in SQL
SERVER 2000.
Here is the query:
select fullname, role
fromdbo.tbl_users
where role = (select 'key_' & role as keyrole
from dbo.tbl_
to SQL
On 3/14/02, CF_JONNY penned:
>I have an Access 2000 db that I used to build the site and the HOST has
>created the SQL db for it.
>
>I can see it through Access.
>
>Question is do I need to reconfigure the DSN and connections in my CF
>Administrator to keep everythi
On 3/14/02, CF_JONNY penned:
>I have an Access 2000 db that I used to build the site and the HOST has
>created the SQL db for it.
>
>I can see it through Access.
>
>Question is do I need to reconfigure the DSN and connections in my CF
>Administrator to keep everything online with SQL DB?
Yes. Yo
I have an Access 2000 db that I used to build the site and the HOST has
created the SQL db for it.
I can see it through Access.
Question is do I need to reconfigure the DSN and connections in my CF
Administrator to keep everything online with SQL DB?
Any other concerns I should think of?
Than
I have an Access 2000 db that I used to build the site and the HOST has
created the SQL db for it.
I can see it through Access.
Question is do I need to reconfigure the DSN and connections in my CF
Administrator to keep everything online with SQL DB?
Any other concerns I should think of?
Than
I have an Access 2000 db that I used to build the site and the HOST has
created the SQL db for it.
I can see it through Access.
Question is do I need to reconfigure the DSN and connections in my CF
Administrator to keep everything online with SQL DB?
Any other concerns I should think of?
Than
You might want to check out other tips upsizing Access to SQL server in the
article
http://www.cfug-md.org/articles/upsizefrommsaccesstosqlserver.cfm
- Michael Smith, TeraTech, Inc http://www.teratech.com/
Clint Tredway wrote:
> You need to set this field to an 'int' datatype an
You need the: "Insert Into TABLENAME" Part
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 11:53 AM
To: CF-Talk
Subject: Re: Access to SQL Server
Thanks for your help. I have another question. Normally this query works
Where's the "insert into" clause?
**
Thanks for your help. I have another question. Normally this query works
(in Access):
something is missing here ... like "insert into mytable" ...
(FirstName, LastName, Email, Address, City, State, ZipCode, DOB, Phone
Oh man, I have not had enough coffee!
- Original Message -
From: "Bimal Shah" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 9:56 AM
Subject: RE: Access to SQL Server
> INSERT INTO(TABLE NAME) VALUES...?
&g
INSERT INTO(TABLE NAME) VALUES...?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 08 February 2002 16:53
To: CF-Talk
Subject: Re: Access to SQL Server
Thanks for your help. I have another question. Normally this query work
s
(in Access):
(FirstName
essing an element with a general identifier of
(CFQUERY), occupying document position (28:1) to (28:48).
Is the syntax alot different when inserting into sql server than Access?
- Original Message -----
From: "Tyler Silcox" <[EMAIL PROTECTED]>
To: "CF-Talk" &
On 2/8/02, Randy Adkins penned:
>
>In the field which you have make sure it is set
>to NOT allow NULLS and check the
>IDENTITY field and set the seed
>to 1 and the increment to 1
Actually, you can set the seed to whatever you wish. So if you're
doing a shopping cart application or whatnot, you c
--Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 7:36 AM
To: CF-Talk
Subject: Access to SQL Server
In Access you can set the primary key to auto number - how do you do this in
SQL Server? I would assume that has something to do with this er
Sent: Friday, February 08, 2002 10:35 AM
Subject: Access to SQL Server
In Access you can set the primary key to auto number - how do you do this in
SQL Server? I would assume that has something to do with this error that I
am getting:
Error Diagnostic Information
ODBC Error C
, February 08, 2002 10:36 AM
To: CF-Talk
Subject: Access to SQL Server
In Access you can set the primary key to auto number - how do you do this in
SQL Server? I would assume that has something to do with this error that I
am getting:
Error Diagnostic Information
ODBC Error Code
Set the identity property of that column to yes.
Jamie
On Fri, 8 Feb 2002 08:35:55 -0700, in cf-talk you wrote:
>In Access you can set the primary key to auto number - how do you do
this in
>SQL Server? I would assume that has something to do with this error
that I
>am getting:
>
> Err
In the field which you have make sure it is set
to NOT allow NULLS and check the
IDENTITY field and set the seed
to 1 and the increment to 1
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 10:35 AM
You need to set this field to an 'int' datatype and then set it as an ident
ity field. That will help.
HTH
Clint
-- Original Message --
from: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 8 Feb 2002 08:35:55 -0700
In Access you can set the pr
In Access you can set the primary key to auto number - how do you do this in
SQL Server? I would assume that has something to do with this error that I
am getting:
Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Serve
: CF-Talk
Subject: RE: Moving from Access to SQL server
SQL probably doesn't like "SELECT * FROM TABLE" - you need to be a bit
more specific about what columns you actually require. If your SQL code
is good you should be able to "upsize" to SQL Server without much
problem
o:[EMAIL PROTECTED]]
Sent: Thursday, 20 September 2001 0:26
To: CF-Talk
Subject: RE: Moving from Access to SQL server
Hi
I have a site which I would like to move from Access to SQl server are
there
any things I need to be aware of code wise things like dates perhaps?
Kola Oyedeji
Web devel
Hi
I have a site which I would like to move from Access to SQl server are there
any things I need to be aware of code wise things like dates perhaps?
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
t run any empirical tests - and would be
interested to hear others thoughts/knowledge...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 19:36
To: CF-Talk
Subject: RE: help with moving from access to sql server
Can't you just use
> Sent: Tuesday, September 04, 2001 1:36 PM
> To: CF-Talk
> Subject: RE: help with moving from access to sql server
>
>
> BIT is the correct type to use for a boolean value, but you must
> think about
> it first since BIT typed columns cannot be included in a GROUP BY clauses.
access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL
use cast() or convert() to change the datatype in your qry
On Tue, 4 Sep 2001, Declan Maher wrote:
> Could anybody help me with the following error regarding datatypes that
> I am getting having just moved my database from Access to SQL Server 7.
> I am receiving the following erro
What I'm saying is, you don't need a GROUP BY *at all* in this query.
Anyway, it worked, that's the main thing :-)
Nick
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 4:18 PM
To: CF-Talk
Subject: RE: help with moving
8 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 16:03
To: CF-Talk
Subject: RE: help with moving from access to sql server
Declan
You could use int, or you could use a
September 2001 15:48
To: CF-Talk
Subject: RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really ne
: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 15:48
To: CF-Talk
Subject: RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really
15:48
To: CF-Talk
Subject: RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really need to
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really need to be?
Nick
**
Information in this email is confidential and may be p
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
> could be the name of your field...I think key may be a reserved word. Try
> puting square brackets around the word 'key' like so: WHERE [key] = 1
> "Key" is a reserved word in Transact-SQL.
> Apart from that the syntax is fine.
Thanks for the info... will try again.
--
Aidan Whitehall <[
> SQL = "UPDATE Counter SET UID = (UID+1) WHERE Key = 1"
Aidan
Here's an answer I prepared earlier ;-)
"Key" is a reserved word in Transact-SQL.
Apart from that the syntax is fine.
Nick
**
Information in this email is conf
bubble Ltd
--
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2000 16:51
To: CF-Talk
Subject: Access to SQL Server
We've upsized a database from Access to SQL Server and are going through the
applications that use
We've upsized a database from Access to SQL Server and are going through the
applications that use it, looking for errors.
This one has cropped up...
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'Key'.
Data Source = "MMnsTrans01"
SQL
> One other thing that tripped me up recently is that even if
> you've enter a username and password for the ODBC datasource
> within the control panel applet, you still have to enter them
> in CF's ODBC setup.
The username and password you enter in the ODBC control panel are only used
to test
lt;[EMAIL PROTECTED]>
Date: Sunday, September 24, 2000 8:39 PM
Subject: Re: access to SQL server woes
>
>Hi Jim...
>thanks for your answer.
>it fixed the problem!
>
>I never even entered the ODBC setupwhich of course set the default
value
>to "master".
>
Original Message-
> From: avex <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Sunday, September 24, 2000 7:48 PM
> Subject: access to SQL server woes
>
>
> >hi everyone.....
> >
> >sorry if this is kid stuff..but i finally decide
I
believe the wizard presents a drop-down box that shows all of the
databases on the server.
Jim
-Original Message-
From: avex <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Sunday, September 24, 2000 7:48 PM
Subject: access to SQL server woes
>hi everyone.
hi everyone.
sorry if this is kid stuff..but i finally decided to make the jump from
access to SQL server on one of the applications i have done.
I used the import wizard in the SQL enterprise manager...and from the look
of it it imported all the tables and content correctly...
I
We will be eventually upgrading from Access to SQLserver but right now I
have an
application written for access and the client needs it converted to work on
SQL-server.
Is there any applications that can validate the sql statement to confirm
they are validate?
I don't have access to SQL-serv
I was using ODBC initially. I switched to OLE DB and that solved the issue.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 11:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: upsizing access to SQL server
I've just run a smal
CTED]]
Sent: 09 August 2000 16:00
To: Cf-Talk@Houseoffusion. Com (E-mail)
Subject: upsizing access to SQL server
I am running into memo field issues when upsizing to SQL server 7.0?
I
have been trying to upsize an access2000 db to SQL server by using both the
wizard interface and "im
I am running into memo field issues when upsizing to SQL server 7.0? I
have been trying to upsize an access2000 db to SQL server by using both the
wizard interface and "import data", but keep getting the error:
"error at destination for row #1, errors encountered so far in this task:1.
Hello fellow CF'ers
We have upsized several of our Access databases to SQL 7 and they work
great. While we are building the forms to update the database directly does
anybody see any problems with running our updates from the Access to the SQL
via standard SQL statements. For the time that's wh
Friday, April 28, 2000 10:51 AM
Subject: Re: access to sql server 7
> Not only broken image links, but the downlad keeps timing out too...
>
> Does anyone have a copy of the upsizing utility that they could perhaps
> email to me off list? Or I could set up an FTP account on one of our
&
2000 10:51 AM
Subject: Re: access to sql server 7
> Not only broken image links, but the downlad keeps timing out too...
>
> Does anyone have a copy of the upsizing utility that they could perhaps
> email to me off list? Or I could set up an FTP account on one of our
> server
l 28, 2000 8:40 AM
Subject: Re: access to sql server 7
> nice broken images on that link :-)
>
> - Original Message -
> From: "Fred Sanders" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 25, 2000 11:27 AM
> Subject: Re
nice broken images on that link :-)
- Original Message -
From: "Fred Sanders" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2000 11:27 AM
Subject: Re: access to sql server 7
> http://www.ukaug.co.uk/downloads/v8downloads.htm
&
http://www.ukaug.co.uk/downloads/v8downloads.htm
- Original Message -
From: "Won Lee" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: <[EMAIL PROTECTED]>
Sent: Friday, April 21, 2000 2:04 PM
Subject: access to sql server 7
> I can't seem to find the
I can't seem to find the SQL server upsizing window on microsoft.com
anyone have the specific link to it?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sideb
65 matches
Mail list logo