|
Cannot open table in ADP
I cannot open one specific SQL Server 2000 table in an Access 2003 project;
it fails with the message "Could not find column 'abc'" followed by "Cannot
open the table in datasheet view". The table once had this column and I
assume that I deleted this column from within Access instead of the
Enterprise Manager. It looks af if SQL Server still has a reference to this
deleted column in the ...
|
15 |
07.09.2006 06:29:01 |
|
|
creating tabes with full schema name
Access ADPs do not seem to reckognize full schema name i.e.
dbo.mytable.
?
...
|
2 |
06.09.2006 15:25:19 |
|
|
Open store procedure from VBA
I created a sp procedure with multi select statement.
From query analyzer, I open any select, depending of iCrint() value
The following code is example:
ALTER PROCEDURE P2_qrys
--@STR INT
AS
SET NOCOUNT ON
DECLARE @STR INT
SET @STR=dbo.iCrint()
--xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
-- Allocation
IF @STR=1
SELECT dDatez, Fieldd, Satel...
|
8 |
05.09.2006 19:52:07 |
|
|
transfer spreadsheet as dbo and not user id.
how can i use transfer spreadsheet to import data from a spreadsheet
and have the owner of the new object be dbo and not use the user's
network id as the owner?
tia,
mcnewsxp
...
|
1 |
05.09.2006 17:23:13 |
|
|
Refresh table objects after import
i am having to change object owner after an import to my ADP.
i need to refresh the view in the table objects viewer. how to with
code?
tia,
mcnewsxp
...
|
1 |
05.09.2006 14:17:19 |
|
|
Event from ocx was not fired
Hello friends,
I have a problem that I can't resolve. Would be very nice if anybody could
help me.
I have an ocx - programmed in VB6 - that only fires one event (DataChanged).
This ocx is used in a access-project (adp) on an access form. (Access XP).
No problems til now.
On my developing-PC the event was fired correctly. On an other PC with the
same Access-Version there is no event.
...
|
1 |
05.09.2006 12:45:07 |
|
|
Audit logging an adp
Hello
I need to add an audit trail to an existing, large adp application, which
was developed in AccessXP with a SQLServer 2000 backend.
I searched through all the Access pages and found numerous reference to
Allen Browne's audit code.
This is very much the sort of log I would like to keep, but his solution
won't work in an adp for a couple of reasons:
* You need client side tempTables, ...
|
4 |
04.09.2006 21:30:55 |
|
|
SSMA - Query Conversion to Stored Procedures.
When migrating my Access database to SQL Server none of my parameterized
Queries are converted to stored procedures. SSMA tells me my parameter
variable is undefined. In Access, I used the "Parameters" option to create my
parameter variables.
What must I do to get all fo these parameterized queries to convert to my
SQL Server database as Stored Procedures oir Views. ...
|
16 |
01.09.2006 12:06:18 |
|
|
SSMA Migration to Master
I've used the SSMA on two different machines, having good luck on one and not
on the other. The problem I'm having is that on my so successful machine, the
migration went to the proper SQL Server Database. On my unsuccessful machine,
the migration keeps going to the Master database, not the correct database.
I've got the Master un-selected and the new database selected.
I don't see why...
|
6 |
01.09.2006 03:30:03 |
|
|
Crosstab REPORT, not query
Crystal Reports can create a crosstab report without an underlying
crosstab query. Does an Access 2003 ADP support a similar feature, or
do I have to use SQL Server 2005's PIVOT feature as a makeshift
crosstab query to feed the report? If I have to PIVOT, is there a way
to use with without an aggregate function?
...
|
1 |
31.08.2006 23:52:02 |
|
|
Crosstab REPORT, not query
Crystal Reports can create a crosstab report without an underlying
crosstab query. Does an Access 2003 ADP support a similar feature, or
do I have to use SQL Server 2005's PIVOT feature as a makeshift
crosstab query to feed the report? If I have to PIVOT, is there a way
to use with without an aggregate function?
...
|
1 |
31.08.2006 23:51:49 |
|
|
How can I bound ms chart to ADO Recordset?
I can bound forms to ado record set
I can bound bombo box to ado recordset
I can bound list box to ado recordset
I tried to folow the same logical that I used for list box but in charts
doesn't work.
Any sugestions?
PS. I'm usign adp in access 2003 vs sql server 2000
Thanks,
Example to bound bombo box to ado recordset.
Private Sub Form_Open(Cancel As Integer)
Dim cn A...
|
1 |
31.08.2006 18:19:03 |
|
|
Making an Access - SQL db solution portable
I have an Access application which runs in a server enviroment where I have
an SQL server that the Access connects to. The customer is so happy with my
soultion and told another company about it, they would like something like
that, so I need to make a copy of the setup to a cd to send to the other
company - as a demo. They have no employees with enough IT knowledge to
install a SQL Serv...
|
9 |
31.08.2006 15:53:02 |
|
|
Problems with Access 2003 and SQL Server 2005
Hi, everyone.
I trying to connect a SQL Server 2005 to an Access 2003 frontend. Now
in the past I have not had any trouble, but today seems to be a
different day.
Every time I go to try and open a dao.database object I get the error
"Run-Time error '3000'': Reserved error(-1038); there is no message
for this error."
I am not really sure what the issue is here. Below is the line of...
|
6 |
31.08.2006 13:27:31 |
|
|
hhuih
jijoijpo
...
|
1 |
31.08.2006 13:09:31 |
|
|
How to refresh (programmatically) an ADP project's knowledge about views and stored procedures?
Hello,
I hope somebody could help me with this seemingly simple problem:
I have an ADP project (MS Access 2000) referring to SQL Server
database. I guess everyone knows that if I create a new view or stored
procedure in the SQL Server database while MS Access ADP application is
running, the application does not "know" about that new view or SP
until its "knowledge" about the underlying S...
|
11 |
31.08.2006 03:46:26 |
|
|
ADP and Local Tables
I have converted both my front end and back end to using the upsizing wizard.
I read in the "Access 2003 Bible" that in a client/server environment it is
not good to use bound forms because of having constantly open connections.
Is there any way to create and access a local table on the user's hard drive
where the front end .MDP resides and have that front access the table without
havi...
|
7 |
30.08.2006 16:31:02 |
|
|
CurrentProject.Connection.BeginTrans no active transaction
i get an error that says there says no active transactions when i
execute CurrentProject.Connection.CommitTrans.
i am executing CurrentProject.Connection.BeginTrans before.
why?
tia,
...
|
3 |
29.08.2006 17:59:52 |
|
|
SQL 2000 Service Pack 4
Hi
The company where I work is installing SP4. Anyone know if this should cause
any ADP issues?
Thanks
Diarmuid
...
|
1 |
29.08.2006 09:08:10 |
|
|
INCREIBLE...
begin 666 LA MEJOR FORMA DE HACER DINERO POR INTERNET Y ADEMAS AYUDAS A ALGUIEN AL REDEDOR DEL MUNDO.doc
MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
M````6@``````````$ ``7 ````$```#^____`````%D```#_____________
M____________________________________________________________
M____________________________________________________________
M___________________________________...
|
1 |
26.08.2006 20:03:22 |
|
|
dosti
salam
...
|
1 |
26.08.2006 14:02:02 |
|
|
Primary key
Is there a programmatic way to use VB code to set the Primary Key for a
table? This is for an ADP project accessing SQL Server tables. Access help
shows ADOX method but my system doesn't recognize ADOX.
Thanks,...
|
2 |
25.08.2006 20:02:31 |
|
|
´ó¼ÒºÃ
´ó¼ÒºÃ£¬Èç¹ûÓÐÈËÏëÈÏʶÎÒ¿ÉÒÔ¸øÎÒ·¢Óʼþ
...
|
1 |
23.08.2006 09:12:56 |
|
|
Stored Procedure temp table not returning any results in an ADP
In a SQL Server database, I have the following stored procedure:
Code:
ALTER PROC Test_10
AS
CREATE TABLE ##Temp3
(
tblUsersID int
)
INSERT ##Temp3
SELECT tblUsersID
FROM tblUsers
SELECT * FROM ##Temp3
When run from the Query Analyzer, the Stored Procedure provides a result
list. When I run the Stored Procedure from the ADP, it consistently tells me
that no reco...
|
3 |
22.08.2006 19:28:01 |
|
|
Access 2002 ADP & SQL 2005 Views
Access 2002 ADP & SQL 2005 Views
Recently we upgrade from Access 2002 ADP & SQL 2000, to Access 2002 ADP &
SQL2005.
This is cause a a few problems which we are trying to sovle.
Problem 1:
I a form which is based on a view for recordset, when I delete a record from
the form I get the message: "The data was added to the database but the data
won't be displayed in the form because...
|
8 |
22.08.2006 15:58:46 |