Over 1 million tech questions and answers.

Database Help?

Q: Database Help?

Hello everyone, I am wanting some help on the best way to set up some sort of database/spreadsheet/form to help our business please. All we are wanting to know is if I enter a postcode it will tell me what agency it belongs to eg 7614 = Northshore. Is there a google form or programme that can do this ? Thanks

RELEVANCY SCORE 200
Preferred Solution: Database Help?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Database Help?

Read other 8 answers
RELEVANCY SCORE 41.2

I am just starting to us VB 2008 Express. There seem to be two different types of database I can create in it. I see something called "local database" and something called "Service-Based Database". Can you tell me what is the different between the two? I am developing the application on my computer now but I would want to have the database on the server after so multiple users can access the database. I most likely be using a web hosting company for this. Thank you.

A:Service-Based Database Vs. Local Database

A quick google search came up with this Adobe reader file which seems to have most of the answers for your question

Here is the link.

Also, to access and read this file, you will need Adobe Reader.

(Simply click the colored links to be re-directed)

Let us know if that is what you are looking for,

-Coolfreak

Read other 1 answers
RELEVANCY SCORE 41.2

Hi,
I don't support Access, nor have I been trained in it, but I've been asked if I can help in this problem.
An Access database connects externally to a SQLServer database at login time for the application. How do I find which external database they are connecting to? I know that there is a way to go behind the forms to see the source code, but I cant remember how to do this.
I cannot find an obvious User/System file dsn on the PC to give me a clue.
Thanks in advance
 

A:Accessing external database from Access database

Read other 9 answers
RELEVANCY SCORE 41.2

I can't figure out how to add a column to the right of all my data. I insert column, and it inserts a column LEFT of the column my cursor is in (the very last column). And I haven't figured out how to manipulate the columns to move them around like I can in Excel (which is still a hit or miss thing for me - anyone have the tip on how to do that, too?)

A:Adding database columns to the RIGHT of the last database column

For any curious, I did find a way... You have to open design view and add it in one of the blanks beneath your last entry.

Not quite as easy as just right-click > insert, but it works.

Read other 1 answers
RELEVANCY SCORE 41.2

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

A:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

Read other 1 answers
RELEVANCY SCORE 41.2

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

A:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

Read other 1 answers
RELEVANCY SCORE 36.8

I need to query a table in a database that I need to write to to determine what records I need to pull from the database I need to read from.
Example(This dosnt work):

DECLARE

DateVar Date;

BEGIN

DateVar := Select MAX(Invoice_Date) from write_To_Table;

COPY FROM read_database TO write_database INSERT-
destination_table (column_name, column_name...) -
USING select * from read_From_Table where invoice_Date > DateVar;

END;

Any other suggestions
 

A:COPY FROM database TO database USING

Hi,

What you need to do is:
- Connect to write_database.
Query the DateVar for your WHERE condition.

- Connect to read_database.
Query all the records what that you want to insert to write_database.
Then store the records to "ARRAY"

- Connect to write_database.
Insert your "ARRAY" to destination_table

I hope this helps.

Red
 

Read other 3 answers
RELEVANCY SCORE 33.6

I have MS Access 2000. I initially created a long book list several years ago. I recently found a template from the MS database for books that I downloaded that I like better. I have tried importing the data from the old database to the new one but with no luck. Both are in Access 2000. I am running Win2K.
Thanks
 

A:Transfer from Access Database to Access Database

Read other 6 answers
RELEVANCY SCORE 29.6

Hi every 1

we have an sql server 2000 it installed before 2 years on windows 2000 advanced server.Now it's database size is 4 gb.My pbm is that when i try open last month or last year record from client machine it takes 15 to 20 minutes to opening the records.during that time the client machine is busy fro 15 to 20 min.We can't do nothing till the operatin is completed.Also entries from client machine also working slow.After I shrinked and reindexing the database it working normal for 2 or 3 days.But after that the same pbm occured.Any way to permanently solve the pbm.When i want to see last years records it will show withing a minutes.Plz help me.

Tahnkx.
 

A:Sql Database Pbm

Hopefully, you know relational theory and have 'normalized' the data.
When a given table gets too big, a typical solution is to export portions into
new tables with a 'fixed value' column, eg: year. If the size of the year-table(s)
are still too large, the next solution is export into second database.

DBMS startups can be costly -- the indices get read and memory structure are build.
Primary index will have only one entry per row of the table (by definition).
Your secondary indices can have many entries per table row.

Consider DROPing all secondary indices (they can be rebuilt later) and restart the system.
If this has a major improvement, then you know that you should consider
which indices you actually need and rebuild each and restart to see the
impact. When it become 'too costly', the last index is your problem --
consider why you have it and how you use it.
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi crew!

I need some info:

In web development I came to line where I MUST choose which server side language to start learning... PHP or ASP (now ASP.NET option).
I know PHP is for all sistems and ASP is win based.

Also regarding databases:

MySql or SQL Server
...because What if database will have 200.000 or 1milion user. Just tell me where is BORDER when I should use SQL Server instead of free MySql?
Example if you will have more then 100.000 user then use SQL Server.
If belove 100.000 use MySql
 

A:PHP or ASP(.NET) ...which database?

Who is paying for the SQL server?

The license is in the tens of thousands per microprocessor. This include dual core microprocessor which have to pay double license.

It is all matter of your wallet size, fear factor, and CEO bias.
 

Read other 3 answers
RELEVANCY SCORE 29.6

Hi

I have recently created a database which contains data centred around projects. Sometimes these projects are carried out by one department and that's very straightforward but often they can involve 2 or 3 different departments. There are various types of testing within each department and each study. How do I go about setting up the database to take all this. I'm thinking that maybe i need to create a many to many relationship - is that right? If so this data will have to sit in a table outwith the main "projects" table. Will I be able to create a form where I can enter all the data so that the main project data (which tends to be fixed) and this multi test type data can be entered or will i have to enter it separately into the 2 different tables.

Jacki
 

Read other answers
RELEVANCY SCORE 29.6

Recently trying to clean off a server a database was deleted, before the delete a backup was made of it. After the database was restored, there was a excel document that used a vb button to refresh data, and now when you click it you get an error message.

could not find database id 13. database may not be activated yet or may be in transition.

also when you click debug the line it points you to is: rs.open sSQL, db, adOpenForwardOnly

This wouldn't be a problem with the vb, that hasnt been changed, what do i need to do with the database to get it working with this?
 

A:sql database

You need to look for the connection string in your VB code and that will point you in the right direction. Look for a db = variable in your code.

After restoring the database does it run and can you access it by other means like ODBC or SQL manager?
 

Read other 3 answers
RELEVANCY SCORE 29.6

Hi there,

i'm new to databased so i apologise if this is really easy.

i have a database where i have a department in 1 field, member of staff in another and a grade in the 3rd (ranging from 1-4). How do i get a query to add the amount of 1's then 2's etc per department?

Thanks for any help
Phil

A:Database Help

SELECT COUNT(grade)
FROM Department
WHERE Department = HR (for e.g.) AND grade = 1

I don't really get what you mean, so this query actually count the number of grade = 1 in HR department.

If I got you wrong, let me know and I can change accordingly.

Read other 2 answers
RELEVANCY SCORE 29.6

Hie everyone

Please help, I have to come up with a database of students that will be able to track the students' progress,i.e how many passed,failed, how many passed after first sitting ,after a resit etc. The thing is this has to be viewable(if such a word exists!) in a website sort of environment. People should be able to log on in some form of browser and still be able to view the data. am not a very advanced developer therefore need help with the following : Is there any application like I was thinking Visual studio or something like that where I can combine both web and data development in one? Or do I have to do the db and website separately then combine them later if so how????? Thanks
 

A:database help

Read other 6 answers
RELEVANCY SCORE 29.6

