I created a DB that I put security on and now everytime I create a new DB or go into a any DB I have to use a password even though it shouldn't require one. I know it has to do with the SYSTEM.mdw file but all of them say the same thing and I can't seem to find the problem. Please help.
View RepliesHello all!Maybe strange, but I have litterely created a new database from my "old" one. I did this because I thought the size of the database was growing way to fast.What I did was open two instances of Access, one with a new empty database open and one with the other "old" database open. I manually created all tables, queries, forms and code again by selecting everyting in design view, copying it, creating a new table/form/query/module in the empty database and pasting the data. After that I had to set some properties and it was ready to go. After compiling and compacting the new database was just 718kb in size. Empty that is. Then I added a couple of cases, compacted again, added some more, compacted again. (copies of the same data on different records). The same I did with the other "old" database.Both now have 12 clients with 2 cases (totalling 24 cases) every client and every case existing of the same data.The new database is now 1.120KB in size, the old one is 2.096KB. That's almost double. The only real difference between the two that I can think of is that one has a 20KB image tiled on the background of each form (the same image though) plus, of course, in the one database I've been designing, adding, deleting more.But how is it possible that these data sizes are so different? 100KB difference, ok. But almost double the size? How is that possbile and why? Are there things I can do to keep it at bay apart from using the Compacting and Reparing option? Plus: Is this normal?Edit: I emptied them. One is now 812KB in size empty, the other one is 1496 empty. Still... double the size. ?
View 5 Replies View RelatedHi, I'd like to know your opinion about the following problem :
http://img262.imageshack.us/img262/4256/toysmm0.th.jpg (http://img262.imageshack.us/my.php?image=toysmm0.jpg)
I'm given this table and I'm supposed to say in which Normal Form it is. I'm not sure but I guess in this specific case I need to consider both Toy_ID and Order_ID as primary key. Then one can see that Order_Date ist dependent on Order_ID but not on Toy_ID, then the table should be in 2NF, right ?
The table is not in 3NF because even though Producer is dependent on Toy_ID (at least I think it's dependent), City and Country are not directly but only transitively dependent on Toy_ID. Am I right ?
Thanks !
I currently have a database thats A Replica which I need to Convert Back to a Normal Data file, Is there a simple way of doing this other than creating a new db with tables then using Querys to add the data from the replica.
I'm using 2002 and the replica if sized around 470Mb with over 200 Tables.
also does anybody know if the file size for assess 2002 was incresed from access 2000's 2Gb.
thanks
mick
Hey folks!
A favor to ask: Pat Hartman posted an example db shortly before this site was attacked that dealt with setting up a form in a non-normal fashion to enter/display data that was in normalized tables. Did anyone download and keep a copy?
I downloaded it and was going to study it to try to build something similar for a lab application, but I lost my copy and can't get it back. A search here did not pull the post up, so I'm assuming the attack got the post, which was in the example DB section.
If anyone still has a copy, or if you see this Pat, would you mind posting the file again? I'd really like to study this one.
Thank you in advance.
Hi, i'm new here and I know there's a lot going on but i was hoping someone could point me in the right direction or give me a few tips...
I've imported a very large (nearly 15000 records) set of data into an Access database as one big huge table storing various bits of information about coins. As far as I can tell, the data is in at least first normal form, in that no multiple values are stored in any columns (not yet sure of the technical term - field?)
Anyway, I've managed to use a make table query to separate out some of the content of the table into separate tables with relating entities.
One question is, and please bear with me - How do I add an autonumbered primary key to these newly separated out tables and then add these autonumbered items to the original tables as IDs so that I can set up relationships? Is there a "proper" way to go about describing this?
The following consists of ALL the fields in the original table and how i've split them up by table:
STOCK
Group
ItemNo
ListNo
TypeCode
ActualDate
SortDate
CostPrice
SalePrice
Estimate
StockLevel
DateEntered
DateSold
Archived
Ref1
Ref2
Picture
Description
Cats
DenomCode
TypeCode
PeriodCode
ArchiveWhenSold
NotForSale
KeepSold
StockItem
Highlight
OnLists
OnWeb
Proof
DENOMINATIONS
DenomName
DenomCode
DenomHeading
DenomValue
PERIODS
PeriodName
PeriodCode
PeriodHeading
PeriodStartYear
PeriodEndYear
VARIETIES
Variety
The Variety field in the Variety table is especially problematic. There were 1259 varieties stored in the original table which are now in a separate Varieties table which is great. But how do i now add an autoincrement number and call it, say, VarietyID, but then link each Variety back to the main list of coins but replace the full Variety description with the newly created VarietyID?
If any of that made sense, i'd REALLY appreciate some wisdom here.
Thanks
Im sorry about the stupid questions!
How can I open a report in a view which will let me test my buttons? I only seem to be able to open it in print preview!
I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'
I must obviously be doing something wrong, can anyone help?
Hello All!
As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(.
So first question:
How can i do this with a code?
Second question:
What do i need to change on my forms?
Etc etc :)
Thanks alot in advance!
I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs).
The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done.
Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol).
Anyone shed some light on this? :rolleyes: :D
Simple question
Why do I have 2 Office Record locking, with different names. One is called Secured (which is ok), but the second one is called the same name of the Database. My database is running real slow. I have compacted and repair, but still running slow. I thought it might be the network, but when I open my old backups they run normal.
Any ideas?
Hi,
Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.
I have an Access Db that is not password protected, but is asking for a password.
It opens on any other machine fine?
I think my version of Access is playing funny buggers with me, any suggestions?
I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.
Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??
Your help on this obvious pointer would be great!
C
hi pals
i have set username and password for ms access file.
unfortunately i have forget that password?
how to crack that username and passowrd?
is there any softwares available?
i can easily crack the database pasword? but how to crack username and password of ms access file.
i have found a code that brings up a box when tab or clicking in to a box for editing as below:-
Dim strPassword As String
If InputBox("Please enter the password:") <> strPassword Then
SomeOtherControl.SetFocus
TextBox1.Locked = True
End If
its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.
How can i change it to its normal file format
I have built a database using Access 2010 using the 'web' format for the forms, reports and tables.
This has been fine so far as I have been using macros for my clickonevents.
However I now need some functionality not available in the web forms macro expression builder. Namely Openquery, (it is not on the available list). I therefore want to copy my forms formatting and properties to a normal non-web form allowing me to enter vba code.
Is there no way of doing this though - will I have to redesign the form again from scratch?
I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.
However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.
Any ideas how I can fix this?
Thank you
http://www.btinternet.com/~peter_paterson/Access/SubFormDesign.jpg
http://www.btinternet.com/~peter_paterson/Access/SubformFormView.jpg
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
In my form's text box I have noticed that I can;t write paragraphs ie use the TAB key to start a new line. If I use rich text I assume this will be possible. But are there any disadvantages to using rich text?
View 1 Replies View RelatedHi all
Firsty i am a novice to Databases so i only really know the basics, heres my problem.
I have a database at work that i need to password protect, but i want it so when people open it up, it gives them the option of viewing it in read only mode, but if they have the password then they can use it properly and edit things, is this possible? and if so is it easy??
Thanks everyone
Chris
Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?
View 2 Replies View RelatedHya.
In my database I've two diferents forms but I want one of them to be accessed only for few users where they have to type username and passaword.
Is anyone there could tell me how can I do that please?
Thanks
I don't realy know how to explain this but a college of mine has done something to her Access settings, whenever she tries to open a database it asks her for a User login password.
The prompt is a box with
Name: Centre Manager
Password:
If she types Centre Manager in the password box then it lets her in as normal. Everyone else can just access the databases without being prompted for a password.
Does anyone know what she has done?
A password to one of my MDB files has been changed for some reason and I need to get access to it. Does anyone know of a freeware program that I can get to gain access to it? Your help is appreciated.
View 2 Replies View RelatedI would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
Thx