lucyh
Last Activity: Jan 13 '11, 10:20 AM
Joined: Sep 9 '10
Location:
-
Thanks Colintis - this may well be the problem then. I will see about upgrading to Office 2007. Will upgrading affect any of my existing databases? Just want to check first as I have my big baby database that I have spent the last 6 years tweeking and poking on my lunch breaks and I worry about all things upgrading!! Lol - you hear sooo many horror stories about having to convert files after an upgrade :o)and with me being such a novice it doesnt... -
Thanks Colintis :o) - on my computer its Access 2000 and on the Vista its Access 2007. I went to amend a query in the design view while the Vista User was in the database and it took me a while to find what I was looking for as I have never worked with Vista before (told you I was unskooled lol).
Is it just the way Access is presented in Vista that would be different and how the programme actually operates?
The girl...Leave a comment:
-
Can anyone recommend any free online training that would take me as far as possible in learning about Access then I can be sure that taking on an open Uni course would be the next step. It would be my luck that I wouldn't beable to do the Relational Database Theory course as I don't have enough know how to begin with :o)
I had a look at the Relational Database Theory course offered by Open uni and it looks good, it doesnt state how...Leave a comment:
-
[Make sure the users dont have to make design changes. At my firm we was at the most 15 users on the same .mdb at the same time. No problem, with using it. But we had to convert away from relational tables and bound forms to non-relational (before query) and are now just using unbound forms with VB ADODB to make all table updates.]
I have relationships and subforms in this database - would they have any affect on sharing the datab...Leave a comment:
-
I saw your post and had hoped it was as simple as this :o) - I checked and the other two are opening the database in shared mode and still only one of them can be in it at the same time.Leave a comment:
-
I hope this makes sense Colintis - I looked at the Access properties on one of the other laptops (Vista) and it states Microsoft Office 2000. Opening the database on this laptop gives me the same response when I am asking for the database splitter - it wants the CD-Rom.
When I am working in design view on the Vista the whole layout for access is completely different so I had assumed this laptop had a newer version of access? ...Leave a comment:
-
I am still scratching my head over this. I can't install the wizard for splitting databases as we can't find the disk...joy!!
I don't really know enough about networks and all that jargon to figure out if the problem lies in there somewhere.
We are all operating different versions of windows - I was wondering if that would have any bearing. I am on
Windows XP Home Edition 2003 and the other two are on:...Leave a comment:
-
Thanks Lysander for your response :o)
I will have to take a look at Open Uni courses. I have been mulling it all weekend and think its worth looking at. I would have alot of studying to do though!!! Someone showed me the basics 10 years ago - "this is a table, this is a form and this is a report and this is a query". Since then any excuse in work to make a database..!!
Most things in access make some sense...Leave a comment:
-
A career in Microsoft Access??? what training??
Hiya - I would love to work self employed as a database designer, creating and maintaining databases for small companies.
I have never had any training in Access and am pretty much self taught at this point.
Can anyone recommend any training courses that I could take that would enable me to persue this career? I work full time so it would need to be online or parttime night / weekend college.
I live... -
Thanks for the responses. When someone is in the database you can see this as a lockfile is created, but still only I can access the database if someone else is in it..confusing me somewhat.
I went to follow the steps given by Munkee and joy of joys the Wizard for splitting databases isn't installed...I will see if I can install and then get the database split :o)
Can anyone recommend a good part time evening course...Leave a comment:
-
Sharing a Access Database over a network
I have created a database and it is used by two people. They rarely need to access the database at the same time.
I have created the Database as "Shared" but they are unable to open it at the same time - although I can open the database if one of them are in it.
Is this something to do with the network permissions? I have heard about splitting databases into front end and back end but have never actually... -
Calculations as a default value?????
Hiya - I have a table and in it there are two fields. One is called Direct Cost and the other is called Charge Out. I want the charge out field to have a default value which is basically the direct cost / 80*100.
Can this be done? I have tried all different ways of inputting this and I get the message "Type Mismatch".
Probably an easy one for you guys but I have only just started to venture into the world... -
Genius!!! Thanks NeoPa!! Always wondered what an update query was!! I'm self taught in access and slowly getting there!!Leave a comment:
-
Many thanks. Just to check though..there are other fields that have records with a null value that I wouldnt want to have updated to NA - would following the update query only update records within a certain field or would it update all field records within the table that had a null value?Leave a comment:
-
Paste into multiple records in a table?
I have a table which I have added another field to. This field has a default value of NA and although any new entries will automatically have the default value of NA, I need to enter NA in all the current records and there are 2047 of them. Other than copying and pasting "NA" one by one into 2047 records is there a quicker way to do this. I tried selecting multiple records in the table and pasting but it only pastes into the first record...
No activity results to display
Leave a comment: