d**t
发帖数: 14 | 1 Hello,
I tried to import all tables from Access97 Database to SQL Server 7.0 by DTS.
There is an error message as following:
Error Source: Jet Database Engine
Error Description: You don't have permission to read "A" table.
However, I have all permissions for that database and all tables. I am
wondering there are some problems with driver setting. But I cannot figure out
the problems, could anybody know how to do it?
Thank you very much! |
|
a****a
发帖数: 3905 | 2 昨天把实验数据的数据库架构拷回家, 想建一个小的数据库,
但是M$的Access2000实在是破.
碰到的第一个问题是, Access2000对Access97编的东东只能用, 不能修改构架
只好先把数据库转成Access2000的格式.
然后发现, 与数据库相关的一个VB6的小程序竟然不能连上数据库
翻出VB装上, debug之后竟然发现VB6的程序不能识别Access2000的数据库.
没办法, 只好重新把数据库转成Access97的格式, 输入数据, 再转回来.
在接下来, 发现自己对数据库的权限有限, 然后读了半天帮助文件,
却发现Access2000多了一堆新的安全设置, 缺省值竟然不是完全权限, 折腾了
几个来回, 才把所有的权限放开.
然后就是, 不小心运行了一个错误的query, 竟然不报错一直运行下去
原本80兆左右的文件, 膨胀到快400兆, 吃掉了我硬盘上最后的空间.
只好整个删掉从头再来.
对了, 再有就是还得时不时的压缩一下数据库, 要不然膨胀得很迅速
而缺省的关闭时压缩, 实在是讨厌, 有时候只不过开了看一下就关,
还要等上半天等它压缩.
折腾完数据库, 已 |
|
z****e
发帖数: 54598 | 3 2014年08月01日 01:59 21世纪经济报道 评论中大奖（2,867人参与） 收藏本文
律师：国内盗版系统泛滥微软也是垄断
微软回应反垄断调查：中国业务始终合法合规
本报记者 侯继勇 北京报道
“微软(43.08, -0.08, -0.19%)昨天刚从我们公司榨取了6万元。”7月31日，一位
互联网创业者向21世纪经济报道爆料。
不久前，微软联合当地工商突袭该公司打击盗版，公司被查封，然后一台台电脑核
查，公司员工被指定在旁边配合调查，很多员工都吓蒙了，以为公司摊上大事了。但该
创业者觉得微软盗版认定很有问题：公司所有电脑都运行正版软件，部分笔记本电脑属
于公私两用型，装的是家庭版，而不是企业版，接照微软认定，这属于盗版。同时，在
购买企业版时，必须在微软指定的代理商处购买。
该创业者说，负责他们签约的代理商说：紧跟微软打盗版的步伐，基本上每周都能
签约六七家。据这位代理商向该创业者透露：微软每逢产品升级时，都是严打盗版，以
推动新版软件销售。
该企业相关人员问微软：“如何找到我们公司的？”微软方面回答：“你们公司最
近做宣传了吧？”
开始做宣传意味着这家公司... 阅读全帖 |
|
l***s
发帖数: 259 | 4 I am using VB6 to manage database.
I have two database in different format ACCESS97 and 2000
so i cannot merge them into one for other users are using them too.
So, can I open two connections in my vb program,
and using SELECT to build a new recordset to join the two table? and how?
Thanks, guys. |
|
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! |
|
x****a
发帖数: 6 | 6 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! |
|
h****e
发帖数: 204 | 7 hmm.. didn't try Access 2000. does your dc work fine when connects
with Access97? maybe you need rebuild the connection...
btw, what driver or provider u used for the database connection? |
|
a*****a
发帖数: 438 | 8 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 | 9 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. |
|
