|
We distribute an application that uses an MS Access .mdb file. Somebody has noticed that after opening the file in MS Access the file size shrinks a lot. That suggests that the file is a good candidate for compacting, but we don't supply the means for...
Started by Corey Trager on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
I've found that Access database files almost always get corrupted over time and defragment your tables ....
If you don't compact an Access database, over with, then don't bother.
Unless you don't care about your user's disk space).
|
|
I am working on a asp.net mvc application. I have a situation where I have to make many threads which are going to access the database using linqtosql. My question is, will it be fine to leave every thing on linqtosql to maintain the synchronization, ...
Started by San on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
But databases have been designed such that multiple clients (threads, processes, machines) can access/read.
|
|
I have a program in C# that uses an MS Access database and I'm using OleDb to connect and do queries on that database. My issue is that I have some sensitive info in the database and I don't want it to appear as an Access DB. I changed the extension, ...
Started by Mike on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I would recommend using SQLite or another non-access....
Access gets a pass becausehttp://www.connectionstrings.com/access has an entry for Ecxlusive mode.
To also take care that the files for the engine don't give it away as well.
|
Ask your Facebook Friends
|
We're thinking of "growing" a little MS-Access DB with a few tables, forms and queries for multiple users. (Using a different back-end is another, but more long-term option that is unfortunately currently not acceptable.)
Most users will be read-only,...
Started by IronGoofy on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Access is a great multi-user....
You can control the Default record.
Again, this is the kind of thing Access takes care or record locking is available in Access during data writes.
Are using optimistic or pessimistic locking.
|
|
(programming in iPhone objective-C)
I have a class level NSString* that I create, add property(nonatomic,retain) and synthesize code for and I can modify the string endlessly with stringByAppendingString functions and display the string using NSLog just...
Started by Tozar on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Are you sure that viewDidLoad is called before tableView.
If the latter is running first, then it'll try to access the variable before and takes care of the problem.
CellForRowAtIndexPath: methods.
|
|
Hi Suppose that we have a class named class1.
The class1 has several properties and methods and we have decided to specify the access specifier of class1 as internal.
Now, can we set the access specifier of class1 methods as public?
Started by odiseh on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Community wiki - as credit should go to Jon Skeet
Yes, you can set .
By rule access specifiers on methods and properties can not be more more accessible than cases which you may not care about.
|
|
I want to write a data access layer for a file based database behind a data driven website. There would be lots of concurrent update and reads going on, I'd like at the very least that access be serialized, so that page request would get in a nice orderly...
Started by MatthewMartin on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
What kind of website are you.
I don't know how ms-access deals with concurrency.
Sqlite database.
|
|
For my customer I occasionally do work in their live database in order to fix a problem they have created for themselves, or in order to fix bad data that my product's bugs created. Much like Unix root access, it's just dangerous. What lessons should ...
Started by Kevin Conner on
, 48 posts
by 47 people.
Answer Snippets (Read the full thread at stackoverflow):
Coming from a development background, I don't want/need/should have access.
The DBAs do the work.
|
|
I'm trying to figure out how to make this hack for attr_accessible to support a really common use case in my code, but really after looking at attr_acessible and ActiveRecord::Base source code for a while, still don't know where to start. I can probably...
Started by Allan Grant on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you go ahead and try to implement this as a gem, I'd probably be a bigger fan of the #2 syntax you proposed.... .
I'm pretty sure this kind of functionality doesn't currently exist .
ActiveRecord has an attr_readonly method that should do what you need .
|
|
If a hacker has access to the hashes in my DB, he has access to the rest of the information in the DB anyways. So why would he bother trying to decrypt the passwords? Should I be storing the passwords on a different server to the rest of my data? That...
Started by paulogrady on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
But if the passwords are still websites (including, e.g., online access....
Sometimes they find a little SQL injection access to a snapshot like this he can learn a lot about your system.
Sometimes a hacker doesn't get full access to your DB.
|
