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

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

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,


Read other 1 answers

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

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


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

Google: import access to sql server

Read other 1 answers

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

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

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):


DateVar Date;


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;


Any other suggestions

A:COPY FROM database TO database USING


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.


Read other 3 answers

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.

A:Transfer from Access Database to Access Database

Read other 6 answers

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

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,

A:I need some database help please

Read other 12 answers

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


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

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

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

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.


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

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

A:Database Help

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


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. . .



Read other answers


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.


Read other answers

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.


A:Immediate Help with Database

Read other 6 answers

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

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

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

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 .

A:[help] database ?

Read other 9 answers

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

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.

Read other 1 answers

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

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

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.


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


Read other answers

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


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

Read other 3 answers

Hello Guys, I am going to develop database software which will keep records of my school. Here are some hints

1- My school has multiple departments.
2-The items for database are pictures, word files, excel files and big collection of data entry as well.
3-Database will also convert records into MS Excel format as well.

I want help if MS Access is better for developing software or Visual basic will be better option. Thanks for help

A:database software

Read other 8 answers

i get this when i go to a web site
Database error

The database has encountered a problem.


Please try the following:
?Load the page again by clicking the Refresh button in your web browser.
?Open the home page, then try to open another page.
?Click the Back button to try another link.

The forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

A:help Database error

Do you get this on every web site you visit? or just some?

Also what version of Ie do you have? can you access any other programs that require internet usage?

Read other 2 answers

Hi guys. I've built a java application which uses the embedded netbeans database. I've got the basic operand of adding entries to the database sorted, but I'd like to be able to edit and delete them also. As far as I am aware, to delete an entry you would have to create a copy of the database with the entry removed, and then overwrite the original database with this new file. That all seems a bit dodgy to me! Is there any way of doing it a little more reliably?
Also, I have the program showing a view of the database on on the add data JFrame, which also contains the input boxes. Is it possible to somehow grab the data you mouseover from the database, and load it into the input fields, where it could be edited before being overwritten?
Thanks, and I welcome any replies.

A:Netbeans Database


Read other 1 answers

Does anyone known where I can find an up-to-date database of all existing harddisks sorted by manufacturer or type.

Read other answers


I don't know if this is hardware problem or windows problem...

While trying to install HP pcs 750 printer drivers on a KDS laptop running WinMe on a 800 MHtz pentium it took 45 minutes to compile the driver database instead of the usual 15 seconds.

Any thoughts???


A:driver database

Hi aconakc.......
Welcome to TSG.

You might want to take a look at this link from MS.....


and this is an article on the original cause.....


It might apply in your case. Let us know your progress.


Read other 1 answers

From my schoolboards website, www.ycdsb.ca, there is a link at the left that says "Students and Parents." From there, I clicked "student resources," and then clicked "secure login" (for students in high school). I put in the right password and ID, and it takes me to another page. "Welcome to the Secondary Students Resource Centreclick on the icons below." From there, I click the Ebscohost icon, and this is where I have a problem. Instead of taking me to the page where it is supposed to, I end up at another page asking for a password and ID. http://search.epnet.com/login.aspx?authtyp...custid=s1962673 It is only on my computer that I get this problem. It works for my friends computer, and the computers at school. It worked when I tried it last (on my old computer). I don't know of any settings on my computer that would cause this.Any ideas?

A:Can't Log In To Ebscohost Database

Any suggestions/ideas?
(Sorry if this is a bump, but its been almost 4 days )

Read other 1 answers


This is all very new but I think you lot could be my last hope. My company has asked me to build a database in Access and i have said 'sure, I can do that'. I know what tables I need I know how to add my fields and I know how to build a form. BUT I don't know how to put it all together. This is what I need to know and I help you can help me.

Call Log. I need to have a table within my form which automatically has the date and time when clicked into it. This table obviously has to be bound so that it shows contact for each record.

Link to a word doc. I need to have a button that opens a word doc specific to that recrod. eg: an employee record with a link to their cv.

Generate word doc. I have a client table, a job table, and a candidate table and I need info from each table to generate an invoice. how do I do that???

Link to Outlook Calender. Is this even possible????

I really hope you can help me, I need to get this done and don't have enough time to read a book on Access.

Thanks so much

Office Girl

A:Database hell!

Hello OG,

As one of the resident Access people around here, my gut reaction would be that you've bitten off a little more than you can chew (despair not--I tend to have the most pessimistic responses of the gang). Sounds like you want something somewhat sophisticated, especially where automation is concerned (Word and Outlook), and that not only do you not have time to read a book, you don't seem to have much experience using Access at all. It's powerful stuff, but it takes time to learn it, and short of building the application for you (speaking of lack of time...), I wouldn't know where to start, really.

Some pointers: Access online help is a must. They have introductions and so on which are more thorough than anything I can write for you. And then the sample applications, including Northwind and Solutions (search Access help for these if you don't know what I'm talking about). Otherwise, stuff from the MS Knowledge Base (aka Technet) such as relational database design and database normalization basics can help out.

