Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the size is
17.3 MB. But if we use the User/ Group Permissions to secure our database,
the same 3000 records added will give us a size of 36.2 MB. What causes
such drastic overhead when using the permissions? The only time the
password is required is on startup, correct?
Again, thanks
Jordan 6 1830
Sorry, but there is no way that adding user/group permissions would be the
cause of that.
You must be doing something else different.
HTH,
TC
"Jordan @aongsi.ca>" <jordan.bruce<remove> wrote in message
news:Ve******************@news20.bellglobal.com... Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the size
is 17.3 MB. But if we use the User/ Group Permissions to secure our
database, the same 3000 records added will give us a size of 36.2 MB. What causes such drastic overhead when using the permissions? The only time the password is required is on startup, correct?
Again, thanks
Jordan
"Jordan @aongsi.ca>" <jordan.bruce<remove> wrote in message
news:Ve******************@news20.bellglobal.com... Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the
size is 17.3 MB. But if we use the User/ Group Permissions to secure our
database, the same 3000 records added will give us a size of 36.2 MB. What
causes such drastic overhead when using the permissions? The only time the password is required is on startup, correct?
Again, thanks
Jordan
Are these figures both after a compact? Various operations cause a
temporary bloat that can be retrieved by compacting.
I have never seen this sort of bloat due to securing a database. If you
used the security wizard it will by default encrypt the MDB which will
prevent it from being zipped or otherwise file squeezed but it shouldn't
double in size in its normal format.
The passwords are not stored in the database at all just the permissions
to the objects.
David
Are you using compact on exit?
"Jordan" <jordan.bruce<remove>@aongsi.ca> wrote in message news:<Ve******************@news20.bellglobal.com>. .. Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the size is 17.3 MB. But if we use the User/ Group Permissions to secure our database, the same 3000 records added will give us a size of 36.2 MB. What causes such drastic overhead when using the permissions? The only time the password is required is on startup, correct?
Again, thanks
Jordan
Yes we are compacting the database before and after the insertions, this is
why this problem seems to be so odd.
"Don Kuykendall" <sa*************@hotmail.com> wrote in message
news:59*************************@posting.google.co m... Are you using compact on exit?
"Jordan" <jordan.bruce<remove>@aongsi.ca> wrote in message
news:<Ve******************@news20.bellglobal.com>. .. Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the size
is 17.3 MB. But if we use the User/ Group Permissions to secure our
database, the same 3000 records added will give us a size of 36.2 MB. What causes such drastic overhead when using the permissions? The only time the password is required is on startup, correct?
Again, thanks
Jordan
"Jordan @aongsi.ca>" <jordan.bruce<remove> wrote in message
news:2u******************@news20.bellglobal.com... Yes we are compacting the database before and after the insertions, this
is why this problem seems to be so odd. "Don Kuykendall" <sa*************@hotmail.com> wrote in message news:59*************************@posting.google.co m... Are you using compact on exit?
"Jordan" <jordan.bruce<remove>@aongsi.ca> wrote in message news:<Ve******************@news20.bellglobal.com>. .. Hi and Thanks in advance,
After inserting 3000 records into our database (MS Access 2000) the
size is 17.3 MB. But if we use the User/ Group Permissions to secure our database, the same 3000 records added will give us a size of 36.2 MB. What
causes such drastic overhead when using the permissions? The only time the password is required is on startup, correct?
Again, thanks
Jordan
Sorry for the last post, we are not compacting the database after the
insertions because the insertions do not complete because we reach the size
limit.
"Jordan @aongsi.ca>" <jordan.bruce<remove> wrote in message
news:OC******************@news20.bellglobal.com... "Jordan @aongsi.ca>" <jordan.bruce<remove> wrote in message news:2u******************@news20.bellglobal.com... Yes we are compacting the database before and after the insertions, this is why this problem seems to be so odd. "Don Kuykendall" <sa*************@hotmail.com> wrote in message news:59*************************@posting.google.co m... Are you using compact on exit?
"Jordan" <jordan.bruce<remove>@aongsi.ca> wrote in message news:<Ve******************@news20.bellglobal.com>. .. > Hi and Thanks in advance, > > After inserting 3000 records into our database (MS Access 2000) the size is > 17.3 MB. But if we use the User/ Group Permissions to secure our database, > the same 3000 records added will give us a size of 36.2 MB. What causes > such drastic overhead when using the permissions? The only time the > password is required is on startup, correct? > > > Again, thanks > > Jordan
Sorry for the last post, we are not compacting the database after the insertions because the insertions do not complete because we reach the
size limit.
What size limit? 3000 records/36Mb is nowhere near any Access size limit!
TC This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ken |
last post by:
I have been working on this problem for a few days.
When I write data into a sql database, the results are duplicate listings:
PHP Code:
<?php
session_start();
$dbh=mysql_connect...
|
by: g |
last post by:
Hi,
I have an MS Access 2000 Database on a network. When ever 2 people use it at
the same time it crashes. The database size is 14 megs. I have another
database just like it...and it has not...
|
by: Steve Jorgensen |
last post by:
I've run across this issue several times of late, and I've never come up with
a satisfactory answer to the best way to handle this schema issue. You have a
large section of schema in which a...
|
by: scorpion53061 |
last post by:
is it possible to set the database password that you can set in access for a
database from a vb.net application?
|
by: Carrugar |
last post by:
Hi folks,
I am issuing the net use command on a couple of Win2003 servers. Some of these servers require that the name and password be authenticated twice and other servers just once, i.e.:
...
|
by: acehigh1983 |
last post by:
hello fellow coders
i'll try and explain this as best as i can... I have created a .shtml page, all this does is mimic another webpage (i.e. same variables, textboxes etc) its just a different...
|
by: n8kindt |
last post by:
i'm trying to create a secure scenario where no one will be able to know our encrypted database passcode. BUT if they login to a form in another database successfully, it will open the encrypted...
|
by: Curtis Rutland |
last post by:
How To Use A Database In Your Program Part II
This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
|
by: Carl Banks |
last post by:
I was wondering if anyone had any advice on this.
This is not to study graph theory; I'm using the graph to represent a
problem domain. The graphs could be arbitrarily large, and could
easily...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |