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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The question is,

How do I get a database (Access) to tell me when it has a new record?

I want to be emailed when a user has completed a form which is then sent to a database to be stored. Do i attach a cgi code to the submit button so when the user clicks two operations happen at the same time (cgi email and insert database record), or use some form of code that will make the database tell me when its got a new record? With either option, please tell me !!!

I'm using ASP/VBscript.

Thanks for the help ! ! !

Spu
 

A:How do i get a database to tell me when it has a new record?

Personally I would include some script in the asp page that your form calls on which would trigger the email at the same time as it does the data insert. I cant quote the code off the top of my head but I seem to recall it's fairly simple.
Cheers, Bob
 

Read other 2 answers
RELEVANCY SCORE 29.2

I recently made a copy of a database, then secured the original. Everything went fine and the "new" database works well with passwords, etc. But this new one is 18,600 kb larger than the original. Anybody know why? Everything appears the same as in the original.
 

A:Shrinking database?

Read other 7 answers
RELEVANCY SCORE 29.2

Im needing to print off labels of a set size from a database but i cant get it to work.

I have the database saved and i want to mark so many of the items to print off labels for without printing all of the list. Ive tried marking the few i want, hideing the rest and then saving as a new document and then importing the saved database to a label section in Ms Works task launcher but it still brings up all the labels in the complete database. How do i get it to print off just the few that i highlight?

Also the database shows a ? sign on the screen but does not print one on the label or show one in the header box at the top of the page if i click on the price box. How do i get it to print a ? sign on each label?

It probably sounds a bit confusing, but its even worse trying to get it to actually print the right thing.Any help much appreciated.

A:Stuck With A Database

Ive just found out that the database was created in works 98 but the labels are to be done in office 2003. Are the two programs compatable or will the database have to be re-done in office 2003 for it to work??

Read other 8 answers
RELEVANCY SCORE 29.2

What exactly does database tracking refer to? My web search came up empty
 

A:Database Tracking

Usually it means that the database is set up to keep a log of who and when any data is entered, changed or deleted.

Most database development software offers some level of automated tracking. Some of these are harder to use and some are easier to use. Sometimes, the database developer will opt to write his own tracking code and will set up code and tables in the DB to log when transactions occur, and who performed them.

We once put tracking code in a DB because the users weren't very savy and kept making mistakes, then when the output wasn't what they expected they would report an error in the DB code. We instituted tracking so we could tell whether there really was a code error or simply an user data input error.

Tracking can also used to monitor data entry accuracy and speed and to discourage and trace the entry of fradulent transactions.

Tracking is also used to resolve the transactions between a master database and distributed database replicants.
 

Read other 1 answers
RELEVANCY SCORE 29.2

Hi,

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
RELEVANCY SCORE 29.2

If one were to endeavor to become fluent in one of the most in use database software programs, which would one chose to maximize chances of employment?
Access? Oracle? DB2?
Thanks and have a good one!
 

A:Database question

they all have there place dont forget about SQL
have a look at some of the jobs advertised - do you want to be a programmer or DBA
 

Read other 3 answers
RELEVANCY SCORE 29.2

i am creating a database app. i would like to create a dropdown list of all the available fields in a particular table for the use of filtering data (adoObject.recordset.filter). i know that i want to fill the dropdown list in the form load event but i'm not sure how to get or retreive the available fields to fill the list. i have been able to fill lists with info from any one field, but i would also like to fill a list with all the available fields as well. anyone have any suggestions for a beginner such as myself???
 

A:database fields in vb 6

You need to use something like this:

Private Sub Form_Load()
'Create the recordset
With MyRecordset
For intField = 0 To .Fields.Count - 1
Combo1.AddItem MyRecordset.Fields(intField).Name
Next
End With
End Sub

This uses the fields collection of the recordset to populate the combobox.
 

Read other 2 answers
RELEVANCY SCORE 29.2

Hello,

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
RELEVANCY SCORE 29.2

