Windows Support Forum

Get Access to import from DOS database ??

Q: Get Access to import from DOS database ??

I am trying to help a person stuck with an old 1980s DOS database program called "SMART". The program SMART will output its database in a format that Access should be able to read, but Access can't seem to completely read the output database from SMART. Anyone run into a situation close to this?

Any ideas on how to solve this?

Relevancy 100%
Preferred Solution: Get Access to import from DOS database ??

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 (This link will automatically start a download of Reimage that you can save to your computer.)

A: Get Access to import from DOS database ??

Any chance of posting the "output" file from the DOS program?
What output format is it supposed to be?
Have you tried opening with Excel instead?
Relevancy 62.78%

Is there a driver that will let me import this particular database into Access 2003? I have tried all of the native ones in Access with no luck so far.


Relevancy 62.78%

I m not a new into old database an Solved: Import one??? sure if this is even possible but if it is I haven t figured out how to do it I created a very simple database Solved: Import a new database into an old one??? with Access on a Windows XP computer just to get one person up and running quickly created in like minutes Now that I have had time to go back Solved: Import a new database into an old one??? and make it better I have tried importing the new version into the old database with the hopes that it would replace the old files with my new ones but instead it kept everything I changed the original table information a litlte and its name and I Solved: Import a new database into an old one??? was hoping to just have it disappear when the new one was imported like installing updates I also added more objects We re not on a network which would certainly make this a little easier and I m trying to avoid having her send me her copy of the database which she has been adding data to so that I can import it into the new tables I guess after that I could just send her the new version and have her just delete the original one Any thoughts would be greatly appreciated TIA nbsp

A:Solved: Import a new database into an old one???

RIBuckeye, welcome to the Forum.
Yes you can Import the new database, but no it won't replace the original Objects.
If the only changes that you made are to Queries, Forms & Reports you can manually replace the originals.
The new versions will have a 1 added to the end of the name, if you rename the object and remove the 1 it will ask if you wish to replace the origianl with the new one.
However you have vhanged Tables you will probably have to delete any Relationships and then reset them afterwards.
The normal way to do what you want is to Import the Original Database in to the new One and use Queries to Append the old data to the new tables.
Relevancy 61.92%

Hello Tech Guy I have recently received some of your expertise and I was more than pleased so now I m going to ask you once again I am working on making a database for customers Example in the sheet quot Database quot Now the idea is Database at import Solved: Lookup new that every few months we will import a new list of all of our clients from our accounting system and import this list into Excel This list will have Solved: Database Lookup at new import the same data in the corresponding columns However some clients may have switched name date address att or anything else except for ID New might also have been added or old might have been removed Now what I need for this workbook to do is the opportunity to click a button after copying in new data in sheet quot New Import quot this button could be in the quot Results quot -sheet and then it will run a search and give a third sheet with results where you d be able to Solved: Database Lookup at new import see rows with the same ID which doesn t have corresponding data in all columns where the old data will be coloured but both represented in the result sheet Also make a list in the result page of both new ID s and removed ID s so that you can add them to the list I d like for a button to appear next to each of these lines saying quot Behold quot which would import that line of data into the database and delete the other entries for the same ID See quot Customer Database quot as an example quot Database quot contains the old data quot New Import quot contains the newly imported data quot Results quot contains the resultpage also an example of how I d like it to look excluding the buttons Looking forward to your assistance Enehasd nbsp

Relevancy 61.92%

I have much digital data in my computer, I want to import them to database. I want to convert PDF to Excel and then import it to database. so which converter can preserve the original data well?

Relevancy 61.49%

I need help importing text database (for mailing lists) from ACT 4.0 to Excel 2000. However, I do not have ACT application on my computer, and am not able to work from the other (second) computer - person is using it all the time. Could someone help me with this, step by step somewhat. Should the person I'm doing this for save ACT file: on CD; could they email it to me, also?

Thanks for any help.

A:ACT 4.0 to excel 2000 -can i import text database?

Hi, and welcome to the TSG forum

can they export as a csv file (comma seperated)
then its simple
you just open it in excel.
Relevancy 61.49%


Does anyone know how to move a Microsoft Access Database file to MySQL database server?

I found one tool it's called Navicat

but i'm not sure it's good to use it yet.

Please give me some suggestion.


A:Import MSaccess file into Mysql database

MetalRooster said:


Does anyone know how to move a Microsoft Access Database file to MySQL database server?

I found one tool it's called Navicat

but i'm not sure it's good to use it yet.

Please give me some suggestion.

ThanksClick to expand...

I never used Navicat. Instead I use SQLYog (click to get a free version).

I still have a old version of MS Access. I proceed this way to transfer the data to MySql :

- with access, I export the needed tables into .xls files,
- with Excell, I convert the .xls files into .csv files,
- with SQLyog, after having create the tables structures, I import the .csv files.

It's very easy to use.
Relevancy 59.34%

Here's the question- how do I open a form in an existing database from another db in Access 2010 using VBA and give it focus. I can open the external db and it's form but cannot figure how to give it focus. I'm trying to create a master form that will call various databases that each have a form. Seems simple, open the master menu, click on a button that then opens the called db and the associated form. Do my business exit the db and am back at the master form. I would be okay to just close the master db, all it has it the main menu or leave it open. Doesn't matter which I just want to open the called db and form and have its focus.
Relevancy 59.34%

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
Relevancy 59.34%

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

Relevancy 59.34%

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.
Relevancy 56.76%

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.

Relevancy 54.61%

