|
Upsizing Wizard tries to Convert Memo Field to Date/Time vs nvarchar
I am attempting to upsize an Access 2002 mdb to an adp linked to MSDE 2000.
When I run the upsizing wizard everything seems to work except for one
table that contains a memo field. I dropped the (empty) target table that
resulted from the first attempt and ran export from the file menu to an
ODBC data source that points at the new SQL database. ODBC can connect to
the DSN just fine but I ...
|
1 |
09.04.2006 17:33:52 |
|
|
Can't insert into inner joined table
Access 2003 + SPx, ADO 2.8, MS SQL Server 2000, .adp, bound form.
Into the load event, me.recordsource is set to
SELECT tblA.*, tblB.*
FROM tblA
INNER JOIN tblB ON tblA.IDB = tblB.IDB
None of the fileds of tblB is shown nor updated in the single form; tblB is
only joined for sorting purposes.
Now when inserting a new record from the form (basically in tblA) I get an
error:
"C...
|
10 |
07.04.2006 12:22:57 |
|
|
HELP !!!! Access Runtime 2000 and Sql 2000
Hi,
we have the following problem.
We developped an access 2000 application working with Sql 2000.
We have to install the runtime on a workstation. On it, we find office 97.
The problem is that the runtime shows error trying to connect to Sql 2000.
We tried to add more references like msado at the runtime generation, but
the installation can't process.
We tried to manually copy some sql...
|
1 |
07.04.2006 07:34:02 |
|
|
SQL 2005 - works GREAT with ADP
team
i just had to give you guys a heads up.. .ADP 2002 works GREAT against
SQL 2005.
I am quite impressed.
does anyone know when the patch is going to come out to allow us
realworld developers to update sprocs and views?
this from the company that shipped Access 2000 and SQL 2000 when they
wouldn't talk to each other.
bunch of drunk retard product managers at microsoft; they sho...
|
5 |
06.04.2006 18:25:36 |
|
|
how can I show...
how can I show tables that contains a specific column ?
Everaldo Ricardo
...
|
2 |
06.04.2006 07:26:21 |
|
|
Procedure names ;1
Just upgraded database from SQL 2000 to 2005. All works fine on development
computer. Other users computers are showing different problems. The
strangest is that the stored procedures are showing up as
procedure_name;1 (dbo)
When you run the procdure it prompts for required paramaters but then says
it can not find it.
What dll's are used to access SQL database?
...
|
5 |
06.04.2006 07:18:39 |
|
|
Miscrosft Access link to SQL 2000 table view is #Deleted
I had this problem and noticed a few other people have experience this
also. No real solution has offered by most groups. I believe the best
work around is to use the SQL import and Export utility to export the
view or table you are after into Microsoft Access and then setup to
schedule the process. Works like a dream!!!
...
|
1 |
06.04.2006 04:41:58 |
|
|
Managing ADO warnings
Is there a way to manage in the .adp VB code the ADO warnings?
Example:
If you try to delete a record that conflicts with cascaded deletes rules you
get an error like "DELETE statement conflicted with COLUMN REFERENCE
constraint ....." bla bla bla.
Any hint ? I undesrtand you could go for a query-before-delete approach
but......
...
|
5 |
05.04.2006 16:42:05 |
|
|
ÀÏÆÅ
¶öÁË°É
µÈÏÂÈ¥³Ô·¹
...
|
1 |
05.04.2006 10:30:21 |
|
|
²»»áÔõôµÄ
²»ÊÇÎÒÎÞÄÜ
Ö»ÊÇÎÒÎÞÄÎ
...
|
1 |
05.04.2006 10:26:02 |
|
|
sdgsgsdgsdg
sdgsdgsdgsdg
...
|
1 |
05.04.2006 10:17:52 |
|
|
SET DATEFIRST ignored by adp
Hello
I'm running Access XP (German) along MSDE on an english Win2k server
and I seem to have a problem with the DATEFIRST.
The query SELECT @@DATEFIRST AS 'FirstWeekday' returns 7
in my SQL (MSDE) environment.
But the same query returns 1 in my Access project (adp).
The interesting thing is that it always returns 1, even if I use the
SET DATEFIRST command on my SQL server to set it...
|
3 |
05.04.2006 10:12:41 |
|
|
Convert from Access 2003 to SQL
We want to expand our DB from Access to SQL Server.
1)Is SQL 2005 stable enough to use yet?
2) Does anyone know of any documentation I can use to research this
conversion (i.e setup, architecture, risks, benefits, disadvantages...)
Thank you
...
|
2 |
05.04.2006 04:22:27 |
|
|
Stored procedure
I have this problem and I hope that someone can help me.
When I create a stored procedure in access Xp with this command:
Set cnn = CurrentProject.Connection
criteria = "create procedure " & ProcedureName & " as select * from " &
Txt35 & " where " & Txt38
cnn.Execute (criteria)
cnn.Close
and I execute the procedure
DoCmd.OpenStoredProcedure ...
|
7 |
03.04.2006 21:54:41 |
|
|
Stored Procedure (Using a variable in FROM Clause)
I have this stored proc:
Create PROCEDURE dbo.spoc_ev_update_branch_cds (
@dbName varchar(25))
AS
-- ===============================================================
-- Procedure: spoc_ev_update_branch_cds
-- Written By: xxxxxxxxxxxxxxxxxxxxxxxxxx
-- Purpose: Deletes all records from Branch Table,
-- and updates with new values.
--
-- Updates from @dbName
-- Date Developer D...
|
6 |
03.04.2006 19:10:55 |
|
|
datepart + dateadd
I am trying to select children from a table whose birthday falls within
21 and 28 days from today but am not having much success. Below is the
sql statement. Does anyone know what i'm doing wrong? Thanks.
SELECT dbo.tblChild.FName, dbo.tblChild.LName,
dbo.tblChild.Birthday
FROM dbo.tblChild
WHERE (CAST(DATEPART(month, dbo.tblChild.Birthday) + DATEPART(day,
dbo.tblChild.Bi...
|
7 |
03.04.2006 16:49:30 |
|
|
Decimals in stored proc parameters
I have a stored procedure which will return a list of records with geographic
coordinates (decimal degrees) within a certain range. The parameters it
prompts for are the coordinates of the top left hand corner and the bottom
right-hand corner of a rectangle - 4 parameters of data type decimal(10,6).
If I hard-code the coordinates into the stored proc, evrything works
perfectly. If I prom...
|
3 |
03.04.2006 02:28:01 |
|
|
Access Project (adp) with Sql Server 2000 - First Connection Latency
Hi folks,
after searching and searching (and sometimes just trying to foget the
problem) im really stuck...
I deployed an adp-application to a customer network (win2k-server with
Sql Server 2000/ win2k-workstations with mdac 2.8, Access 2000 Sp3) .
Everything works fine - only the first time I wait for accessing data
lasts for about 15 seconds or if the user leaves the application
untou...
|
13 |
31.03.2006 20:25:33 |
|
|
dlookup with stored proc's
hi, i am upgrading an Access97 mdb to Access2002 adp. As part of the
exercise i am implementing further security by utilising stored procedures
calls.
The existing mdb calls dlookup in a number of instances. Has anyone found a
workaround to using Dlookup with stored procedures? or is the alternative to
replace dlookup an ADO connection to the database?
thanks,
Stuart
--
Message p...
|
6 |
31.03.2006 17:53:07 |
|
|
creating email messages through Access 2003
I have an issure trying to send emails from Access 2003. I receive the
following error:
8007007e (-2147024770), "The specified module could not be found"
I tried the fixes listed at http://support.microsoft.com/kb/327219/en-us but
they didn't help.
I wish I didn't need to use Outlook Express components. Anybody know of
alternatives I could try?
Thanks!
--
Chris
...
|
2 |
31.03.2006 17:52:58 |
|
|
Access To SQL
I'm converting an Access 2000 database to SQL 2000. In this conversion I will
be creating a Web front end and need to know how to conditionally format HTML
tables based on the results of a query/view in SQL. Example: If dept. A sales
are <= x then format table cell red. If dept A sales >= y then format table
cell green.
Should (can) I attempt to do the formatting in SQL prior to submi...
|
3 |
31.03.2006 14:09:13 |
|
|
Sum with expression in form footer returns #error
Hi ,
in my access project (adp) I've bound a form to a SQLServer table and create
a control in the forms footer.
The controlsource is:
=Sum(([zeitaufwand]*[internerkostensatz]))+Sum([externe_kosten])
[zeitaufwand], [internerkostensatz] and [externe_kosten] are tablecolumns.
When I open the form the control displays #Error.
However, when import the same form into a Access database (.mdb...
|
4 |
31.03.2006 11:16:02 |
|
|
Adding rows to Access/SQL table
Access 2003 SQL 2000 Win 2000
In Access I added new rows directly into the linked table which resides on an
SQL back-end. When clicking on the table in Access the new rows are visible,
however, when I view the table in SQL Enterprise Mgr they are not added to
the table. Updating existing rows works fine. I tried relinking the tables...
no change. The only way I can sync the data is to delete...
|
3 |
31.03.2006 05:02:51 |
|
|
Table permissions: No matter what I set all users have full access?
Hi
Following my earlier question ((CROSS POSTED) Very strange: Connection under
process info not whats in front-end)
I have set the permissions for a particular table so that none of the listed
users can do anything (select, insert etc.) yet when I connect from another
machine via the ADP using Windows authentication (from a login thats not
even listed in the servers users I might ad...
|
6 |
30.03.2006 20:53:40 |
|
|
SQL coding not working in VBA
I am trying to run this query in VB but I must have it written wrong but I
can't find where.
Could some body help me out
RS.Open "Select email from team where SONumber = '" & SONumber & "' and where
Financialaccess ='" & 1 & "'", CurrentProject.Connection, adOpenKeyset,
adLockOptimistic
Thanks
--
Message posted via http://www.accessmonster.com...
|
3 |
30.03.2006 16:34:42 |