Compact Secured Database
Jan 31, 2008
I am trying to compact & repair a secured database. I log in exclusively as the administrator with the following shortcut property target: "C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE" f:pathnameappname.mdb /User "adminname" /Pwd "adminpwd" /wrkgrp f:pathnameappname.mdw /excl
When I run Compact & Repair, I get the following message: "Microsoft Office Access can't delete f:pathnameappname.mdb after compacting it. The compacted database has been named f:pathnamedb1.mdb."
It goes on to say that it can't delete the original database because it is read-only (even though it is not).
Can I compact a secured database manually, or does it require some sort of utility?
Thanks.
View Replies
ADVERTISEMENT
Sep 15, 2006
Hi :)
(A2K format, but running on XP, etc)
I have used Microsoft’s Security FAQ and recommendations on this forum and build a split database; secured with one worgroup file for development and one for customers: what is the most appropriate way to upgrade the backend database content (tables mostly) (as the front-end database can just be replaced) at the customers site?
At the customer there is no development workgroup file, so no permissions to change database objects. I would really like to run sql updates from the new FE database. The solution I currently have devised to go around this problem, involves a lot of manual data moving code, to take care of referential integrity etc. However this approach has a higher risk of creating errors and also takes a lot longer time.
Is there something I have misunderstood of the Security FAQ or recommendation on this forum?
Thanx
:)
View 8 Replies
View Related
Nov 1, 2007
Hi,
I have an Access database that needs to be secured and I have 2 problems:
1) How do I get it across a network so all users must enter their password?
2) How do I stop this from asking for a password for every database (i.e. I only want one database to require the password)?
Please keep answers simple as I am quite new to this!!
View 7 Replies
View Related
Jun 3, 2015
I have an access database that was set with security about 10 years ago.
I have now created another database in 2010 and I am importing all the objects to make a clean non secured database.
When I import tables it imports system table objects like MSysRelationships, but as it already exists it adds another MSysRelationships with a 1 on the end (MSysRelationships1).
Should I delete the original MSysRelationships and then rename the MSysRelationships1 as MSysRelationships.
There are numerous others like MSysAccessstorage, MSysACEs etc...
I am gathering that if I don't rename MSysRelationships1to MSysRelationships then the relationship data would be incorrect and the database wouldn't work correctly, but maybe I am wrong.
View 9 Replies
View Related
Mar 2, 2006
I know this has been discussed before but I have not been able to find a solution for my problem.
I have a database with linked tables from the back end database. The normal size is about 4.5 mb but after doing some work on a fairly simple form and a function with Select Case statements and simple SQL (the SQL was here before that change) the size has risen to 33Mb. This actually doubled to 66Mb earlier today after a very minor change but did compact back to 33Mb.
I have the Jet Compact Utility to no aval. I have tried creating a new database and imported all the objects from the original but again to no avail.
Help please???
Kevin
View 2 Replies
View Related
Aug 10, 2006
I have an access 2000 database, which we copied from it's original location to another computer. I now am trying to modify/update the file, and have discovered an unusual problem. The filesize is roughly 75 megs! It is not a huge database, the biggest table has 2200 entries x maybe 8 fields.
There apparently had been corruption in the 2200 line table, as when I first looked into it, it had something like 275,000 rows. So I deleted back to the 2200 "good" rows of data. Figured I had the filesize problem fixed. But it won't shrink. Tried compact/repair and it didnt help. Crunched data for a long time, seemed to be working, but the filesize turns out nearly the same.
I then created a new database, and imported all of the info from the "big" one. Filesize = 1.5 meg. Great! not really. I cant get any of the code to copy over and I am not a VBA guy. All of the form buttons return error messages, and when I look into the event procedures there is no code. I tried copying all that code over, and it appears to have copied, but it doesnt work.
Maybe someone out there can offer suggestions? Thanks, Harry Manvel
View 1 Replies
View Related
Jan 31, 2006
Hi,
I was wondering if anyone might be able to help me. What i'd like to do is to be able to get the access to trigger compact and repair database tool automatically just before it shuts. Is it feasible? or has to be done manually?
Thank you in advance
View 2 Replies
View Related
Aug 22, 2006
Hi,
I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not responding'. I have tried creating a new one from scrath and get the same issue. Can anyone help please?
View 3 Replies
View Related
Apr 17, 2007
The compact and repair utility is very good.
Since all my record operations are done through menu, I would like to put a command button for this utility also. But I dont know how to do this. Would somebody help? Thanks in advance.
View 2 Replies
View Related
Mar 17, 2008
Hi all,
I ahve come across a small problem and i am wandering if someone can helo me out on this.
I have a programme which is for the fast food and uses a order no for each receipt, now the problem is each time the form is closed and opened the number goes to the next avaialable number so last nunber was 32 the next will be 33 etc this number adding is done by code but i am having a problem somewhere along the lines and it goes back to 1 every so often, so the you have to log off and log in to to to the next available record,
So i was thinking rather having to do the number increment by code why not have a auto number field in there instead, the only problem is at the end of the day the number should go back to 1 for the next day so is there a way to compact and repair the database or better still to zero the tables i wish??
Thank you
Regards
Naym
View 2 Replies
View Related
Nov 18, 2004
HI,
Is there anyone out there that knows if it is possible in any way to make a database compact automatic at a certain time. If someone (user) has forgotten to close the database, automatic gets thrown out and then it compacts itself ?
View 5 Replies
View Related
Dec 28, 2004
To Everyone
My access database grow exponentially to 170 MB, We share the access database on the network and those tables on
the access database are linked to SQL Server. I tried to compact and converted to 2003 format, It still doesn't shrink too much for the size. Please someone tell me what should I do for it, because someone try to access thur the VPN connect, and it make no sense for her to take 5 mins for loading a report remotely.
Timothy
View 2 Replies
View Related
Mar 14, 2005
Hello All,
I have found myself with a big problem, One of my databases has managed to become rather large in size, 1,084,576kb
Unfortunatley i am unable to compact the database, as i get the following error on compact "record(s) can't be read; no read permission on L:database name"
The size of the database now seems to be the reason why reports and queries are failing,
I have tried "database utilities" Repair Database - and this has no affect.
I have also tried temporally removing some of the tables and queries into another database, but the Db size remains the same.
Does anyone have any ideas as i'm stumped? p.s. the database in running on ACCESS 97
Thanks and best regards
Aaron
View 3 Replies
View Related
Jan 6, 2006
i have a database that is 12 megabytes. when i compact and repair it, the database is 6 megabytes.
am i losing information? is there anything bad about compact and repaiir?
my database seems normal after the compact and repairt, but i would like to confirm weather or not compacting makes the database lose info
View 3 Replies
View Related
Aug 3, 2007
Is it possible to make the database compact and repair itself when it is closed to prevent it becoming too large?
Alternatively, can you create a macro to compact and repair at the click of a button?
Thanks, Steve
View 2 Replies
View Related
Feb 9, 2008
Can anyone give me guidance or code on how to automatically compact and repair.
There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and repair
Thanks in anticipation.
Humph
View 2 Replies
View Related
Jan 30, 2015
Access 2013 ... Is it possible to compact a database to a new name?
(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...
I can't see where to do this in Access 2013!
View 1 Replies
View Related
Nov 9, 2012
In my access applications i have used the database split built in functionallity to split my frontend and backend tables.I have created a mail mechanism and when the database grows to that level i recieve a mail, ask users to get out of the database and compact the database. But this is tiding. I have a scheduled job that compacts databases early in the morning before users logged on. But during day work databases grow enormous again. Well is there a way by VBA code to create an auto compact function that on idle will log off all users in the database and compact it?
View 2 Replies
View Related
Feb 12, 2014
"how to COMPACT the DB by introducing delay of 10 seconds and then close the DB".In the Database, I'm able to accomplish the "Compact" the database using the function below.
Function Compact()
SendKeys "%(FMC)", False
End Function
As my DB is quite huge, the Compact action takes around 10 seconds to complete.Now, i would like to Close the Database after Compacting the DB. I tried including "DoCmd.Quit" in the function. The commands in the function, closes the DB but the Compact function doesn't seem to have executed as it needs 10 seconds to complete.
Function Compact()
SendKeys "%(FMC)", False
DoCmd.Quit
End Function
how to introduce this delay of 10 seconds and then close the DB.
View 3 Replies
View Related
Jun 18, 2007
Hello All,
I have implemented Access security and it seems to be working or so I thought :(
I need to hide a few tables from users but some reports require access to the tables - which forced me to grant read access to the tables... which then lets users read the sensitive data. This is not good... How do you get around that issue? I'm confused...
(My DB is split into a FE/BE)
Thanks,
Lissa
View 5 Replies
View Related
Jul 20, 2005
I built a database and then set up usergroup permissions via the user level security wizard. Unfortunately I set the "Use this as the default workgroup file" (when I had only wanted to secure the database I was working on and now all databases are affected) option when running the wizard. The database resides on a network and some of the users can access the database without logging in and others cannot open the database at all, they get a message "Access cannot locate Secured.mdw file". Something obviously got corrupted when the wizard ran. I have two objectives:
How do I save the database? One user is using the database successfully (but she does not have to log in)
How do I remove the user level security so I can start over?
Any help would be much appreciated.
View 1 Replies
View Related
Jan 14, 2006
I created a DB program for my last job that resided on a stand alone PC. It has the Access generated user level security (so there's a "secured.mdb" file) and can only be opened via the desktop icon. In the past, when I copeid the db to a flash drive, took it home to work on it, it always said I didn't have permissions to run it unless I placed it in the right spot on my computer where I've got it set up with a secured file and the desktop to open it.
Yesterday, I noticed that I can now open it anywhere, including my laptop, and it just opens. My concern is, I don't trust the business where the program is being used to not take it and call it their own (I trust the management team, however).
ANy ideas why it no longer looks for the user level security now?
I'm running XP Pro on both machines, Access 2002 on the desktop and 2003 on the laptop.
Thanks.
View 10 Replies
View Related
Jul 20, 2007
Can anyone help please
How do you add a user to asecured database using vb
Thanks
View 1 Replies
View Related
Jan 17, 2007
I'm sure most people use Windows shortcuts to open their secured databases, but I found that it didn't always work (depending on which computer I used). Editing a shortcut is pretty confusing since the command is all on one line. I decided to make a batch file to open my secured databases instead. Here's a batch file I use to open a database of mine:@ECHO OFFREM - Set variables to be used in the batch file.SET BACK=Z:BobManager Listdb_be.mdbSET FRONT=Z:BobManager Listdb_fe.mdbSET WRKGRP=Z:BobManager ListSecured.mdwSET OFFICE=C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXEIF EXIST "%OFFICE%" GOTO PROMPTSET OFFICE=C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXEGOTO PROMPTREM - Ask the user which end to open.:PROMPTCLSSET /P dbChoice=Do you wish to open the frontend(1) or the backend(2)? if "%dbChoice%" == "1" ( "%OFFICE%" "%FRONT%" /wrkgrp "%WRKGRP%" GOTO END)if "%dbChoice%" == "2" ( "%OFFICE%" "%BACK%" /wrkgrp "%WRKGRP%" GOTO END):ENDThis isn't the simplest batch file ever, but if you want to use this you just need to change the paths to your frontend, backend, workgroup file, and your version of Access. If Office was installed in the default location you shouldn't need to change those lines, unless you know you'll always be using the same version of Access.
View 1 Replies
View Related
Nov 3, 2005
Hello,
I am wondering if there is a way of preventing people from linking tables with a database i have that has a security logon?
In essence they would be able to run their own database with the information in my secure mdb without first logging in !!
Is there a way of preventing this? Any pointers or guidance would be most helpful
Cheers
View 2 Replies
View Related
Dec 27, 2005
Hi everyone,
hopefully you'll be able to help me out with this one, been searching but can't find the exact answer.
I am running a database with multiple users, max of 10, currently the database autocompacts when it is closed, however this takes time every time anyone closes it.
what i am looking to do is have the database automatically compact but only once a day. Any ideas???
many thanks
View 1 Replies
View Related