Hi there I don t have enough experience in VBA excel or word and would you mind helping for the following Q The below macro code add row below the last row And Would Data to sheet as Form Excel data doc as Import Entry database from word you mind telling me what is the Import data from word doc as Data Entry Form to Excel sheet as database code that can add row for word document table between the last row and the row before the last ActiveDocument Tables Rows Add Q My second question is related to export import between two different programs or files Excel and word document Would you mind providing me the proper code for Wordtable copy Workbook xls - sheet past speical value Suppose the word tables excel workbookD sheet are as follow Table in word document -------------------- Cell - Cell Cell - Cell -------------------- Table in Word document ------------------------------------ Cell - Cell - Cell Cell - Cell - Cell ------------------------------------ WorkbookD xls Sheet Rows Column A B C D wt Cell WT Cell WT Cell WT Cell WT Cell WT Cell WT Cell How I write a macro to make the value or text in Cell in word table to be copied and past in Cell A in sheet of WorkbookD xls and the value or text of the range from Cell to Cell of table or word doc to be copied and past in sheet of WorkbookD xls from range B for n rows in table and table of word doc Thanks Hamdy quot nbsp
Relevancy 53.32%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!

Relevancy 52.89%

According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through to many Access upgrades?

A:Any problems using Access 2007 database with Access 2010?

Hi bbinnard,

If you have not purchase Access 2010 yet, what I'd recommend the Trial Version and play around with it for quite a while.
Relevancy 52.03%

Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.


Relevancy 52.03%

Is it possible to convert an Access 2000 database to Access 7.0? I have an old machine that I would like to run a database on but it only has Access 7.0 for WIndows 95.

Relevancy 50.31%

I am trying to import an excel file into Access 97. One of the fields contains acct numbers that can be either all numbers (i.e. 349854694) or combo of alpha and number (i.e. EB~943590834). When importing, if the first record is a number, all the fields that contain the alpha values fail the import due to type conversion failure.

Does anyone know how to tell Excel to not assume a datatype is numerical on import just because the first field is a number?

Relevancy 50.31%

Is there a way to import selected records (the ones that you enter for that week) from access into a excel spreadsheet (it is a large database has over 4000 records and more data gets added to it weekly)?
This is an on-going montly process, does anyone have any ideas or suggestions for an easier way, if any?

Thanks in advance for the help.


A:ACCESS/Import q?

If you're trying to get the data out of the database, create the query. When you know you've got it right, change it to a Make-Table query (from the Query menu in Q design view). Then run it. Then, turn it into a Delete query, and run it again. Open the table you made, hit File-Save as and choose files of type: Excel worksheet. Once you've exported, delete the table.

Of course, if you don't want to dump the data, just copy it into Excel, just create your query like normal, run it, and File-Save as an Excel worksheet.
Relevancy 50.31%

Hi everybody I have a problem with my MS Access and can amp t use the wizard for creating database objects forms report table queries etc Whenever I choose Wizard option to create those database objects I get the following error message Microsoft Access can amp t find the wizard or there is syntax error in the Declaration section of a Visual Basic module Wizard Can't access Access MS database The wizard you need may be missing from the libraries key of the Can't access MS Access database Wizard Microsoft Access section of the Windows Registry To make sure that the wizard is in the Windows Registry run Setup to reinstall Microsoft Access and the compile all Visual Basic modules in the database I reinstalled the MS Access as instructed in the message but I don amp t know where to find and compile those Visual Basic modules I also don amp t know how to get to libraries key of the Microsoft Access section of the Windows Registry I tried to reinstall the software by using two different versions of software CDs MS Office and XP and both failed to solve the problem I also tried unsuccessfully to access Add-Ins feature from the Tools menu in order to add the missing component Please help me ishak nbsp

A:Can't access MS Access database Wizard

Funny I had the same error last night. I ran Setup from the CD (from RUN prompt) checked off the access wizard. Then went and did what I was doing, it still asked to install the feature but it worked that time.

If that does not help the is an MS article, basically, if you are in "Break mode" of a module that could also cause it.
Relevancy 50.31%

Ok I have one more question-a few people have other versions of Access in my program and need to use the database that I created in Access 97. A few people tried and couldn't open it. Is there an easy way to converting this so they can use it on their computers? Thanks for the help.

A:Access 97 database in Access 2000?

Access should prompt them to either open the DB file or convert it to the newer version on startup. If it doesn't you can open the newer version of Access and go to Tools > Database Utilities > Convert Database.
Warning: Everything in your DB may not convert properly so be ready to do some work if this happens.
Relevancy 49.88%

Hi All I've got an interesting situation that I'm hoping can be resolved I built a server using FreeNAS to store family pictures videos music and Windows backups Import Denied" Access "Access User Though to Has NAS Error Pictures In my home we have Windows Home Premium bit and Windows Professional bit The server is setup with Windows CIFS Shares One share for each of the two computers and then a common share for multimedia Import Pictures to NAS "Access Denied" Error Though User Has Access The user accounts on the NAS belong to the common group quot family quot The Multimedia share has ownership user group of root family The permissions on the directories in the Multimedia share are read write execute for owner read write execute for group and read execute for everyone else or in the nix world Sorry for the long setup explanation Anyway on my computer Professional and my wife's computer Home Premium I see the shares in Windows Explorer Network I am able to access the shares and the first time I accessed I was prompted to enter user credentials which I did along with checking the box to have the credentials remembered So now when I access the shares in Windows Explorer I have immediate access I can read write delete whatever through Windows Explorer On my computer I was able to easily transfer my iTunes library to the Multimedia share through the iTunes application and iTunes now sees all of my iTunes media from the NAS rather than local On my wife's computer I am having a problem with pictures I was able to easily move all of the GB of pictures from my wife's My Pictures directory over to a Pictures directory on the Multimedia share I then went into Windows Live Photo Gallery and added the Pictures directory on the Multimedia share as part of the library The pictures on the NAS show up just fine in the application I then went to set the Multimedia share Pictures directory as the Default Save Location and I received an error that stated that the directory could not be set as the Default Save Location as it was Read Only However I had just transferred files to that directory So I copied over some other files just to make sure and I had no problems reading writing deleting from the directory via Windows Explorer If I set the Pictures directory on the Multimedia share as the target for importing pictures from the camera I get an Access Denied error when trying to import However I can import the pictures to the local My Pictures directory and right after the import I can use Windows Explorer to move the pictures over to the NAS without so much as a hiccup I have done some searching on the Internet but thus far I have not found anything that resolves this issue I have tried using the Windows Library Tool application to add the Pictures directory on the Multimedia share to the Windows Pictures Library and to set that as the Default Save Location This does set those values and I can see all of the pictures on the NAS in the Windows Explorer Pictures Library Also Windows Live Photo Gallery now has the NAS share as the Default Save Location However I still get the quot Access Denied quot Error when trying to import pictures to that location I have also tried setting the permissions on the NAS Pictures directory to or read write execute for everyone but that didn't help Does Windows utilize some other account that may not have access to the stored NAS credentials for accomplishing some aspect of the picture import process I have used Task Manager to view the running applications with Windows Live Photo Gallery and the Camera Import application running and I see my wife's user account listed for those processes I'm sorry for the long post but I wanted any reader to understand the setup and what steps I have taken thus far I would appreciate any insight