I am looking for some type of database that we can insert short filmed interviews into as well as pictures. Does anyone have any suggestions? Entering a new and different area for me. Any suggestions welcome.
 

A:Need database

Read other 9 answers
RELEVANCY SCORE 29.6

A few last questions...

How can I put a GUI for the many to many part of my database. Also how to get the multiple addresses to show on the form. You can download a generic vs of the database from http://forums.techguy.org/business-...ved-listbox-controlling-subform-access-2.html.

But I would also like to add, this isn't the version that will be the final, that is on another computer and there's already passwords and all sorts of good stuff on that one, so I really can't upload it, not to mention I don't have a way to transport it anymore lol My poor flash drive decided to die this morning.
 

Read other answers
RELEVANCY SCORE 29.6

I am a drafter and i would like to build a db for all the drawings in our system (aprox.5000). This would not have multiple access at one time. It would just be a local file on my computer. The db would consist of all the drawing numbers. drawing titles, revisions, revision dates etc... and each time the drawing is revised there would be a new description and project number added. I know that is a pretty basic overview but I hope it is enough. What I would like to know is what db would be the best for this.
 

A:best database

MS Access would suit your needs.
 

Read other 2 answers
RELEVANCY SCORE 29.6

Hi,
I have a large data base for which I have an excellent application search engine. It called AskSam Pro and is for PC only. What I need is something similar that will work on Mac platform. I need it to import & export form MS Word & other apps while keepig the format of the doc. Be able to search over the 800 doc (27MB0 by single word or phrase or boolean and show the list of docs by date and number of hits. VBe able to import & export individiual docs in Word. and do this with a free style entry form (in other words I can design the entry form of the documents to fit my individual needs). The app that I use cost only $100. But I can go higher if need be. It is VERY user friendly and has a low learning curve. That would also be good in this office as some peoplehave less than average tech skill.
Any help would be appreciated.
 

Read other answers
RELEVANCY SCORE 29.6

Greetings to all,

I'm currently having trouble with using Microsoft 2003 Database. I've got to do this task by 8am today, which is in 3 hours, and I'm stuck with this section of exercise from University.

I've also got a test based on this in 4 hours, so I'm gonna need a quick asistence on this one as soon as possible.

Task is this:
"Currently, when you select the Video Code drop down box to enter a new rental, all the possible rentals are listed. In this section, you will limit the list to only videos that are able to be hired.

1. Select the Row Source property of the Video_Code in the Video Rentals subform. Cick on the ellipsis and as you do you will invokde the query builder on the Video table.

...so on."

I cannot find the ellipsis or Row source property in the subform section. I could possibly post the data up, etc but that'd be too confusing. Guiding me with some screenshots would be wonderful.

File is downloadable at: http://www.yousendit.com/transfer.php?action=download&ufid=45E9288010A1E3F5

The section I'm stuck with is in the 4th page of the pdf file, could be also called page26 at the bottom of the page.

If anyone could possibly help me directly on MSN, that'd be just amazing. I also might need more extra help later on, so if anyone free could help me on MSN, would really apprciate. Note: Got to finish it in 3 hours.

Regards,
Maverick
 

A:Immediate Help with Database

Read other 6 answers
RELEVANCY SCORE 29.6

Hello .
i hope this is the right place for my questions ..
here we go .
I have a huge music library that i have been putting together for about 24 years . its just outta control stuff all over the place . cd's , vinyl , 8 tracks , cassetts ,minidiscs , mp3's, ect...
on the otherhand I have a nice "LOG"i have been working on of 1 genre - the name of the artist , album name , release date ..
i have been working on that for quite sometime .. now i would like it to be searchable ..
basically have all the artist names , album names & release dates stored into a file.
what i would then like to have is a user interface to be able to search an artist ..
and then display the results ..can you programm masters send me in the right direction so i can make a nice searchable "Database" i guess its called ?
thanks a million .
MGT :
 

A:[help] database ?

Read other 9 answers
RELEVANCY SCORE 29.6

Could you help me answer this one: What are some disadvantages and advantages of hiding complexity from the user of DBMS
 

A:Database

If this is for a test I choose A, none of the above.
 

Read other 3 answers
RELEVANCY SCORE 29.6

I have all my customer information in a database program called Maximizer CRM 11.
I inherited this info from another worker.
I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I import this to a new Access database?
Is it a seamless transfer or is there more I need to know to accomplish this?
Thanks for your help with my project.
 

A:Database help

I am sure it can be done, but you need to know what the relationships are between the different tables in the CRM so you can replicate them in the new database. If there are forms you will also need to replicate them on your own to display and manipulate your data. There is a lot more to it than just importing the data.
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi everybody I am looking at making a new game and I need a database software to store all the information I need to be able to make the game I am just after a bit of information on the best type of database software to get

Thanks for any help
 

Read other answers
RELEVANCY SCORE 29.6

hello,

i'm doing a database project where i need to create a initial window for user login form with user name and password, for which i have decided to use a graphical password(that is, clicking a set of consecutive areas in the picture will determine the password).
i'm using oracle 9i as a backend and c# as my frontend. Is there any provision using which i can implement it easily. . .

thanks

techian_cool
 

Read other answers
RELEVANCY SCORE 29.6

I don't really understand how databases work. I'm learning ASP, and I know it's very good at reading and writing to databases, but I have no clue how to set it up to do so. I don't have a database set up or anything, and I don't know how to set one up. Any help appreciated, or tutorials. Thanks!!

Sorry about being so vague.
 

RELEVANCY SCORE 29.6

How do I clean out all the files in My SQL Database that I am no longer using?

TTIA :)

Read other answers
RELEVANCY SCORE 29.6

I can't access my Act database from other accounts other than my Admin account. I keep getting an error of: dependentdlls.xml is denied. What do I need to do to make this accessable on other screens?
 

A:ACT Database

It is a user permission problem, the link below from the software maker should cover it.
http://itdomino.act.com/act.nsf/c8a...59b993f8dae43f810725718d0068b09f?OpenDocument
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi all,

I have a project at work that is still in its planning phases, and I just want to understand what I'm up against.

We have a huge RedBrick database that I am going to have to run custom SQL queries against to produce some ad hoc reports for our business execs.

What tools do I need or should I ask for to accomplish this? The only SQL experience I have is running queries against a local SQL Server db from the SQL Server enterprise manager. So connecting across the network is new to me, and I don't have SQL Server available to me as a tool. Can I accomplish what I need with MS Access?

The engineers gave me the information I need to set up an ODBC connection, but I'm not exactly sure how to go about doing that. Do I do that from within Access? Where does my login name and password for the database come into play in setting up an ODBC connection?

Lastly, the schema for this database is friggin' HUGE!!!! There are approx. 58 tables in this db with millions of rows in each table. I've never constructed a SELECT statement for a schema quite that complex. What is it going to look like?

For instance, the db's name is usage. It has tables brand, customer, sku, contract and advertiser in it (for example). What would a query to pull all rows from those tables look like?

Thanks in advance for all your help,
Richard
 

A:I need some database help please

Read other 12 answers
RELEVANCY SCORE 29.6

I need Someone to Help Me To creating Access Database for my company
 

A:DataBase

That's pretty vague, any more details? If it's a complex or important database for company use you may want to hire a programmer that will provide continuous support, updates, and troubleshooting.
 

Read other 1 answers
RELEVANCY SCORE 29.2

--------------------------------------------------------------------------------

Hey i need some help with a project i have for work.

my boss wants a type of program set up that controls our stock and products.

In this program i want to be able to input product codes categories invoices suppliers stock on shelf and stock on order and maybe a few similar things.

do u think microsoft access will be able to help me create this? or is there another program out there that will make it easier to do?

please help i havent started it yet just trying to educate myself as best i can and everday my boss asks how its all goin.
 

