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

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

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


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

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

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

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

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

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

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

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

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


Read other 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

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


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


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

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

I am using a form to enter data that is updated to table. The problem is that the calculated fields in the Form do not update in the table while everything eles does. Can anyone help please.

A:Access Database

Generally, calculated data isn't stored in tables. There is no need for it. If you calculate data, you use it in queries or reports . . . when you create a report, you base it on your query, not your table.

Read other 1 answers

The company I work for is trying to get a very simple database set up with Excel documents that we currently use. My boss is asking me to do some research and I'm not sure where to start. We know what we want it to do, but I'm not even sure what to google. We're looking for companies in the area and trying to get proposals, but what kind of company does this sort of thing. Any help?

A:Solved: Database Help

what is you are trying to do - it would be useful to havedetails of what you expect the database to be able to do and what info to provide to the business

Read other 2 answers

Can anyone recommend some software i can use to open/edit SQLite 2.1 database's?

Preferably Freeware or shareware seeing as i dont need to do this often enough to invest money into it but if there is no such thing (as google has repeatedly told me) then i guess any other recommendations are greatly appreciated also.

A:SQLite 2.1 database

Read other 6 answers

Hi there,

Anyone know of a good book that has all(or close to it) of the database commands that Access 97/2000 would use?

Just a good reference for query commands, misc definitions and terms, ect ect.
Thanks for any input.

A:Database Information

This looked interesting...

Brainbench MVP for Microsoft Word

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


We are having trouble opening a program called visual dbase by borland. On a computer operating with the windows 98 operating system. I have tried to reinstall the program, and install the file that is missing and i am still getting the error message. The error message is as follows the driver file ntdps2 is not found. Is there someway to fix this?

A:database program

Read other 7 answers

How can I export records in database to print mailing labels? or get the database to print them?

A:Works database

don't have works anymore (like a looong time ago) but since it's an Office-Lite product hopefully there's some similarities

maybe try the help feature for:
mail merge