A:Import Pictures to NAS "Access Denied" Error Though User Has Access

So have you tried setting the permissions using the Security tab rather than the Sharing tab? Often times you need to set the permissions on both of those tabs in order to have complete access. The link below shows you how.

HDD sharing
Relevancy 49.88%

Help! I'm trying to import a .txt file that uses ll and l as delimiters, but I cannot separate the fields of unequal sizes into individual fields for sorting and printing. It is a voter list that contains 20,000 names and lots of extra data. All I want is address list for mailing purposes. In Notepad all the data is visible, but not organized.Field2
|04RME2977000|ABAJIAN |MICHELLE|R||373||SOUTH MAIN ST||018104873||||||U |F|04/29/1977|01/05/2004|0|7|6|28|1247|A
This is the data for one line. How do I format the data when importing. The wizard doesn't help. I have a record layout for the extraction but don't know what to do with it.


A:Import .txt file to Access

If this is a one off type of thing, could you just find and replace the double pipes with single pipes? You might have to do it a few times to accomodate blank fields.
Relevancy 49.88%

I recently tried to import data from a spreadsheet in Excel to a table in Access, but the Import Dialog Box does not list Excel as a File of Type available for import. Yet, I know that spreadsheets/Excel is a file of type from which data can be imported into Access. How can I fix this?
I'm working with a 1997 Access application.
Thank you.

A:Access-Import Dialog Box

You didn't install all of the converters. As a quick workaround, try copying your data in Excel and pasting it into a blank Access table.

Brainbench MVP for Microsoft Word
Relevancy 49.88%

I am attempting to build a macro to import a specific range of cells from Excel into MS Access. Is it possible to import the range A3:A7 from excel into column A of access, then the cell A8 into column B. It would also be from a sheet within the excel sheet named "Selected users". The added twist to it is that there are multiple excel files to import from, but the ranges will all be the same.
I know this is a very specific question but would anyone have any VBA code to support this action.

Thank You,
Relevancy 49.88%

I want to import data from ODBC to an existing table, I did not find how to do that. Each time I choose the external data it's create me a new table with an increment like account1, account2

How should I do that?

Thank's in advance
Relevancy 49.88%

Im trying to use i believe DAO from an access database into Excel The database far as i know was created in Access on the same Excel Trying Access into Import from to server that im trying to run Excel on and everytime i put in the dang connection string i get an quot unrecognized database format quot error This is driving me mad I want to read the database and start Trying to Import from Access into Excel scrolling through records and pulling in only the data i want into specific cells I ve done this before and never had this problem Basically the user will put a date in a cell Then i want to start reading records and everytime i find a certain value in a cell i need to pull parts of the record into cells in a worksheet then move onto the next record on that date But i can t get past the damn connection I have the Microsoft DAO object library and the Microsoft Office reference and nothing tried on different versions of excel and i get the same message regardless Any ideas hints suggestions Code Sub CrankUpdate Dim db As Database rs As Recordset Dim R As Integer C As Integer Set db OpenDatabase quot W WORK ORDERS accdb quot Set rs db OpenRecordset quot Talisman quot RecordCount rs RecordCount For R To Next R End Sub nbsp

A:Trying to Import from Access into Excel

I am not familiar with how Excel 2007 talks to Access 2007, but in earlier versions you could either Copy & Past Special Link to a database query or create an Excel Query.
Or you could use DDE (Direct Data Exchange).
Relevancy 49.88%

What I have done is combine the Order Entry, Inventory Control and Customer Management databases together in Access 97 and Iím trying to get them to work together to be able to update when inventory comes in and goes out of my business.

Iím trying to figure out how to complete the actual receipt of merchandise on a purchase order in the database. I want to put in the current date or earlier (I may use yesterday's date when I finally get around to entering data) as my variables for the timing to update the inventory transaction table (units received and units on hand fields).

Can you give me the operators and operands in the expression builder and the complete proper syntax that I would need to tell an event has happened and to update the table.

Thank you in advance - you guys are so good!!

Relevancy 49.88%


I have a DB that I did. It works fine except when I click on a cancel button on a text box and then it gives me the error shown below. Im totally lost as to why its doing this. If anyone can help I would appreciate it. Even just pointing me in the right direction. I posted it as a zip file on this site

the password is horror (and sorry for subject matter of horror movies)

A:Access Database

Listen...I looked and can't find anything wrong with it. I recreated the button (find by director), and it appears to work fine...just tells you the macro has been cancelled.

This isn't the first time I've been unable to find something wrong with something in Access...I'm pretty sure it's not uncommon either.
Relevancy 49.88%

I have this access database that I got from another company and I would like to use it but I would have to customize it to fit my needs. Is that possible

Relevancy 49.88%

Hi, i'm new for using database (mic. access)
i hope u can help me.
i'm currently developed a database using microsoft access. the database is about an insurance company. i need to do a database that store the unit manager, agen, client, policy and proposal.
i had build the table and relationship. i also had input the agen and unit manager (UM).
but what should i do now.
i need to separate each agen according to the um and also the client.
i also need to give output so that when i insert um code or agen code, user can see the client info, or the agen info.

please.. i really need your help...

Relevancy 49.88%

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.
Relevancy 49.88%

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.

Relevancy 49.88%

I have created a tracking program using access the main tracking page contains name address phone numbers computer information etc I also have two fields that I insert the problem and then the fix then that is printed out to give to the customer whenever the customer brings their computer back in for service I do a search for their account and it brings up all the pre existing info There last problem and cure are still in there I access database would like to find some way if it s possible to make this dump the items to a database for each customer in case I want to go into it again and look at past events Then the next time I open their account the problem and cure fields are empty but their data past problem and cure will still be in there I almost have this program or database to where it will do everything that I want it to do Any help would be very much appreciated Thanks chad nbsp

Relevancy 49.88%

ok , i finally got a site , with some ex. for loading jpg into ACCESS,
ok now without eating any1's head, i have to create a small catalog, with itemcode and pic of the item,both have to be related ,so tha I can search , for itemcode adn get the picture....

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

Relevancy 49.88%

I have two separate access database files that I cannot access. when I try to open either one it says unrecognized database format. When I tried to compact and repair, it says the same thing. how can I get back into these databases?
Relevancy 49.88%

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual have the form blank..when entering the that you can just 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).]
Relevancy 49.88%

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