A:database help access 03?

Access is perfect for this application.
What kind of products are you dealing with?
Do you "Supplier" lists?
Do you have more than one Supplier for items.
Is the stock used within your area ie by yourselves rather than being sold to a Customer?
Do you want Categories and Sub Categories of stock?
Do you have "Re-Order" levels? (Minimum stock when a new order is required)
 

Read other 2 answers
RELEVANCY SCORE 29.2

Hi,
I am in need of a online database to keep track of all of my company's contacts. The company has 7 employees that would need access. I need to easily send out email blasts and print mailing labels. Some sort of email tracking data would be helpful as well. And of course- I am looking for something free or inexpensive
Thanks for any help!
Maggie
 

A:Contact Database

Read other 9 answers
RELEVANCY SCORE 29.2

WORKS SPREADSHEET QUESTION:
:
I'm trying to figure out a way to use it to catalog my collection of 78 RPM records, but am stumped. Basically, I want to be able to sort them by record company, or title, or artist. each data field (think that's what its called -- I'm totally unfamiliar with spreadsheets) would contain, at minimum, something like this, but would have room to expand a field if needed to get more data into it re a disc or the performer(s).
:
DISC 1

TITLE: "Espagnol Waltz"
Performed By: Samuel Siegel
Instrument: Mandolin, with Piano accompaniment.
Recorded: Probably May, 1903
Company: Victor Talking Machine Company
Label # 446
Master / Take # If known: 446 / 3
Comments: Disc title is announced as: "Waltz Espagnol, Mandolin Solo by Mister Samuel Siegel".
:
On some disc's, the master / take field may have 20 to 24 letters & numbers in it.
:
But I cant get enough column width to type the info into A thru K. & have came to a stop.
 

A:Works Database

Read other 6 answers
RELEVANCY SCORE 29.2

What is a good product or language to create quick database forms and access for a web site?
 

A:web database interfaces

You could use Active server pages or XML for example. It really depends on your requirements and what you want to achieve.
 

Read other 1 answers
RELEVANCY SCORE 29.2

ok , i finally got a site , with some ex. for loading jpg into ACCESS,

http://members.tripod.com/accdevel/imaging.htm
http://www.lebans.com/loadsavejpeg.htm
ok now without eating any1's head, i have to create a small catalog, with itemcode and pic of the item,both have to be related ,so tha I can search , for itemcode adn get the picture....

now both of above ex. codes are free and can be changed, so any1 cna help me out here,who konws access in advance , modify the scripts above if they can , so taht I am asked for like item code and pic.......

!!!!!!
 

Read other answers
RELEVANCY SCORE 29.2

say i have 1field with range of 0 to 99
i need to pick out a range between 14 to 20.
anyone able to help with what commands to use.
i set the starting point ie. sDD>='14'
but nto sure how to cast the eDD to 20 so it only read from the database in the range of 14 to 20
 

A:how do i get the range from 14-to-20 from SQL Database?

sDD>='14' LIMIT 6;

Is that what you're looking for?
 

Read other 2 answers
RELEVANCY SCORE 29.2

Hi,can smb help me with sites that have tutorials about the relation of vb.net with access databases or sql databases.
Thanks
 

Read other answers
RELEVANCY SCORE 29.2

I have this access database that I from another user which I want to customize so that I can use it. The form has about 28 records with a yes or no fields. Now what I need to do is add more records as I have stuff to add that will require the user to ans. with a yes or no answer. My problem is that I am unable to add more questions (lines or record). Is there a way to do that?
 

A:Access Database

Read other 8 answers
RELEVANCY SCORE 29.2

I have an access data base program that we use as our special orders program, we use to be able to have more than one person log into this, but now only one at a time is able to.. The file is shared for all users.

thanks.
 

A:Access database

Read other 10 answers
RELEVANCY SCORE 29.2

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

A:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

Read other 2 answers
RELEVANCY SCORE 29.2