Can anyone tell me how to set the print area in "Database"? I want to print a form which shows lots of names down the first column, and then has a blank "Signature " column next to it, but with horizontal gridlines to take their signatures.

When I look on "Print Preview" it only shows the "Names" column, and I can't get it to print a column next to it. If I remember corectly, there is a facility in Excel for this, but I can't find it in the Database application.

Any help would be appreciated.

Thanks.
 

A:MS Works - Database

Read other 6 answers
RELEVANCY SCORE 29.2

Hello there,

I am running Windows XP PRO SP2 and am having a problem with alot of things on my PC. Most of my services have been stopped when looking at msconfig screen. When trying to go to my Administrator Tools under Services, I try to "start" a particular service and get an error stating: Could not start the Remote Procedure Control (RPC) service on Local Computer. Error 1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

I also get other errors like: Could not start the Background Intelligent Transfer Service service on Local Computer. Error 5: Access is denied. When trying to open the database of the Service Pack Files using the Security Configuration and Analysis it tells me that the database is corrupt. For information about fixing the db see online help. Unfortunately I do not have the XP startup disk. I'll never let that happen again!! However, as of now, no disk, only floppies copied from the www.tinyurl website. Can anyone out there help me on this? Microsoft has tried 2 times to try and help me out with no success yet. Even they are stumped as to how to fix my current situation w/out the startup disk. Let me know what more info you need from me re: my pc, etc, etc.

Thank-you in advance for your assistance.

A:The Database Is Corrupt

What sort of computer do you have, processor, ram, hard drive, etc.

Also are you running anti-virus, anti-spyware and firewall programs? If so what are they?

Read other 2 answers
RELEVANCY SCORE 29.2

I installed the game Maple Story on this computer, since it's about the same specs as the other one I use, but when I start it up, the Search function comes up and says that the file "Database" is missing. Anyone know how to fix it?

Also, wasn't sure if this went in the games forum or XP, but this also happened when I tried to update Directx, so I put it here.
 

A:Cannot find Database?

Hi mate!

The best place to post your question would be the games section of the forum. So you may want to repost there for more help.

However, since you already made a post I suggest that you uninstall maple story and delete the folders it created. Then try reinstalling it. I guess that the installation became corrupt somehow. If you have time try re downloading the maple story installer and reinstalling from there.

Did your problem start after installing DirectX? This could be just a coinsisdence, you can get the latest DirectX from Microsoft's website and reinstall it as well just in case.
 

Read other 3 answers
RELEVANCY SCORE 29.2

I have a working Access database on a machine running WIN XP and MS Office 2003. I transferred that database file to a new machine running Vista Ultimate and MS Office 2007. When I try to open the database on the new machine, I get this message: missing reference dao2535.tlb. How do I resolve this?
 

A:MS Access Database

Open your database.
Hit Alt+F11.
Hit Tools-->References.
It would seem it's missing from there.

See:
http://support.microsoft.com/default.aspx/kb/824259
 

Read other 2 answers
RELEVANCY SCORE 29.2

Hi,
I have an MD who has finally got round to asking for an old database be brought into the 21st century.

It was created/written back in the days of windows 95 and works 4 etc, in DOS, from what I can gather the program works extremely well for what it is supposed to do, and from what I can fathem out, the main files(s) are in a .DBM format.

DBM I believe is database manager - the file(s) are 1.05MB and 1.425MB's in size, from what I have determined, the option to save in a format like de-limited text (CSV?) is not possible.

The question - is there a recomended software that can read this format and then convert it to CSV so that can be transfered to excel then on to access or any step in between, the PC is so old that the only way to remove the data is through a 3.5" floppy disk or manually input via screen to screen or print a hard copy (vista pc's will not network through to this compaq through it's network card, nor have I tried to fit a usb card - on a 3/4 full 600mb hard disk there may not be sufficient memory to allow for any additional equipment).

Would I need to move the whole program including the bat file or could I just use the .DBM file?

any thoughts would be appreciated

phil
 

A:legacy Database

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

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

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...
http://www.adlandia.dk/amazon/windows/access-uk.htm

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 1 answers