3 Items are needed...

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

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

I am hoping I am making this clear...

for Access 07 or 03? (the previous version)



Relevancy 49.88%

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.
Relevancy 49.88%

Hi i created an access database for students that keeps track of their personal information as well as a monthly evaluation that they have to fill out, however i do not know how to create a button that i can place on the form that can allow the administrator to go to each student by either last name... sort of like a search engine. I don't know how to do this though, as well as just making a query that only gives me information for just 1 person and i don't have to manually put in the information in the criteria.. this i would also like to make a button or something of that sort..

please help!!! I'm close but no cigar!

Relevancy 49.88%

Hi all,

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 have expanded the column widths in design view and still the problem persists. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?


Relevancy 49.88%

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

Relevancy 49.88%

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual have the form blank..when entering the that you can just 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).]
Relevancy 49.88%

I have an access database, one of the forms I am working with has a subform. I want to be able to print part of the main form, and parts of the suboform. I can do this by inserting the form key number and the subform key number, then it prints what I want. What I am looking for is to be able to be in a clients record and push print and without having to enter anything it prints the fields in the form and the subform that I have in a report. I hope this makes sense. Is there a macro that I can put together to do this?

Thank you in advance for any help. .

A:Access DataBase

The simplest way although it may not seem like it, is to do the following:
Create a Join Query that includes both tables/queries (whatever your using), and create Joins on the 2 Key fields (related), this query should then become the control source for you report.
Now in the new query go to the field that contains the data you will be selecting on the form. eg the ID for the Main form

In the criteria row right click and select Build, find your form and find the Id field control name. The syntax will be:

Now if you don't already have one, place a button on your form that opens the Report or query, it should only display the records for the selected records.

This called "Filter by Form"
Any problems let me know I or some one else can walk you through, it works I use it all the time.
Relevancy 49.88%


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

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

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

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

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

A:database help access 03?

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

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


A:Access Database

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

Hi,can smb help me with sites that have tutorials about the relation of with access databases or sql databases.
Relevancy 49.88%

I have a database where I enter part number description, and cost. I also have another database that is updated all the time with this information in it. I would like to be able to link or however you do it. I would like to lets say put in the part number and then when I push enter or tab the description and cost field populates.

any help would be great.

A:access Database

you can link by selecting the table tab in the DB window and then click NEW followed by selecting Link. Then search for your other database and select the table you want to link to.

You will now have access to all the fields, it is the same as a table now except you may have sharing issues if the table is opened on the source DB.

You can use this linked table just as a regular table to make reports forms, queries etc. so you may not need the table you created with the same information as it is redundant.

So you can make a form with your linked table with a combo to select the product.
I don't know to what degree of detail you want or how much you know so if you need more help just post back.
Relevancy 49.88%

We use Accessdata base to keep track of all our orders. All of sudden two days ago, I go to the "main switchboard" and I get a blank order entry form. In that form, there is a small clickable box and when I click on that it says "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find. *** The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. ***There may have been an error evaluating the function, event or macro."

I have no idea what this means. Please help.

thank you,

A:Access Database - HELP!!!!

The first thing to try after taking a backup copy of the Database is a "Repair & Compact" of the current one. You should open Accees, not the database and then choose Tools>Database Utilities>Repair & Compact. Choose the current database to repair and Compact and save it under a new name. Open the newly named, repaired database and see if it still has the same problem.
Relevancy 49.88%

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


Relevancy 49.45%

Hi all,

I am having troubles importing a fixed length ASCII text file into access 2007. Here is an example of a file I'm trying to import into a new table
Bunny Buggs 19300215
Doe John 19791205
Rubble Barney 19500914

Last name and first name fields are both 15 characters long and import fine. The date filed is 8 characters long in the CCYYMMDD format with no date delimiter. In the advanced portion of the text import I have specified Date Order of "YMD", I have four digit year checked and I have the Date Delimiter field empty. This used to work perfectly in Access 2003 and will not work in 2007.

Any assistance anybody could lend would be most appreciated!


Relevancy 49.45%

Hi, can you help me with the same problem?

I have to import data from Outlook to Access (Already done that) then I have to separate each value into a separate column. Here is one example:


The values are separated by ; semicolon. I know that in Excel we can do it with "Text to columns" function, but I need to do this frequently. I read that you can do IT in VBA, but I don't know how to do it.

Thank's in advance for your help.


Relevancy 49.45%


I am trying to create an import spec for a tab delimmited file, however, the spec doesn't really "take" in the code. The file can be manually imported easily, but when I try to attach it to a "on click" evevnt, the table imports like junk. Any suggestions? I have checked my three reference books as well as the online help and can't figure out what is wrong.

Also, I am trying to repeatedly copy a table and add a date onto the end. So for example, the query looks like this:

Select tblActiveProds.* INTO tblActiveProds '" & strTblDate & "' FROM tblActiveProds;"

I can't get the date to concactinate on the end. Any suggestions there would be helpful as well. I tried the rename command as well, but found the same issue.

Thank you,

Relevancy 49.45%

I have been using Access version 2 for many years, importing the same excel
spreadsheet that I update monthly. Lately Access has been giving me an
error message saying the spreadsheet format is bad. I have always had to
store the spreadsheet in an older excel format to allow the import to
Access. I have the same problem with Excel 97 and Excel 2007. I am
running XP with all the current maintenance. Access seems to work normally
( at least for the limited functions I use) other than the Excel import

As further clues, I have only recently begun using Excel 2007, but when I go
back and resave the sheet with the old excel it still doesn't work.


Relevancy 49.45%

This happened after upgrading OS from W2k to Win Xp Pro. I have checked, there is nothing disabled within Access and I have reinstalled Access 2003. Have totally uninstalled the Office Suite and Re-Installed, installing all parts and running Office Updates. This happens with any database and any Excel spreadsheet with data The Error code reads:

"Microsoft Office Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled."

There were no add-ins and I'm not sure where in the registry to check for an incorrect setting (or what the setting should be).

Any help would be greatly appreciated.

Relevancy 49.45%

I receive an e-mail daily with a pipe delimited body like this:


Which I append to an Access database table :

Field 1 | Date | Field 2 | Field 3 | Field 4

Is there a way to run a macro that appends the body of this e-mail into a table in access? I'ts pipe delimited and the table is setup properly. I hate copying and pasting into word, saving as text file then importing that way.

Every time I link from Access to an Outlook folder it just puts the whole body of an e-mail into one field (up to 255 characters).

Thank you for any help.

A:Import from e-mail body to access

Can you forward me a sample email and I'll play around with it? Email to rollin_again at hotmail. I'll also need to know your database name, table name, and table structure (field names, etc.)

Relevancy 49.45%

Hi I ve got a DB that works like this I export about tables from Access to Excel Each table will be exported to one worksheet in the same file Then I update the data in the worksheets without modifying the field names Finally I want using Access to Excel Import from code to import the data in the Excel to Access I could use the Import function in Access but it would mean I need to Import from Excel to Access using code perform the import action times I found a line of code that looks that it s what I need but how do I modify it to tell it to import the correct worksheet into the correct table I m really a novice at this so I would appreciate if you could use the following example For example tbl and tbl is exported into the same file A and Import from Excel to Access using code worksheet is names tbl and tbl How do I write the code Line of code I found DoCmd TransferSpreadsheet acImport acSpreadsheetTypeExcel quot Import quot Me txtFileName True Thanks a million nbsp

Relevancy 49.45%

Hi All I am working in Access I am importing a text file import txt and saving specifications Once I get the txt file imported I run the following queries cRQs in N A P Status Yr End CONVERT dates within the txt file Converts the text dates to mm dd yyyy cRQs in N A P Status Yr End APPEND Appends the converted dates text file to the main table I had to add Import Solved: 2003 Access another field to the main table to hold the dept names I also Solved: Access 2003 Import have the main table so that once the dates are converted I can change it from a text to a date filed cRQs in N A P Status Yr End ADD depts Updates the added filed with the department names which are based off of certain characters in an ID field This is a reoccurring function What I want to happen is the following When the database opens Delete old data in all main tables being used Import all txt files using proper specifications Convert date field within txt file Append to main tables Add depts I want this to happen as soon as the database s main form is opened Within these processes not have to have the user select Yes to proceed with any query actions Can t this all be put in a code I want to make this program less user interaction user friendly as possible Am I asking for too much Can someone give me some suggestions please Thanks to all nbsp

A:Solved: Access 2003 Import

Yes it can all be done using the "Opening Form's" "On Current" Event Procedure.
See the Visual Basic Editor "Help" (Not Access Help) and look at
TransferText Method
to import the file using your Specification
Docmd.OpenQuery Method
to run the queries
and finally
Set Warnings
to turn the warning of and then back on.
Relevancy 49.45%

Hi Guys,

I have an Excel template called "Cash Amounts.xls" in drive c:\test\Amount and
an Access database called "Cashdatabase.mdb" and an Access query called "CashMTM".

I want to press a button in Excel which imports the Query from Access to Excel.

I know how to import a Access table into Excel with VB & SQL,but not a query.

Has anyone got an easy example of code I could use for this?

Cheers Justin

A:Import an Access Query into Excel via VB

JCutcliffe, welcome to the Forum, you would have had a much quicker response to your question if you has posted it on the Business Applications Forum, as most Access/Excel programmers don't check this forum very often.

Can't you just Copy/Paste Special/Link to the query?
Or it can be populated form Access.
Do you really have to use Excel, why not do what is needed in Access?
Relevancy 49.45%

Is there anyway to enter data in a form online, then have code to retrieve data from the form?

Thank You in advance,

Relevancy 49.45%

Hello, I am using Access 2000 and have created a database with a command button that opens up a report via a macro. I would like to know how to open up single reports instead of pushing a button that brings up every report, I've been able to open up reports that are based off of queries, queries that have paramenters that need to be inputted in order to bring up single unique records, but I would like to be able to just create a button that brings just that particular unique record-report off of that particular unique record on that form. Meaning that for a record that had just been inputted for John Doe on a form, I would like to know how to create a button on that form to pull up John Doe's single report without having to build a query that asks for a parameter. Is there anyway to do this?

A:Access-Printing a single report off of a single record from an Access database form

You will have to adapt this to your own form setup; but it's just using the Where line of the OpenReport macro action.

If on the form MyFormName you have two controls called txtFirstNm and txtLastNm, and in the query underlying the report you have two fields called FirstNm and LastNm, you would put into the Where line of the OpenReport action:

[FirstNm]=[Forms]![MyFormName]![txtFirstNm] And [LastNm]=[Forms]![MyFormName]![txtLastNm]
Hope that helps.
Relevancy 49.45%