in the database and word processing software (it's likely the same help file, so it may not matter)

here's the detailed FAQ page and
here's one about works 3 and creating labels

sounds fairly similar to the office procedures

good luck

Read other 1 answers

I hope someone could help me, I am looking for a simple database for a sheep herd operation that will incorporate jpeg as well as text. Simple is the optimum word. Thanks very much

A:simple database

Read other 6 answers

Is it at all possible to convert a word database to outlook? (Office XP) Any feedback would be appreciated.

Cordially, Nick

A:converting a database.

There is no such thing as a word database, Word is a word processor. You can however import delimeted text files into Access and other databases. Once they are imported however it is up to you to set relationships between tables and set the table field up for the data contained in them.

Read other 2 answers

Hello all,

I am an intern at a nature center in southeast Wisconsin. Our organizations focuses on environmental education and outdoor recreation. As part of that mission, we have rentals available for skiing, snowshoeing, canoeing and kayaking.

Currently, renters must fill out a paper form to rent our equipment. The amount of rentals makes it difficult to quantify how many rentals we have as well as how much money we are making form it.

My question is this: can anybody recommend a free or cheap program that can create a database for our rentals?

1. When customers rent from us, we have a program that is constantly open. They input their names, age, as well as address. They then hit "enter" and it is inputted into a database.

2. There is a timer on their file so when they return we can see how many hours they owe for.

3. If people return to rent again, we can search their name so that they do not have to reenter their information.

4. The information is entered into a spreadsheet or something similar that allows us to quantify our rentals.

Any help is appreciated!

A:Rental Database

Read other 10 answers

Allow me to preface this question with a back story so you, as a reader, do not think I’m a neurotic freak. I’m incredibly organized, and love lists. I find them rather fascinating for some reason. Don’t judge me, please. Now on to the mean and potato, I like to keep a spreadsheet of the movies that I watch followed by the date watched, and a star system. One star either means the movie was terrible, or I could not finish the feature. Two stars means I was not pleased watching the movie, or it just was a poor film. Next, three stars is I liked the movie, but it wasn’t special! Continuing on, four stars represents I enjoyed the movie and probably would watch it again. Concluding, five stars represents that the film is a favorite and would certainly watch the film again! I would like to make a database of the movies while adding the genre so I could easily find the movies and also add in movies I would like to see as I see them advertised. How would one go about constructing this? Any tips?

Thanks for your time!
PS: I was not exactly sure where to post such a topic, but it seemed feasible to place it in this location.

A:I want to Make a database

Read other 7 answers

hello ,

now time for some logical thinkings ,

I used to have a small simple database , which Is becoming complicated day by day
ok the database is , ITEMCODE , Description , Picture , Supplier
picture contains the location of where the .jpg picture is stored on the hdd , then in forms and reports i use vb and pictures are loaded in a window from the location in hdd.

Now u c the problem comes , is suppose when I have a COLLECTION of an item , the collection is on a board , coz the collection itself has it's item code , then the items inside have their own item code , to solve this wat i did was create another table called collection item , then using relationship i was able to link the tables , so i in myh itemcode table i get a minus sign on a collection on which when i click , all the items inside appears....
this table is filling very fast and has alrady got some 3000 records

so wat I m worried , is WILL the size affect the database , i mean , will it slow down , right now it's working alright , without any problems

I use queries to generate reports ... say from particular item code to particular

Right now the size of the access datafile is 30 mb ...... So does access has any limits or something ....

Is there any other program which will allow me to do the same , but instead of one big file , it breaks em up , say tables r stored as diffrent files , reports are diffrent files or overall speed is not affected...

A:Database questions ???

Read other 6 answers

I'm trying to create a couple of databases and need a recommendation for the program(s) I should use. I'm a beginner.

Database 1: A PROJECTS DATABASE with fields such as: name of project, department, status, etc. I want to be able to report to management at any given time on the various projects we're doing: those that are complete, in progress, not yet started, and provide various metrics to them on the projects.

Database 2. A SPEAKERS DATABASE that I want to use to "match" incoming requests from outside organizations for speakers. So I need to house the speakers' contact information, expertise, rating, etc.

I'm aware of: Access, MySQL, or SQL, Filemaker Pro, etc. I own Access.

Should I do it myself or have someone else design it? Should I start with Excel to lay out the fields that will be needed? If do-it-yourself, are there any easy templates or tutorials you can recommend?


A:Database Advice

Read other 16 answers

I am working on a database for our Ambulance Company. One of the fields I am having trouble with is writing a formula to calculate response times when time enters another day.

Example, we use military time therefrore, 23:59:00 would be 11:59 pm. If we run the call till 00:10:00 ( 12:10 AM) the formula I have written ( = Arrival Time - Responding Time) gives me an invalid time because it doesn't recoginize I have gone past the current day into the next day.

Please help me figure out how to formulate this field.

Thank You.

Brett F. Murphy,
Paramedic Supervisor

Warsaw - Lincoln Ambulance District

A:Works Database


Working With Overtime Hours In Excel will show you how to write the formula in Excel.

It should work in in Works, but am unsure, as I do not use Works.

Read other 1 answers

can anyone please help me with some information on database connectivity. i am developing an e-commerce system and i would appreciate some guidlines on what packages to use and what should be used to connect the database to the webpage. I am thinking of using access and dreamweaver any suggestions

A:Database Connectivity

Access is not really powerful enough to run a web database. So unless what you're doing is quite small and low-traffic, I would suggest against it.

Beyond that, you have a huge range of choice. I'm a fan of php/mysql, and it's certainly one of the industry standards, but I don't do a lot of web db developing, so I may not be the best one to answer you...

Read other 1 answers

HI I have recently started doing a diploma in web design, im currently learning how to write and EXECUTE Queries. I am doing an assessment and having a few problems that nothing I seem to be trying is working.
how would I
Create a stored procedure called Task8 that will list the product name and quantity in stock for all products that have a stock level less than 20.

Create a stored procedure called Task13 that will accept a parameter called ID of INT type. This stored procedure is to produce a list of Category Names from the Category table based on the ID parameter to be used as the DepartmentID.
any help would be greatly appreciated, im still having alittle trouble getting my head around the computer coding.

A:SQL Database managemet

Sorry, we have a general rule about not assisting with homework questions therefore I must close this thread.

Read other 1 answers

Hope you are doing well,
I need a help in access database, im completly new to access
We are mainitain a record in excel, but that should be maitain in access 2007.
Please find the attached excel sheet with header and the data (Eg) related to the header.
Can anyone make it in access database with the designs.
Forms should also have the search,save and clear button.
Please let me know if you have any questions related to above.
Many thanks in advance for your work,

A:excel to database

I have created the Access database and created/imported Table, query and Form for the Excel data.
How do you intend importing the rest of the data in to the Table?

Read other 3 answers