I need help in creating a database that can be searched.

3 Items are needed...

A 2 digit year entry
A 6 digit numerical entry (need to be able to enter less digits)
A 4 digit numerical entry (need to be able to enter less digits)

I need to be able to search the 6 digit number and have it tell me what 4 digit number is associated with it.

I am hoping I am making this clear...

for Access 07 or 03? (the previous version)

TIA

Tom
 

A:Access Database

Read other 16 answers
RELEVANCY SCORE 29.2

Ihave oe6 with winxp pro.

I get email responses to me on an issue and I have a message rule that puts them into a folder. But I can't get at the email addresses. I read the oe help files but can't figure how to get these emails in a way that I can use for later mailings to these people without having to go and cut an paste into a list. I know it is probably easy but I can't figure it out. thanks, frank
 

Read other answers
RELEVANCY SCORE 29.2

I found out that I can't mount my .mds files. Then, I suspect that it is because my .mdf files are now associated with my SQL Server 2005. Meaning, the icon is the icon of the SQL Server program. But when I tried opening it, it gives me the "Open With" window.

How can I make it a "alone" file? (The icon is just a white page).

A:SQL Server Database associated with .mdf

Quote:





Originally Posted by cazua


I found out that I can't mount my .mds files. Then, I suspect that it is because my .mdf files are now associated with my SQL Server 2005. Meaning, the icon is the icon of the SQL Server program. But when I tried opening it, it gives me the "Open With" window.

How can I make it a "alone" file? (The icon is just a white page).




What do you mean by "alone file"?

And right click on a .mds file , Properties, General, and next to "type of file" click on CHANGE.

And then scroll to the desired program you want to associate the file with and then that program will open those files.

Read other 2 answers
RELEVANCY SCORE 29.2

I am unable to pen my database. It gave me an error message saying it is corrupted. I tried to do repair it but I was unsuccessful.

HELP
 

A:Access Database

Don't you have any Back-ups?
Try opening a "new Blank" database and on the Main Menu, File>Get External Data>Import and then point it the corrupted file just to see if it can be opened that way.
If it can then on each set of Controls (tables, queries, forms etc) click selct all and then OK
 

Read other 1 answers
RELEVANCY SCORE 29.2

Is there a way to get a time stamp on an entry in an excel database worksheet? I'm using excel as temporary database and wanted to get formula that would automatically fill a cell with time stamp when making an entry in that row (record). Thanks!
 

A:Excel Database

Read other 11 answers
RELEVANCY SCORE 29.2

I have windows XP and usually have no serious problems. Right now I'm under a real time crunch to print mailing labels and I can't get merge wizard to read the necessary database properly. All I get is gobbledegook. I've used the same database for this many times with no problems. I can't bear the idea of retyping all that info for 150 people!

I know that isn't much info, but I don't know what else to tell you.
 

Read other answers
RELEVANCY SCORE 29.2

I have installed ACT database 2007 version 9 on my computer. I created 2 databases already and I would like to share them with my co-worker.
* Both my co-worker and I run on Windows XP Professional
* Both my co-worker and I have installed the ACT database software on our computers
* We have a shared documents drive that's based on my computer (meaning that when my computer is switched off, my co-worker does not have access to the shared documents). She has access to all the documents I save in the shared folder and vice versa
* When I started the databases, I saved them unto the shared documents folder thinking that this way, she will be able to access them without any problem
* Also, when I created the databases, I checked "yes" when it asked "do you want to share the database"
* When my co-worker goes to the Shared docs and tries to open one of the 2 databases i created, ACT automatically opens the demo database
* When she opens ACT, and click on file - open database, and choose one of the 2 databases, this error message appears:
" The database USclients could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software on your computer or the server"

Would anyone know how to fix that?? Thanks much!
 

A:ACT Database - how to share?

If you have the database, and you need the other user to be able to access when you system is off, you'll need to set up synchronisation - try this http://tinyurl.com/34u7xz
 

Read other 1 answers