|
sp_addextendedproperty error
I try to create a query view in Entrerprise Manager and I get an error about
sp_addextendedproperty. What could be reason for the error ?
The full error
ODBC eror. Microsoft ODBC sql server driver sql server
An invalid parameter or option was specified for procedure
'sp_addextendedproperty'
Thanks
...
|
4 |
09.02.2006 07:59:28 |
|
|
Using Date/Time Fields
Does anyone have any tutorials that explain ways to use the date/time field?
I use these fields often to document when users perform actions using the
Now() function. I'd like to be able to query these fields for things like
just a particular date or between certain times of the day. Currently, for
example, to extract only the date from a date/time field, I use the
Convert() function t...
|
4 |
15.02.2006 16:57:14 |
|
|
Function Between in SQL Server 2000
Good afternoon,
1. In-Line-Funtion on the criteria column I type BETWEEN dbo.iStdt() AND
dbo.iDate() doesn´t work
2. If I type BETWEEN '01/01/2005' AND '12/12/2005' it works. This option I
can't use because the date is not variable.
3. if I type in one crteria column >=dbo.iStdt() and another column
<=dbo.iDate() it works.
My question is. Is it possible use the first criteria (B...
|
19 |
15.02.2006 11:03:17 |
|
|
Data transfer between Access and MySQL
Has anyone organised a data transfer from a client computer running Access
to MySQL tables located on the web ISP server? Is this possible? Are there
indirect ways around it?
chris
...
|
2 |
15.02.2006 06:59:42 |
|
|
ADP closing application without warning
Would a loss in a connection to the database server cause Access to close
without warning and without error message?
I'm using DNS name for the server and Windows NT Integrated security.
Thanks.
...
|
2 |
14.02.2006 17:44:00 |
|
|
Join three sentence in one
Hi, i got this
SELECT * FROM view6 INNER JOIN view4 ON view6.nrofolio = view4.nrofolio
ORDER BY view4.nrofolio, nrotrans
and work fine. it return a parent-child data from these table, but this two
views (view6 & view4) come from another query.
(ie)
Select * from customer (view6)
Select * from detail (view4)
How can i join all this three query in one sentence?
1st) Take cus...
|
1 |
14.02.2006 15:08:28 |
|
|
ADP subforms and unbound forms
Hi,
I've recently upsized a MSAccess2000 database to an access database project.
The ADP links into a SQL2000 backend.
I have a couple of issues still unresolved (bearing
in mind that these were working fine in MSAccess).
1. My forms are made up of several sub-forms - e.g a typical form is as
follows form held as follows:
Address details are held at 'company level', and contact i...
|
1 |
14.02.2006 14:37:27 |
|
|
executing stored proc
This is not throwing an error but it is not running the stored procedure
either...any ideas?
Thanks.
'Insert the apptSchdBuild record
Dim cmdInsrt As New ADODB.Command
With cmdInsrt
.ActiveConnection = CurrentProject.Connection
.CommandText = "sApptDateStaffFinalCCInsert"
.CommandType = adCmdStoredPr...
|
3 |
14.02.2006 13:16:16 |
|
|
TransferSpreedsheet, importing to temporary table
My problem is that I'm not sure what connection transfer spreadsheet
uses.
Currently I'm using
--------------------------------------------------------
Dim conn As Connection
Dim rs As New RecordSet
Set conn = CurrentProject.Connection
conn.BeginTransaction
DoCmd.TransferSpreadsheet TransferType:=acImport _
, SpreadsheetType:=acSpreadsheetTypeExcel9 _
, tableName:="#data" _
...
|
1 |
14.02.2006 12:52:02 |
|
|
ADP forms and SQL Server 2000 authentication
Hi,
I've recently upsized a MSAccess2000 database to an access database project.
The ADP links into a SQL2000 backend. I've got Chipman and Baron Microsoft
Access Developers guide to SQL server, which has been a great help so far.
I've got as far as converting all the queries to views and stored procedures
where necessary and am now testing the ADP front-end.
There are a couple of ...
|
2 |
13.02.2006 21:21:01 |
|
|
restore differential backup in adp project
hi,
i have an sql server database and a end-user application built in access
2003.
i wouls like to restore a differential backup of the database instead of
having to copy each time the full .dat file through the web and the restore
the whole datatabase..
any idea ?
thanks
...
|
1 |
13.02.2006 20:08:03 |
|
|
t
fu
...
|
1 |
12.02.2006 23:12:27 |
|
|
How can I improve the query by selection multiple fields from joined tables
Hello,
My problem is :
I am trying to join multiple tables and list the only needed fields in the
query result
the query takes less time if I join the tables wihout specifying any fields
from the joined tables
Iexplain :
The below query takes more times (all fields selected from all tables)
SELECT *
FROM T1 LEFT OUTER JOIN T2 on <joined condition>
T1 LEFT OUTER JOIN T3 on ...
|
2 |
11.02.2006 15:58:09 |
|
|
Äã¿ÉÒÔ
Äã¿ÉÒÔÕÒ¶®µÄ
...
|
1 |
11.02.2006 04:53:15 |
|
|
Data Access Page won't reconnect
I am trying to create a data access page for a project I'm working on. When
I create the page, it works fine. I can save it to my web server - it works
fine and I can access the data from any web browser. As long as I don't
leave "design mode" I can continue to modify and save the data access page,
but as soon as I leave I'm locked out of making any changes. When I try to
open the page i...
|
2 |
10.02.2006 17:14:23 |
|
|
reusing command object
I want to run the below code and then use the recordset after the update to
loop through and do necessary updates to the data that came through in the
stored procedure. I'm getting some locking errors. Any ideas would be
great.
Thanks.
Dim cmd As New ADODB.Command
Set cmd.ActiveConnection = CurrentProject.Connection
Dim rst As Recordset
Wit...
|
8 |
09.02.2006 22:20:26 |
|
|
TEXT data not appearing
I have a SQL Server 2000 database with some TEXT type columns. When I created
an Access 2003 project .adp file and opened tables, some TEXT data appears
but some fields appear empty even when I know there's data there. Can someone
tell me why this is happening?
Thanks,
James...
|
3 |
09.02.2006 16:04:46 |
|
|
Get ADP Custom Database Property - Document Number Value ** $100 To Any Can Do It...
Get ADP Custom Database Property - Document Number Value ** $100 To
Anybody Can Do It... i don't care if it takes you 15 seconds...
We will pay $100 dollars to any programmer who can GET the Document
Number value from the Database Properties area of an ADP & ADE (Access
2000 and up file format) from A VB PROJECT...
See this link to a screen shot for any clarification you might need on
e...
|
8 |
09.02.2006 04:31:25 |
|
|
performance problem with runtime
hi group!
i want to use the access runtime with an access 2003 ade-file. The problem
is that the application is slower with the runtime if i compare it with the
ade startet with the access full version!
anyone an idea?
best regards
andy
...
|
6 |
08.02.2006 17:37:48 |
|
|
Using Windows Authentication
For all of my previous Access .ADP applications, I've used a login screen
that the user uses to authenticate (a table stores usernames/passwords).
Once they've logged in, I store their login information in global variables.
The problem I've found is that sometimes when the programs are left up for
some time, the global variable information is dropped. They'll try to
access some portion ...
|
3 |
08.02.2006 17:00:26 |
|
|
Bulding expressions in views
in mdb, i can simplify expressions in queries using the the following:
a:field1*field2/24
b:field3/field4
c:a+b
In views I can't do this ( I believe is possible). I must type all
expressions (c:(field1*field2/24)+field3/field4)
I have complex expressions, it means, the final expression will be too long
and more complex to evaluate them.
Question.
There is a way...
|
14 |
08.02.2006 05:09:53 |
|
|
Two INNER JOIN, WHERE balks on first INNER JOIN
SELECT [App Info].[First Name], [App Info].MA, [App Info].[Last Name], [Class
Info].Date
FROM ([App Info] INNER JOIN [Class Info] ON [App Info].[Soc Sec #] = [Class
Info].[Soc Sec])
INNER JOIN [Desired Work] ON [App Info].[Soc Sec #] = [Desired Work].[Soc
Sec];
The above works, returning the four values that I asked for. But the
following doesn't work -- notice that the only change...
|
6 |
07.02.2006 19:24:55 |
|
|
Locking scheme for ODBC linked tables? Access + SQL Server
Sorry for posting in three newsgroups, but all seem appropriate and the
topic seems to have sparse coverage in general.
Using Access 2003 linked tables to SQL Server 2000 via ODBC. What's the
simplest way to implement explicit control over record locking? Even
with a timestamp in the table, letting Access' built in form record
locking warnings seem a bit tardy.
Probably my ideal sce...
|
8 |
06.02.2006 16:20:43 |
|
|
nvarchar als Binär im Enterpricemanager
Hallo,
ich habe seit heute ein Problem mit dem Enterpricemanger auf meiner XP
Workstation. Alls nvarchar Felder meiner Datenbank auf dem Server werden als
BINÄR angezeigt und auch so behandelt.
Eine Deinstallation und wieder Installation der Komponenten hat nichts
gebracht.
Auf dem Server selber ist aber alles ok. Dort gibt es keine Probleme.
MDAC ist 2.8
SQL Server 2000 mit SP4
Wü...
|
3 |
06.02.2006 10:44:46 |
|
|
Access SQL Server Locking
We have a product which has an Access 2000 front-end and a SQL Server backend
database. We are having a problem with locking in the Access front end
database as follows: if a user has the details of a record open and another
user is trying to create a new related record, if the first user changes some
details of the main record, sometime this record update will fail. An error
message app...
|
5 |
06.02.2006 09:34:30 |