a****a 发帖数: 3905 | 1 昨天把实验数据的数据库架构拷回家, 想建一个小的数据库,
但是M$的Access2000实在是破.
碰到的第一个问题是, Access2000对Access97编的东东只能用, 不能修改构架
只好先把数据库转成Access2000的格式.
然后发现, 与数据库相关的一个VB6的小程序竟然不能连上数据库
翻出VB装上, debug之后竟然发现VB6的程序不能识别Access2000的数据库.
没办法, 只好重新把数据库转成Access97的格式, 输入数据, 再转回来.
在接下来, 发现自己对数据库的权限有限, 然后读了半天帮助文件,
却发现Access2000多了一堆新的安全设置, 缺省值竟然不是完全权限, 折腾了
几个来回, 才把所有的权限放开.
然后就是, 不小心运行了一个错误的query, 竟然不报错一直运行下去
原本80兆左右的文件, 膨胀到快400兆, 吃掉了我硬盘上最后的空间.
只好整个删掉从头再来.
对了, 再有就是还得时不时的压缩一下数据库, 要不然膨胀得很迅速
而缺省的关闭时压缩, 实在是讨厌, 有时候只不过开了看一下就关,
还要等上半天等它压缩.
折腾完数据库, 已 |
|
h****e 发帖数: 204 | 2 this is normally because when u use Access2000 to open a mdb file created
by older version of Access, it will be ReadOnly. try converting the mdb
to Access2000 format. |
|
z***y 发帖数: 13818 | 3 我找了几个网站asp代码学习,装上以后首页能出来,但是经常出现"[microsoft][ODBC
microsoft Access Driver]不能更新。数据库对象为只读"的错误。我检查了半天,也搞
不懂是哪里除了问题。
我装了access2000,操作系统是win2000 pro和win2000 server。我在两套系统上都试过
,问题是一样的。
我检查asp脚本,似乎在定义access driver的一行代码就显示出错。比如:
Set conn=Server.CreatObject("ADODB.Connection")
conn.open "driver={microsoft Access Driver (*.mdb)}; & Dbpath
这一行就不对了,可是我怎么也看不出不对来。
难道跟Access的版本有关? |
|
s***f 发帖数: 173 | 4 hi all,
I'v been tryin to connect to a remote Ms-Access2000 database using the m/c's
IP address. i tried using the IP address in the connection string. it ain't
happening. its recognizing the m/c name though. i need to make it work with an
IP address, any help will be greatly appreciated. a few examples of code will
speed up things ;-)
thanx |
|
e***s 发帖数: 1397 | 5 I want to manipulate Access 2000 database with VB6.
But the VB data control can not open Access 2000 mdb
file. How should I handle this, without convert the
Access 2000 back to Access97?
Thanks a lot! |
|
|
N**e 发帖数: 158 | 7 how about update you vb with service pack 3? |
|
a*****a 发帖数: 438 | 8 Access is ok if your db is not very big. I'd prefer using
SQL Server because Access does not support indexing or
full-text search service. (From Access2000 on it's using SQL
Server's engine instead of JET engine, but I don't know if
it supports indexing now).
We had an implementation of something like what you were
looking for - two web services (one implemented in ATL
SERVER, one in C# ASP.NET) syncing some newsgroups and
maillists and store every post in SQL Server 2000 db, then
index on every |
|
b******d 发帖数: 115 | 9 i created a new database using Access2000, there is one table which
i populated 14000 rows. the .mdb file size is about 14MB. but after i
deleted all the rows in that table, the .mdb file size didn't change.
how come? i even tried closing the database. does that mean the .mdb
file will always be allocated this much space?
thanks... |
|
x****a 发帖数: 6 | 10 I got a problem to define 'Database' object in Access 2000.
I use Dim db as Database, but Database doesn't show up. If I type
Database on my own, the code doesnt' compile. The error is 'object
not found'. I never have this problem in Access97. Who knows what's the
reason? Thanks! |
|
a*****a 发帖数: 438 | 11 Iremembered there was such a problem in VC6 MFC. sth to do with Access97
or Access2000 incompatibility. ultimately the solution was to install patch
of VC6. you might want to install VS6 SP5 (or SP6)? |
|
W****S 发帖数: 6555 | 12 hiahiahia.
for access97, micro soft uses dao3.5 while access 2k use dao 3.6. simply add
dao360.dll in project and remove 350.dll. that's all. of course. in datacontrol
also should change the database to access2000. |
|
g*******l 发帖数: 6 | 13 I am trying to add a control(command button) on the Data access page in
Access2000. Can I write the event procedure in VBA? How to connect the
procedure to the control? |
|
P******a 发帖数: 121 | 14 【 以下文字转载自 Programming 讨论区 】
【 原文由 Pilipala 所发表 】
vb6的data control是不是不能连接access2000的数据库啊?
我在学校里用的也是vb6,就能够
可是自己家里装的vb6就不行,是不是有什么upgrade的东东?
很急,谢谢! |
|
z***y 发帖数: 13818 | 15 【 以下文字转载自 BuildingWeb 讨论区,原文如下 】
发信人: zmimy (咪咪), 信区: BuildingWeb
标 题: 我的asp脚本为什么总是出现"数据库对象不能更新"的错误 ?
发信站: The unknown SPACE (Sun Sep 1 00:46:08 2002) WWW-POST
我找了几个网站asp代码学习,装上以后首页能出来,但是经常出现"[microsoft][ODBC
microsoft Access Driver]不能更新。数据库对象为只读"的错误。我检查了半天,也搞
不懂是哪里除了问题。
我装了access2000,操作系统是win2000 pro和win2000 server。我在两套系统上都试过
,问题是一样的。
我检查asp脚本,似乎在定义access driver的一行代码就显示出错。比如:
Set conn=Server.CreatObject("ADODB.Connection")
conn.open "driver={microsoft Access Driver (*.mdb)}; & Dbpath
这一行就不对了, |
|
h**********r 发帖数: 174 | 16 The case is like this:
I created an SQL statement as a string in the VBA code, how do I save it
as a query so I can use it later.
Thanks. |
|
h**********r 发帖数: 174 | 17 Using ADO's RecordSet in Access2000
I have a very simple table with only two fields(byte, text). I want
to use RecordSet to add a row into it by using the AddNew methods. But
it seems the Recordset opened with this table doesn't support the
AddNew method.
Could anyone tell me any possible reason of this?
Thanks a lot. |
|
|
w******i 发帖数: 1476 | 19 I run it from Access2000 (Query) SQL View. Should it be the application?
thanks!
that |
|
h***a 发帖数: 358 | 20 我在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也行. 多谢 |
|
|
C******y 发帖数: 2007 | 22 PROC IMPORT OUT= data1
DATATABLE= "xxx"
DBMS=ACCESS2000 REPLACE;
DATABASE="c:\1\2.mdb";
RUN;
The code may vary depending on version of access and sas
出错 |
|