But until you spend a little time playing around with the above elements and start trying to build your application, you won't know how easy or difficult what you're trying to do is. The thing that puts tables together, by the way, is called a query. And if you want a field which stores dates and times to automatically register at the moment you create a record, set its default value (in the table design window) to &quo... Read more

Read other 2 answers

I've recently updated my MS access database (with several amendments from Christmas cards) personal addreess book. Then a bunch of new mobile numbers for my mobile phone address book, and finally my MS Outlook list of contacts.

I'm sure I'm not the first to ask; but is there a universal database out there?

One that would require me to keep only ONE database that I could transfer between my laptop and PDA (email, personal addresses) and mobile phone (contact list).

Thanks in advance.

Read other answers

I am running a Lotus Domino 8.5 server on Centos 5.2 x64 Linux. The installation is on a Intel server with Adaptec RAID controller 1.7Tb and the Notesdata directory is on an external Dell PowerVault MD1000 5.5Tb with RAID 5 configuration. I also have LVM2 installed.
On Wednesday last week we had a power surge. I have 2 x 3KVA UPS installed, but for some reason the external Powervault RAID lost the connection to the hard drives. After i rebooted, i check the RAID BIOS and found that 1 drive failed and the RAID is rebuilding.
After the process completed, i started up the server. FSCK gave me error that the volume is inconsistent and i should run fsck manually. So i ran fsck -y /dev/VolGroup02-LogVol02
This ran for almost 10hours, and supposedly fixed hundreds of errors. Once the server booted up, the file system was mounted as read only. I tried unmounting and remounting the volume, also checked fstab for valid mount points.
fdisk -l stated that the volume does not contain a valid partition table. So i bought 3 x 1tb drives and started transferring the data. I cleared and re-initialized the RAID and created a new RAID5 config.
This time i created a GPT partition table and formatted the file system to ext3, transferred the data back using Krusader and preserved ownership and permissions.
I ran an offline fixup, compact and updall.
I then fired up the Domino server to find that my names.nsf is gone. So copied one from a backup server. On startup i found many errors about files... Read more

A:Why file is not a database?

This sounds horrendous. I'm at a loss on this one, if it's gone, it's gone, that's why I backup all my data to cloud servers with unlimited storage which are a foolproof backup system .Maybe the best way to go in future. Sorry bud.

Read other 3 answers

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


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

I was wondering what database software is the easiest to learn? Someone in my office learned Cold Fusion but we are having a hard time finding a server that supports it. So what could we replace it with? Hope this is enough information.

Read other answers

how to get table name from database to become a value of the combo box? n how to get the column name in the table that already selected become a value of the multiple-selection list boxes????

A:get data from database in VBA

Read other 7 answers

Hi, Does anybody out there know of a decent CD database program so I can put all my albums into it and print it off to show my friends?

I think i'm looking for somethind like a database where I can put the Band/Album names in and I can print it off with either the band names listed alpahebtically of the albums listed alphabetically?

I'm having a bit of trial and error on download.com. Got one which looked fine (CDManager3) but the print-outs came out all wobbly, so i'm still looking.


A:CD Database Program help

Read other 6 answers

Does anybody know how I can create a simple searchable database for about a hundred images, so I can just open the program or file enter a keyword and the appropriate image is displayed! I have searched download.com and I have microsoft access 2002 and the rest of the Office XP programs installed if they poccess this feature? Can Anyone Help?


A:Image Database

Try: http://perso.wanadoo.fr/myalbum/MyAlbum.html

An easy way with only a hundred images if they are in the same folder is to open one of them in Irfanview. Select File>Thumbnails and maximize the thumbnail window. It will create thumbnails of the entire folder. You can double left click on any thumbnail and the full image will open in Irfanview. You can store the thumbnails as contact sheets or HTML. You can store the entire folder as HTML but only a page of thumbnails at a time as a contact sheet. It would probably be faster to find an image with only a hundred to store a HTML thumbnail sheet of the entire image folder than mess with keywords and file names.

MyAlbum is more sophisticated but almost everyone already has Irfanview on their computer.

Thumbs Plus is probably the best image database but it isnít free like the others: http://www.cerious.com/thumbsplus.shtml

Read other 1 answers


Need to set up an SQL database and connect to it using Java. What software would I need for the database?

Will I need to set up an SQL server? What would I need, how might I do it? Thanks.

A:Setting up SQL database

You could also use something like MS Access or MySQL to use as your database. What exactly are you trying to develop?

Read other 2 answers

I am looking for the best program for writing stand alone databases. I am a beginner and am looking for something like Foxpro but a lot cheaper. I'm am tired of trying to connect to databases like Access and MySQL. I would like something that I can run right from an application. Does anyone have any suggestions? Thanks

A:Stand alone database

If your requirements are modest, consider the database features of 1-2-3 or Lotus Approach. If you need more power take a look at C++ Builder or Delphi.

Read other 2 answers

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?


A:Access Database

It may be the version of True Type Fonts that are involved, can't you just increase the column width slightly.
By the way you getter better responses for Access/Excel questions on the Business Applications Forum.

Read other 2 answers