M*******y
发帖数: 14 | 1 Hi there,
I am performing a very simple experiment with DB2.
The query is: select count(*) from table1
I am interested in the disk I/O activities.
Is there any way to ensure disk access? I.E. to clear
the database's cache. The 2nd (and later)run is lightening fast, presumably no
disk access.
I've tried
1. db2stop, clear the OS cache, db2start
2. select * from some large junk tables and then repeat 1.
The query still runs very fast.
Thank you in advance.
cha |
|
S*******s
发帖数: 13043 | 2 i know I can do so by Automation against Access application.
but it requires the installation of Access.
it is possible to compact a mdb file through another way that is easy to dis
tribute, say, ADO or something? |
|
b*e
发帖数: 3845 | 3 I am thinking which one to choose for my application, MS Access
or MySQL. The total size of users is around 100.
If I use MS Access, how to update the database from a remote
machine? Thanks. |
|
u**t
发帖数: 11 | 4 请教数据库高手,SQL Server 和Access到底有什么区别,什么时候该用SQL Server,什么时
候该用Access. |
|
c*****t
发帖数: 1879 | 5 I have a JDBC program which may do simultaneous ODBC accesses. Should
I do critical section read/write protection or Access ODBC driver can
handle it? Thanks. |
|
l*********l
发帖数: 1 | 6 Tricky question. There is a table in access 2000 which has a column with type
memo. The long (>255) length string is stored in that column. If I write a sql
in access to retrieve it, the length of the string returned is correct. The
insteresting thing is that when I write the sql in java application and
retrieve it through ODBC, the length of the string returned will be truncated
to 255 no matter how long it was.
My code is like:
...
Statement stmt = con.createStatement();
ResultSet rs = stmt.ex |
|
j****g
发帖数: 331 | 7 DAXIA, sorry that I can't type Chinese now :(
Who knows how to combine several (more than 150) access tables with exactly
the same data structure (in one access file) into one table (.dbf is ok, Excel
can't handle that many records)?
I really really appreciate it!!!!!!!!!! Thanks a million! |
|
c*o
发帖数: 70 | 8 I need to access my database (MS sqlserver) at home from lab. I think I need
the IP address and sqlserver username and password. It seems that I need to
format some connection strings. But what is the detailed method to access the
remote database from programs (e.g. .net, vb, vc) or from some command lines
as administrator, by which I can do some administration work remotely .
Thank you so much! |
|
|
t**h
发帖数: 229 | 9 Dear friends,
I want to export data from my Access 2002 database to text format, so that I
could import the data to other database.
The problem is:
The field with type: number/double, such as, 200.1039231
after the export, I can only see 200.10 in the text file. I lost the number
precision.
Could someone tell me the tips&tricks of how to export the data from MS Access
while keeping the precision?
Thanks in advance. |
|
l*****k
发帖数: 587 | 10 I find importing to access extremely annoying, since it never
tell what the problem is except for there is an error...
is there a way to paste an excel column(s) to an access column(s)
thanks |
|
z***d
发帖数: 350 | 11 I'm working on a small database by using Access 2002. My boss asked me to add
a tricky function that a message box will jump out when users close a changed
database.
I found Access save changes automatically. So how can i do that? please help,
thanks a lot!!! |
|
a****e
发帖数: 2064 | 12 如何在ACCESS环境下用SQL QUERY?
数据库是ACCESS里建的TABLE. |
|
f****n
发帖数: 47 | 13 用户只希望用Access，难道Access做不到这一点？
其他大侠有什么建议吗？
很着急，谢谢了。 |
|
L********e
发帖数: 1202 | 14 Access experts,
In MS Access, I set the startup page to be one form and unchecked the "show
database window". I know I could still open the database window later using
key F11 or go to Windows->Unhide. However, I want to use a VB macro to re-show
the database window so that some user can choose to see all the database by
clicking a button on my startup form. How do I realize that?
Thanks a lot,
Zane |
|
l****s
发帖数: 4 | 15 每个Access操作，都会激活中文输入(微软拼音).请问是不是Access的操作与微软拼音的
什么快捷键相同从而激活它？请问如何解决呢？我试过在control panel->keyboard 里改
快捷键，可是还是不行。请高人指点。 |
|
h***n
发帖数: 1036 | 16 有 一个Access 97 的Table, Table 共有 三个 Filed: Name, Status, UpdateDate。
我想写个 Query 或 Module， 当我更新Status后，电脑能在 UpdateDate 的 field把
当天更新Status 的日期自动更新(如 4/8/2004)。 每次当我更新Status后， 还要再输入
当天更新Status的日期，实在是太繁了(因为数据很多)。
有什么办法，可以让电脑在UpdateDate 的 field把当天更新Status 的日期自动更新(如
4/8/2004)。
那位Access 高手能解答一下。先 谢谢了。 |
|
m******y
发帖数: 588 | 17 hi, I am trying to build some simple user interface in MS ACCESS 2003 Project
that connects to SQL Server. I wrote a parameter stored procedure that will
pop up a Enter Parameter Dialog Box. The problem is that the dialog box is too
ugly and I can't find a way to customize it in MS ACCESS Project. Could anyone
tell me how to do it? Thanks a lot! |
|
aw
发帖数: 127 | 18 简单的VBA编程还是要会一点的，比如FORM上的数据你想处理一下再插入数据库TABLE，FO
RM与FORM之间关系什么的。
ACCESS(或其他数据库系统)和HTML没有关系。数据库都是用来存储数据的，至于将来把数
据调出来干什么(比如用HTML显示在WEB上)，是另外一回事了。你可以在数据库里存文件
，但估计这不是你现在想问的问题。
ACCESS适合小型的数据库管理，用户不多三五个，比如系里管个图书馆系统什么的。
要
般 |
|
n****f
发帖数: 905 | 19 很容易.
要先在 Access use ODBC Driver 连接 ORACLE
然后将 ACCESS 数据加进 ORACLE.
里
简单的VBA编程还是要会一点的，比如FORM上的数据你想处理一下再插入数据库TABLE，
把
文
据
？ |
|
m*******r
发帖数: 4 | 20 I have a problem with my VB program. This program retrieves data from MS
Access Database, after view each record, update it back to the database. The
problem is that it can always update some records but unable to update certain
other records. It always gives me an error "Could not save; Locked by another
user!" But I am very sure I am the only person who is accessing the database.
There is absolutely no other users!
Is this a problem with the program itself or the database? I checked the
progra |
|
b*******a
发帖数: 1 | 21 请教一个问题，如果不想建立access数据库，由于空间有限，但是又想用户输入密码在进
入， 据说可以用html连到text file,这样，只要核对text，就可以控制用户， 不知道用
什么语句可以access text file in html
thank you very much. |
|
j******t
发帖数: 11 | 22 【 以下文字转载自 Statistics 讨论区,原文如下 】
发信人: jackycat (黄小幺), 信区: Statistics
标 题: question about SQL in Access
发信站: Unknown Space - 未名空间 (Thu Sep 2 09:31:38 2004) WWW-POST
How can I write some SQL queries in Access? Under "Queries"? I only see two
options there: 1. Create query in Design view; 2. Create query by using
wizard. None of them leads to some place where I can write SQL. Any help
will be appreciated. |
|
h***n
发帖数: 1036 | 23 MySQL or MS Access? which one is better?
Anyone had experience with MySQL 4.x and MS Access?
Thanks. |
|
h***a
发帖数: 358 | 24 我在access2000 中建立了一个tree view
+....folder1
-.....folder2
......file1
......file2
....folder3
+表示有东西，可以expand, -表示已经expand 了， 没有child 的话，
就没有任何加+,-好。
我现在要求得到这样的结果。
+, - 继续要所表达的意思。 但是在根目录下， 可以区分是不同的level的node.
列如， 根目录下可以有file, 有folder, 但是我不知道怎么用符号或者 image把他们给
区分开
+....folder1
-.....folder2
......file1
......file2
....folder3
....file3
就象建立folder 和file 一样。 一看就知道是文件夹还是文件， 是空文件夹，还是有东
西
请问有人知道access 里面怎么做吗? 用access 的VBA也行. 多谢 |
|
f********g
发帖数: 845 | 25 我们的数据库在另外一个州，从前我都是
link to the tables from Access, 但是query就很慢
今天发现还有pass-through query这个选择。请问
应该怎样用pass-through query to make tables, such
that the execution is done on the database engine in the
other state, while the result table is created in the
local Access interface
多谢多谢 |
|
c******y
发帖数: 8796 | 26 我在access 的open对话框里设置了ftp location
而且ftp权限也是最高的，可是acccess总说
unable to open or don't have read access。
请教这是怎么回事？急等回复！谢谢！ |
|
Y*****8
发帖数: 92 | 27 有没有哪位大侠知道在哪里有好的ACCESS的测试题啊? 看ACCESS的书有几天了, 马上有
个h很重要的考试了, 想知道自己的水平究竟怎么样. 就是Microsoft Certified
Professional Practice Test那样的practice test就行了.
谢了啊! |
|
s****u
发帖数: 23 | 28 I want to import a text file with millions of SSN to Access but every SSN in
text files have quotation marks. How can I get rid of quotation marks so
that in Access database, it just show the 9 digits.
Thanks |
|
WB
发帖数: 170 | 29 我用google的html导入到了excel，
数据比较规整，现在想要一步操作的方式把
excel选定的数据导入到access/sql的表格，是否可以。
比如导出到指定的access/mssql
偏偏excel2003没有导出。
excel2007有这个功能么 |
|
n****c
发帖数: 13 | 30 access有直接从Excel输入数据的功能，但是我不提倡用。因为这个方法老丢数据。比
较可靠的办法是，把Excel存为tab delimited文本文件(text file),然后用数据输入的
办法输入到Access. |
|
l*****d
发帖数: 12 | 31 A guy in my company wrote a Microsoft Access Database program. But now, he
forgot the password to enter his original codes. We have a lot of data in it
. How could I crash the password and get this data out of Microsoft Access
Database.
Thanks. |
|
c*a
发帖数: 806 | 32 【 以下文字转载自 Windows 讨论区 】
发信人: cfa (无名), 信区: Windows
标 题: 如何让Office / Access ignore system locale?
发信站: BBS 未名空间站 (Sun Aug 26 23:10:04 2007), 转信
来这里问一下。家里的Windows计算机system locale设成Chinese PRC, 这样去中国网
站很方便，不过Microsoft Office 12 default font 成了宋体，也不知怎么把它改回
来。
试着将locale 换成English US, everything is OK. 但是一改回来就不行。Office自
身带的Language Settings 一点都不起作用
on Windows, system locale set to China PRC, and then all fonts look weird,
is there anyway to have access to ignore system locale, and use Arial as
defaul |
|
p*****p
发帖数: 406 | 33 I want to build a simple database for the data in our lab. So I choosed
Microsoft Access since it is available at hand.
I made the forms and in one colomn of the forms, I put a hyperlink there
since I want to show photo there by just a click. Then I encounter a problem
. When I build the access page, which can be open in IE. All the link don't
work, they just shown as "#link path#".
Please help on this one. Thanks very much! |
|
i*****r
发帖数: 1302 | 34 就是用access的form连接access的数据库 |
|
t***u
发帖数: 284 | 35 别的coworker 建了一个linker server 在SQL server 2005 上, 可是每次我去在sql
server client 上去access, 系统都说我是annoymous login, 不能access. 我是用
windows authentication 去connect Sql server database 的，难道是因为建 linked
server 的co worker 不是admin? |
|
c*a
发帖数: 806 | 36 大家用access 做database front end 的多不多。估计现在大多是web based
我怎么觉得还是access 来的简单 |
|
s********1
发帖数: 581 | 37 MS Access在工业界用得多普遍吗？
据说MS Access仅仅用在办公室管理，工业界用IBM和oracle的软件。
谢谢。 |
|
h**h
发帖数: 488 | 38 工作中现在用ACCESS较多，为了和EXCEL匹配。正在自学。想问问大家，MS ACCESS有证
书吗？想考一个，说不定以后能用上。 |
|
h**h
发帖数: 488 | 39 能给多提供点信息吗？我知道我们用的database是在SQL Server上。这个肯定使用更好
，但没有CS的背景，不知道有多难。我们用ACCESS多，主要是一拨人就会用EXCEL，这
个和ACCESS接起来方便一些。
有什么书能看看吗？想考个证以后找工作也许能帮点忙。
有什么书能看看吗？想考个证以后找工作也许能帮点忙。 |
|
z********n
发帖数: 710 | 40 要做一个report in access,要求report的第一页和后面几页不一样，有没有版上知道
怎么做的？
我是新手。或者有什么link介绍做比较详细和复杂的report in access.谢谢了。
另外，我的table里面有很多客户，但是一个客户有很多record,我现在要设计一个
report出来是客户group在一起和他相应的record,然后下面一个是客户2，和他相应的
record。我知道用group可以实现这个功能，但是如果给每个客户的record 单独加上页
码呢？
如：
客户1：
record1
record2
record3
page 1 of 3 of 客户1
客户1：
record4
record5
record6
page 2 of 3 of 客户1
客户1：
record7
record8
record9
page 3 of 3 of 客户1
客户2
record1
record2
record3
page 1 of 1 of 客户2
客户3
....
thank you |
|
h**h
发帖数: 488 | 41 要design一个Access database，可以让用的人create Excel spreatsheet，最好是设
计个界面输入比如ID，就能产生与其有关的数据。是做report用的。
我以前倒是用过这种东西，但没有自己做过。有做过的给指导一下，有没有什么online
tutor或者power point的，能讲讲一步一步怎么做。不想看Access的书，太多东西。
谢谢！ |
|
g***l
发帖数: 18555 | 42 Access本来就有TABLE存储数据，干嘛又跑到EXCEL里去啊，EXCEL可以LINK到ACCESS里
面做TABLE用，FORM界面是一样的，不过要是EXCEL打开了就不能UPDATE了 |
|
h**h
发帖数: 488 | 43 就是做个Access的database，在界面输入就可以generate Excel。这是做给其他
department的人，方便他们field work. 我知道end use是什么样的，因为我也曾经用
过这样的东西。现在是要做，而且时间比较短，不想看Access的书，太厚。有什么比较
straightforward的instruction能给介绍一下就好了。 |
|
b*****e
发帖数: 364 | 44 Create a table in Access,
Create for form based one the table in ACCESS,
Type in data via the form,
Create a macro to export the table to a Excel file,
After complete data entry, trigger the macro to export |
|
s*******z
发帖数: 422 | 45 I have two domains: A & B.
I host the ASP.NET site on Domain B, but need to access a folder on Domain A
. I can physically open the folder on B, but when I click the link on the
webpage, it gave me this error message:
Access to the path '\AAA\BBB' is denied.
Can anyone help? Thanks a lot! |
|
m****e
发帖数: 1197 | 46 【 以下文字转载自 WaterWorld 讨论区 】
发信人: mentee (Bless 2011), 信区: WaterWorld
标 题: Can someone find me an Access person for a project?
发信站: BBS 未名空间站 (Fri May 20 10:17:39 2011, 美东)
he/she can be in China, or whereever in the world...it's a basic access
project...would like to pay for it. |
|
i****i
发帖数: 43 | 47 Yes, I have fixed the original linked table. Now everything is going well.
Does this problem relate to Access 2003 and Access 2007 conflicts? |
|
s***u
发帖数: 41 | 48 beijing:
非常感谢你给我提供的信息！
我大致看了一下，还没有操作。请问你按照你提供的这些步骤，是不是主要就是为了装
MySQL Migration toolkit? 刚发现我机器上有MySQL Migration toolkit? （version
1.1.1.2)， 但是没有MySQL workbench。－－－是不是只要有MySQL Migration
toolkit就可以转换了。（Access 2003 database to MySQL），但是这也就限制于数
据转移而已。要在网上那个实现那个Access数据系统的其他功能，我还需要做其他工作
。 是吗？
谢谢。
shaou |
|
g***l
发帖数: 18555 | 49 当然需要重新写REPORT，换个系统那么容易，你把WINDOWS MIGRATE到LINUX里去试试，
道理是一样的。ACCESS就是个PERSONAL DATABASE，什么叫PERSONAL，就是只能一个人
用，你在这个一个人用的基础上做的所有工作一但扔了ACCESS都要重新做。 |
|
n********6
发帖数: 1511 | 50 谁能给个链接讲解一下user access to system database file (master.mdf,
masterlog.ldf, ...)。
如果用account1装了sql server，能否把account1的access去掉？
用cacl 的时候，可否针对具体的user? google到的例子都是不是针对一个具体的user
，而是针对一个role如“Power Users”。
admin干哪些活的时候需要从file directory访问这些文件？没有从file directory访
问这些文件的权限，是否影响其用studio做admin的活？
谢谢。 |
|