I have an access 2003 database that calls a VB6 module. The module starts and then I get a run-time error 75 path/file access error. I can execute the vb module outside of access but I have to run as administrator for it to work correctly. What can I fix so that the call from access will execute? I believe the issue is with comctl32.ocx and the status bar control inside the vb module.
Relevancy 49.02%

I'm trying to import a database to an existing database. Both are identical, aside from their WO_NUM field, which distinguishes each record (and is primary key).

I have enough information in the database fields to make the database I want to import match. The problem is that the database is not allowing me to manually enter data. When I try a manual increment of the WO_NUM table, I am getting the following message:

ODBC-call failed.

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UC_TASKS_WOID_1'. Cannot insert duplicate key in object 'TASKS'.(#2627)[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. (#3621)

Any help is appreciated. Thank you.

A:importing database in access

I'm assuming you are importing the tables, it seems like you are importing the primary key also, that will cause a problem because there will be duplicates.

You can try dumping the table into Excel and strip off the ID column and then import the excel table or Paste it into the table. Access will create new ID's for it.
Relevancy 49.02%

hi all,
i would like to ask for database performance :

currently i split my ms access database to front end (form interface) and backend. the backend file i put on shared folder on dedicated pc, which i assume as server. the database then access by 10 staff, which having the frontend file on each pc. the backend file was ~20MB in size.

there's an option, which is upsizing the backend to be sql. then install ms sql server express 2008 r2 on "server" pc, then host the backend file and modified the frontend file so, it'll access the backend database on sql connection.

is this will increase any performance from current setting?

thank you.

A:Database - MS Access Backend vs MS SQL

Hi there
probably not the answer you are looking for but if you use MySQL (FREE for non commercial users) you will improve your DB performance compared with MS ACCESS by literally ZILLIONS of percent.

It's slightly more complex to get up and running but there are tutorials all over the web.

Beats running a "cut down version" of ms sql too.

Incidentally MySQL in combination with Apache, and PHP makes a great WEB server too (WAMP). Also compatable with Linux where the same combination is called LAMP.

Relevancy 49.02%

Is there a way to check or uncheck references using code in Access?

I have a database that will be opened by Access 2003 or 2007. Both versions will need to be able to use the Access Reference "Microsoft Outlook 11.0 Object Library" or "Microsoft Outlook 12.0 Object Library".

Relevancy 49.02%

Hi Everyone I have a couple of questions that I hope someone can help me on with Access I am Creating Database Access an shall we say quot very beginner quot I think I did ok for the small stuff but there are a few problems that I m having also I have a few questions for some other tables forms amp reports that I would like to create Question on the form I keep Creating an Access Database getting this error message when I use the switchboard to use this form quot The field project information Project Name can not contain a NULL value because the Required property for this filed is set to True Enter a value in to this filed quot I have cheeked everywhere I know to find it but I do not see it anywhere If I just enter it the information in the spreadsheet it will do fine but it won t let me use the form Question can you send an email to alert someone from access I want to set up a form for ordering amp if there is something that we do not have I want to be able to send an email to the person responsible for that product to let them know we need it Question is there somewhere I can get live help with Access database to help me through this Thanks in advance for your help nbsp

Relevancy 49.02%

I have a database in access that I am trying to send to Excel. One of the fields within the database contains about a paragraph of text. When I send it to Excel, I am losing a portion of the text. Any idea how to change that? I have resized the excel cell and that did not work.

A:Access Database to Excel?

Microsoft Excel Specifications (Excel Help) gives the following limitations to field contents.

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar Click to expand...

Any greater than 32,767 and you will risk losing them in the conversion, but if its just a para or two you should be fine, but you will see it truncated, with the rest 'hidden', so to speak. Its an inbuilt limitation I'm afraid. You could try splitting the contents to an additional field, though that could be messy to look at and manipulate.

Relevancy 49.02%

Trying to open a report with criteria based on input boxes on a form Want to open the report based on a name and dates cboAMName - The name of my combo box where the Account Manager Name is gotten txtSD - Text box where the start date is entered txtED - Text box where the end date is entered I have tried the following combinations without success docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between Where Clause Access Database quot amp me txtSD amp quot And quot Access Database Where Clause amp me txtED amp quot Statement Access Database Where Clause docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot Without the WHERE docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot Without the WHERE with the docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot nbsp

A:Access Database Where Clause

Ok, I got the first part of the where clause working but cant get the second part working

Here is the code I currently have:

part1 = "([qry_Transaction_Defect_Report]![AccountManagerName]=" & Chr(34) & Me.cboAMName & Chr(34) & " )"

part2 = "AND ([qry_Transaction_Defect_Report]![TransactionDate]) BETWEEN (" & Chr(34) & Me.txtSD & Chr(34) & ") AND (" & Chr(34) & Me.txtED & Chr(34) & ")"

whereclause = part1 & part2

DoCmd.OpenReport "rAccount Manager Feedback Report", acPreview, "", whereclause
Here is the error message I am recieving:

Run-time error '3071':
This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
Relevancy 49.02%

Access database not opening completly

I have a user that is having Microsoft Access 2003 issues. There is a database created for this base only but here is what is happening.

He moved from one building to another. At the first bldg. he had all rights and access. He moved the same machine to another bldg. and tried to log on. He was able to log on but he is unable to access certain parts of the database. We have changed his permissions so that he has full permissions and we have changed the macros to that it is low. When that didn't work we reloaded Office. None of that worked. Some things will give him an "open report error" but on others it won't give him any errors at all. It just dosn't open. Any ideas?

A:Access database not opening all the way

Is that on a domain? Or just a workgroup?

If it's a domain, you have a whole mess of permissions to check. Maybe you missed just one?

As an experiment. Try to copy the whole database, COPY, to his machine directly and open it from there. If he can't even access it locally, then there has to be a problem only between Access and the DB. Usually some kind of version conflict.
Relevancy 49.02%

