|
¹ØÓڣͣƣõÄÒ»µãÐĵÃ
ûÓÐʲô̫´óµÄÏë·¨
...
|
1 |
05.12.2005 01:25:39 |
|
|
Upgrading Access databases to SQL 2005 Exp
Hello,
I read your response on upgrading Access databases to SQL 2005 Exp.
I could not find any information on the upsizing/upgrading MS Access 2003
database files to new SQL Server 2005 Express type. I am a novice in this
topic, therefore I need step by step instructions. I am using XP (SP2),
Office 2003, I also installed SSMSEE. Can you produce instructions on
either from Access end or f...
|
1 |
04.12.2005 15:43:46 |
|
|
ÎÒÊÇÏãÏã
Â𣿡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÓÀÔ¶µÄÅóÓÑ
begin 666 5100871x.jpg
M_]C_X `02D9)1@`!`@``9 !D``#_[ `11'5C:WD``0`$````/ ``_^X`#D%D
M;V)E`&3 `````?_;`(0`!@0$! 4$!@4%!@D&!08)"P@&!@@+# H*"PH*#! ,
M# P,# P0# X/$ \.#!,3%!03$QP;&QL<'Q\?'Q\?'Q\?'P$'!P<-# T8$! 8
M&A41%1H?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?'Q\?
M'Q\?'Q\?'Q\?_\ `$0@`J !X`P$1``(1`0,1`?_$`*H```(#`0$!`0``````
M```...
|
1 |
03.12.2005 08:11:31 |
|
|
ÄãºÃ
ÎҺܺÃÆäʵÄã²»ÖªµÀ
...
|
1 |
03.12.2005 07:39:06 |
|
|
format time
Hi. I have a combo box that is based on a view. The combo displays a
beginning time and an end time for a class. I have the datetime field
converted so that it displays only the time as such: CONVERT(nchar(20),
dbo.tblClasses.BegTime, 108) AS Beg_Time. This displays the time in
military format like 13:00:00. I would like it to show 1:00 PM instead.
Anyone know how to do this? Thanks.
Je...
|
8 |
02.12.2005 17:41:33 |
|
|
currency display in unbound field
Hello. In a combo box, i show the cost for the class which is a money
column. In the display of the combo box it shows fine: $250.00. But,
on my form, i have an unbound text box that displays the cost after a
class is chosen from the combo box. But, it is not displaying it
properly, it is showing 250. I formatted the text box as currency and
even tried using a custom format $###.00 but i s...
|
3 |
02.12.2005 17:40:11 |
|
|
wq
ÄãºÃ°¡,
ºÃ¾Ã²»¼ûÄ㻹ºÃ°É,
...
|
1 |
02.12.2005 13:19:42 |
|
|
ÄãºÃ
ÄãºÃ°¡ !
ºÃ¾Ã²»¼ûÄ㻹ºÃ°É,ÎÒÊÇÕæµÄÕæµÄºÜÏëÄã°¡
...
|
1 |
02.12.2005 13:13:26 |
|
|
upsize_ts field
After running the upsizing in all tables was added a field, called upsize_ts.
What can I do with this field?
Can I delete it?
Thanks,
José Perdigão...
|
9 |
02.12.2005 09:03:45 |
|
|
Data export from text file to SQL Server DB
Is there a way to to import text files to SQL server database table(s) using
MS Access ? If so, how ?. I know that the text files can be imported to SQL
Server database table(s) without using MS Access but we have people who are
not familiar with SQL Server at all and we are trying to get them to be
familiar with it.
Thanks for any help....
|
7 |
01.12.2005 23:02:11 |
|
|
Timestamp question
I'm discovering now that Timestamp fields aren't dates, but just unique
numbers.
Is that true or in those "unique numbers" there's a date part? Hope so,
'cause I would like, given the timestamp column, select groups of records
modified in a date range...
If this is possible what type of Convert/cast statement must i issue in the
Select?
Thanks
...
|
3 |
01.12.2005 17:55:46 |
|
|
Problems Exporting SP to excel via docmd.outputto
Hi,
i experience this problem:
I have an SP called Test which expect a date range, so the string to call
the sp is: stSP="EXEC Test '01/01/05','31/12/05'", for example.
I want to export the resultset to excel using:
DoCmd.OutputTo acOutputStoredProcedure , stSP, acFormatXLS, "c:\prova.xls",
1
everyting works, but excel tries to use the name of the SP (stSP) as the
name of the ...
|
2 |
01.12.2005 17:02:00 |
|
|
Runtime Error 2107
My form is based on a SQL statement. When it produces no results I
allow the user to click a "search" button which creates a modified SQL
statement, gets an adodb.recordset and trys to set the form's recordset
to this new recordset.
Set RS = objMyObject.GetWithChildren(intID, _
strDocNumber, _
intT...
|
1 |
01.12.2005 16:12:18 |
|
|
Getting relationships when you Link Tables to a SQL Server
Hi, all.
I have a project for which I would like to use Access to do Ad Hoc reports
from a SQL Server database.
When I Link Tables, though, the relationships don't come down. Is there a
way to get them? Is there a better way to solve the problem? Thanks for any
input.
S
...
|
1 |
01.12.2005 14:31:02 |
|
|
Coalescing date ranges
Hi all,
First, sorry for cross-posting, but as I have flexibility on how I do this,
I thought I'd post it to the two most-relevant groups. I can do this either
server-side, using a stored procedure, or I can do it client-side using VBA.
The recordset is only a few thousand records, and we all have at least 3M
down/800k up DSL if not 10/100 LAN connections, so client-side isn't really
...
|
17 |
30.11.2005 20:34:03 |
|
|
On KeyUp problem
for moveing to a client in a form i use that code:
Private Sub InputTxtBox_KeyUp(KeyCode As Integer, Shift As Integer)
Me.Recalc
InputTxtBox.OnKeyUp = ""
Me.Requery
InputTxtBox.SetFocus
SendKeys "{F2}", True
InputTxtBox.OnKeyUp = "[Event Procedure]"
End Sub
the recordsource based on an input parameter:
select * from tbl where ClientName>=?
parmeter is:
...
|
1 |
30.11.2005 15:34:51 |
|
|
Connecting ADP to SQL server
Can someone tell me what versions of SQL can connect to an ACCESS 2003 data
project?
Specifically, can a 2003 adp connect to a sql version newer than 2000?
Thanks for your help,
Steve
Madison, MS
...
|
6 |
30.11.2005 14:55:10 |
|
|
adding a new field to sql backend with VB
I have a client with an access 2002 frontend linked to a sql backend. I need
to add a new field to the sql backend from access. I'm new to sql backends
and work offsite so I don't have access to their sql server. I am tring to
set up a wrkodbc.connection but am not sure of the commands to then add a new
boolean field. Thanks,
Christine...
|
2 |
30.11.2005 04:30:11 |
|
|
cancel system login prompt
the access to the application is with sql server Authentication
for login i use a login form
but before it opsen's there is a system login prompt
how can i cancel this prompt?
thanks
...
|
4 |
29.11.2005 16:10:26 |
|
|
Nur Textzeiger sind in Arbeitstabellen zulässig ????
Hallo zusammen
Innerhalb einer Strored Procdure habe ich folgenden Insert:
INSERT INTO LB ( DAT , ID , B_TEXT , ID_OLD , )
VALUES ( Getdate() , @ID_NEW , @B_TEXT , @ID )
Die Spalte B_TEXT hat den Datentyp TEXT, der Parameter B_TEXT auch.
Die andern Parameter sind jeweils Integer.
Die SP produziert folgenden Fehler:
Nur Textzeiger sind in Arbeitstabellen zulässig, ...
|
1 |
28.11.2005 16:15:18 |
|
|
Datum ToShortDateString, aber nicht in deutschem sondern englischem Format ?!
Hallo NG,
auf deutsch keine Problem:
txtDatum = meinDatum.ToShortDateString()
Aber ich brauche es wahlweise auch auf englisch formatiert:
zt = zd.ToString(New CultureInfo("en-US"))
dann aber kommt das lange Datumsformat mit Uhrzeit bis Sekunden.
Wie kriege ich das englische Kurzdatum?
Danke
LIz
...
|
1 |
28.11.2005 14:29:47 |
|
|
Hide tables
how can i hide tables so user cannot see?
...
|
1 |
28.11.2005 10:11:22 |
|
|
dynamic table
hi,
how can I hide the 'total' line ? 'cause I am using this like an agenda
tks
...
|
1 |
24.11.2005 14:36:26 |
|
|
from an adp link to other information stored in a MySQL database
I have used an ODBC connection to link an MDB to MySQL, but I also have an
ADP program connected to an MSDE database, but need to also fetch addtional
info fom a MYsql datgabase. I have been unable to establish such a link.
Can someone point me at an explanation for how to do this?
...
|
5 |
24.11.2005 07:06:53 |
|
|
ADP Report Problems
I have a SQL backend and ADP frontend deployed on users local systems. My
problem is the my reports are losing their page settings. I read this was a
problem with Access 2000 and SP-1a fixes the issue but all my clients are
running SP-3 so that's not the issue. The other solution was to disable
AutoCorrect from Tools-Options-General Tab. While this may provide the
solution for mdb files, Aut...
|
1 |
23.11.2005 19:13:03 |