I have a really confounding problem Situation Small non-profit organization with workstations mostly Dell Pentium s Office network uses a Buffalo server and router I don t know for sure but assume the network is problem database Access a simple Base-T The organization runs on the MS Access databases I ve designed one of which is a reservation system The major tables for that system are the Signups table where the information for each reservation is collected and the EventSched which simply contains data for all the events for the year with event type date departure and return time location program type etc The tables contain a lot of links to auxiliary tables per the attachment The database is a client server design Forms on the workstations tables on the Buffalo Each year I go in and set up the reservation tables for the next year in this case I did that yesterday I first copied the database containing the tables to a file with the name quot PublicSailTbls mdb quot After deleting all the records in the Signups EventSched Manifest and HowPaid tables to make them ready for next year s entries on the workstation on which I was doing this I also copied the Forms client side of the split database changed the name to quot PublicSailForms mdb quot and changed the links to the tables file on the Buffalo This is the same process I have used for the last years Problem is the Signups form Access database problem will open on Access database problem only two of the workstations On the others the system goes into quot indefinite busy quot hourglass Task Manager indicates Access and everything else is quot not responding quot but attempts to quot end task quot fail Only way to restore the system is to select quot Restart quot Because it worked on two workstations we thought perhaps the network was not working properly so quot regenned quot it shut all computers down shut the Buffalo and router down waited one minute then brought the network back up Didn t change anything system still works on two of the workstations but not on the others Anybody have a clue as to what s going on where I should look for the cause of this odd problem nbsp

Relevancy 49.02%

Ive been trying to put a copy of my database onto a cd-r. "save & save as" on the file menu are always in faint writting and i can not select them. Any idea's as i desprately need to give a copy to my unie teacher? Help Me Please

A:Access- Cant save database?

First, make sure it is not Read-Only (right-click, Properties). If you are trying to save the whole database, then you should be able to save as to the CD. If you are trying to just save a table (or some other portions of the database), make a blank database and import those items into it.
Good luck.
Relevancy 49.02%

I am setting up a database and I would like to get some ideas on what would be the best way to it and compare it with mine.

I have a list of shareholders (ID #, name, address) that I am going to import in the new database.

Each shareholder has to vote for a maximum of three candidates for each terms (3 terms in all) and the list of candidates for each term is different.

I have to report daily who is winning for each term.


A:Access Database Setup

3 tables

Shareholders (shID, Name, Address)
Candidate (canID, Name, OtherStuff)
Vote (canID,shID)

The shareholder and the candidate tables are static and the vote table is updated. YOu need some kind of validation to ensure that each shareholder only casts 3 votes and that they don't vote for the same cadidate twice. Unless you are doing all of the data entry and then it should be fine.
Relevancy 49.02%

Hi Everyone I am new to techguy so if I am posting this in the wrong forum please point me to in the right direction I am working on a database project that involves skip tracing loan borrowers and cosigners who have bad phone numbers The process begins with a list that includes their names SSN last known address email address loan number balances charge off status and how many days past due After the list is work it gets added to an excel spreadsheet with new information such as phone number accounts that were found gets added to the bal found column charge off accounts gets added to the charge off column track source is added in I am designing a database to help Access 2007 Database keep track of resolved account their balances how many times the account have been Access 2007 Database review last date of review and so forth Again I am new to database and this is a real world app I am working on just started and I am stuck on the table and relationship I am attaching a screen shot of the tables I have so any suggestions and input will highly be appreciated Thanks in advance nbsp

Relevancy 49.02%

I have my own server and would like to know if it is possible to create a database in Access and be able to access it off the server preferably using ASP.NET.

I know i could create and sql database on there as it has my sql but would like to know if its easier to do it this way, if its possible ?


Relevancy 49.02%

I am creating a database to track customer, vendor, and investment information. I want my queries to include the following:
By Vendor
By Customer
By Mature/Surren Date
By Investment type

Later down the road...I want to create a form to input new customers. I want the form to have a pull-down menu for both the vendor and the investment fields.

I was thinking I should have a Vendor Table, Customer Table, and Investment Table. However, Vendors and the investments they offer vary from vendor to vendor -- A vendor typically has between 1-40 different investment options.

A:Access Database Creation

In that case you will want (1) your vendor table, with their names and details and an ID-key field, (2) the vendor-investment table, in which each vendor's ID key from table (1) is used with the various investment options offered, (3) a customer table, with their names and an ID-key field, and (4) a customer-investment table, in which the customer's ID key is cross-referenced to the selected vendor investment record(s) from table (2).

Hope that makes sense. You might want to check this link for a more thorough introduction.
Relevancy 49.02%

We have quite a hefty database (approx 90meg) that we would like to split into 2 smaller databases.

The plan is that if a certain "Date" field is older than a set date or another field = "Closed" then these records can be move to a archive database. The archive database needs to still have all the forms, queries and reports.

Is there software to do this or is it a case of make a copy of the database as the archive then manually delete the records that match the above criteria.

A:Splitting Access Database

In access, create a new blank db. Go to File...Get External Data...Import...

Import all tables, queries, reports, etc. that you want.

In the table in the new DB, run a maketable query, pulling all records where Date < (cutoff date) or other field = "Closed".

This new table will have your backup info. Delete the table you initially imported.
Relevancy 49.02%

Hello, I have a been tasked to move an entire Microsoft Access 2003 database from one computer to another.

The machine that has the database on is running Windows Xp servicepack 3

I want to transfer the entire database to a machine running Windows 7 and Microsoft Access 2007.

What is the easiest and safest way to do this?

I am a newbie at this so your help would be gratefully received.


A:Access database move

Copy the file to a thumb drive or across the network. THe only issue with Access 2007 might be the trusted locations setings for where the database would be running from.
Relevancy 49.02%

I have following Raw material in my kitchen
Flour 10Kg
Sugar 10Kg
Butter 5Kg

The recipe for butter cookies (1Kg)
Flour 700g
Butter 200g
Sugar 100g

Objective: I would like to design a database using Access 2007. If I prepared 3Kg of Butter cookies, I want to calculate remaining stock based on this recipe

A:Help me to create a Access Database

Hi Yalpanam,

Is this for a school project?
Relevancy 49.02%


I have an access database.

I decided to make a mde file with it out of curiousity. It has now taken my database and password protected it. I never set any password and as such cannot get access to the database.

It has taken my user name from my login, but it is not using my login password.

Does anyone know how I can override this, or reopen an older version of the database.


Relevancy 49.02%

I am configuring a new machine with Windows Vista Home Basic and trying to access a database on a Windows XP professional machine acting as a server.. this is a peer to peer network..

I am running Microsoft Access 2002..

When I click on the icon it opens Microsoft access, but then I get an error that says

"Microsoft Access cannot open this file"
" This file is located outside your intranet or on an untrusted site. Microsoft Access will not open this file due to potential security problems."

It opens it fine if I copy the file to this computer..

What am I missing???

Both pc's are in the same workgroup and the file has security set for full access to everyone..

Thanks for any help..

A:Cannot open Access database

romlisys, can you create a new Blank Database on the "Server", close it and then open that?
If you can then I would suggest that you open that database and "Import" everything from the copy of the original on your computer (that you can open). You will need to import all of the
Tables, Queries, Forms, Reports, Macros and Modules. It is very quick because you can use "Select all" for each section.

If you can't open a new Blank database it would suggest that you have some "Folder" permission type problems.
Relevancy 49.02%

at work we input alot of data into a single (very simple) Excel spreadsheet which is kept on a drive accessable by every computer in the office. The problem is once one person has opened it another cannot add or amend information because the file becomes "read only".

Is there a program which will allow more than 1 person at a time access and amend data in a simple database? i dont mind abandoning Excel if there is another program out there that can do what i need

A:Multiple Access Database

MS Access comes to mind since it is easy to get with MS Office. There is also the database software. I'm not sure if is multi-user, it should be and best of all its free. I happen to use MS Visual Foxpro which may be too much for you.
Relevancy 49.02%

A Grocery Database that allows you to compare prices for various grocers in youe area including the impact of 1. Coupons and 2 coupon doubling and tripling. Last would be historical data of pricing. From this you couls create a shopping listfor each store each week and predict when prices will be at their lowest and coupons have the reatest impact.
I'm a newbie to Access and had a VB class over 16 yrs ago. I've done a lot of input to the main table just trying to get an idea of how to manage it with queries & reports. Any ideas? I know it's a lot so i'll understand if it's 2 much.

Relevancy 49.02%

I set up and maintain an Access 2000 database in a hospital to track patients in a particular program. The hospital has signed with another info system operator and it looks like they are changing to Oracle. I know nothing about the database and am wondering how much different it is from Access and if I will be able to import my Access database and queries into the Oracle database. The hospital does not support Access and has not done so in the past. Our department is apparently the only one using Access; however, we may be able to keep using Access even tho we aren't supported by the IS operator. BUT if we can make the change w/o a lot of problems, maybe we should do so. I'm self taught on Access and will probably have to take outside classes on my own for Oracle.

Any suggestions for me.
Relevancy 49.02%

Is there an easy way to keep the structure but clear all data out of an Access database?

A:Clearing an Access database?

How many tables in the database?
Relevancy 49.02%

i created an ms access database a while ago, locked it and now forgot the password. Is there any way to unlock it? thanks,

Christian K.

A:ms access database locked

Well, you could try downloading the trial version of this program:
and it will tell you the first 2 letters of your password - it might help you remember...

These guys will apparently remove the password for free if you send them the file, but I've never used it, so caveat emptor...

There's lots of programs which you can buy to do the job, costing from $15 to $150....

Relevancy 49.02%

There was made mention by an Access Expert that they shared a Training Records Database with members. I am new and read this post - something I have been searching for for months! May I have a copy of your db so I can personalize and add to it? This would be an amazing help. Thank you in advance.
Relevancy 49.02%

I have several databases in Access 97 that reach their maximum size during operation. I have to compact the database and start over each time. It sure would be nice to be able to insert some code in the startup module/macro that would compact the database before running the remaining code.
Is it possible to compact the database that is currently open with some code in the startup macro/module?

A:Access Compacting a database

Databases must be closed in order to compact.
A closed DB cannot run VBA.
You'll be happy to know that Access 2K has a "compact on close" feature.

But check this out:
Relevancy 49.02%

I have a huge MS Access 2000 database (about 33meg in size). How do I split that up into 10meg "chunks?" Or is that even possible?

A:Splitting an MS Access Database

33M is not that big for an Access database, but they are generally stored on a server. I assume you have this one at home and suspect that your tables are not properly normalized. Why don't you export one of them, preferably your biggest one and email it to me (zipped probably) and I'll check it out for you.

Otherwise, you could create a new blank database and export a table or two to it, then link the table to your existing database. However, linked tables can only be changed in its own database.
Relevancy 49.02%

I have a option contract to recieve up to 10 apples per day for the next year. I share this contract with other people. I am creating a database that will let me know how many apples are available on any given day throughout the next year.

I am thinking that I will have to set up a table with a field for date and capacity. Then subtract 1 each time someone takes an apple on that day.

Is there a better way?

A:Solved: Access database help

So you want something like stock control? So when someone takesan apple you want it taking from stock?
Relevancy 49.02%

In my database program the user has the option to delete clients from a list or add new ones. This works fine unless all clients are deleted and the database becomes empty. Once this happens, the user is still able to add new clients to the empty database. However, back in the forms area, it will not allow new data to be entered in the fields for the new clients.

Relevancy 49.02%

I have a membership database created by someone who is no longer available to consult. It contains fields to check for organizations joined. The information was for 2008. I am getting ready for a new year and would like to keep the 2008 information but create a new form that clears those fields to insert 2009 information. Do I need to copy the 2008 database and save as 2009. I know this will sound crazy, but how do I do that? When I open the document and click save as it says save switchboard to _____________; save as _____________