I think it is not possible to setup a batch file to compact repair Access databases, but anyway, I would like to try once more and see if there is a possibility to do something like this. Ideas and suggestions more than welcome.

Answer:compact/repair and Access database

Why don't you just check the "Compact on close" checkbox under Tools, Options, General tab?

I get this error message (this is translated, so it is not the exact words):

"Cannont compact and repair the database. You may not have permission to the folder where the database reside. You must have full permission to the database folder to be able to compact and repair the database. Contact the system administrator for more information."

The only information I have found on this matter is for Access 2003, and it was related to user permissions in the database. And in Access 2010 there is no user permissions anymore.

Is the problem related to permissions on the server (the database file is located on a server (not Sharepoint)). Since the user can open the database I guess she have permission to create files (the .laccdb-file is created when the database is opened).

It is the first time I am posting a help thread on internet, hope I can find answers here.Issue: I have modified a calculated field in a access table and got an error that I am unable top open the table anymore (not in edit mode or normal mode). I have read on the net that I should hit "Compact and repair" the database, so I did.After 1 second my table with a lot of calculated columns disappeared and now I cannot use the database.I tried to restore from backup my database but the location is on my desktop and there were no backups made since 1 month.

I am currently running MS Office Professional 2003 and I am having difficulty getting the autonumber to restart. I have done this in the past by compacting and repairing the database after deleting the appropriate records out of the database. There are relationships involved in the tables but I'm sure i have deleted all the records. Am i missing something along the way?

Thanks for the help.

Answer:Compact and Repaird Database (Autonumber)

I think all records have to be deleted. Another way is to delete the primary key from each table that is using autonumber and recreate them.

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

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.

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

I have read others talking about Access compacting when it closes. Is there a way to make this automatic (or a macro that does it, or what?) for '97?

Thanks in advance

Answer:Access 97 - compact upon closing?

Access 97 doesn't have that option in the program. WHy do you need to compact on closing it, are there a lot of temporary tables? You could create a VBS script that can be run from scheduled tasks at the end of the day.

I have the 'Compact and Repair' (C&R) on close option turned on, but if I use DoCmd.Quit it doesn't seem to do the C&R. DoCmd.CloseDatabase does C&R but leaves ACCESS open. I'm looking for a way to compact and repair before quit.

Access 2007 or 2010Thanks

Answer:Access VBA compact/repair

I take it back...I don't think the compact and repair (on close) was selected.

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

I would like to set up an MS Office Access 2003 or even 2007 file and put it online for my team to enter data into. It seems as if Google Docs, my first idea, does not facilitate MS Access mdb files.Any safe suggestions would be most appreciated.

Answer:Easy online access to a Microsoft Access database

windows live shared folder. give password into to people who can access the DB or they register accounts and allow them to access the folder

I have on a Laptop, an Access 2013 program feeding an accdb database. I want to move subject database or a copy of the accdb database to a new PC with Access 2013 installed. Both computers are running on Windows 10. I considered copying the laptop database to my Kingston Data Traveler but I can't even find the directory where the database should be.

The only other thing to add Is that I programmed the record input software using Access 2003 and copied it onto my laptop with Access 2013 installed and which works fine. Later, I saved the MDB database into the Accdb format (Access 7).'

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?

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

Hi bbinnard,

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

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

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.

Hi everybody! I have a problem with my MS Access and can&#8217;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&#8217;t find the wizard, or there is syntax error in the Declaration section of a Visual Basic module.​The wizard you need may be missing from the libraries key of the 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&#8217;t know where to find and compile those Visual Basic modules. I also don&#8217;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 2000 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

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

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.

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

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

http://www.geocities.com/jbfen/index

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

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

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

Hi,I have a simple MS Access database that has a nice an simple Import routine, whereby an excel file is imported when the user clicks import. Would it be possible for me to somehow log the path of the excel file that has been imported and record the windows user name that performed the import, in a simple report or table - E.g.Date:File:User:Thanks for any help.

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

http://members.tripod.com/accdevel/imaging.htmhttp://www.lebans.com/loadsavejpeg.htmok 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.......

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

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.

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

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.

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.

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

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?

thanks

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

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?

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

HELP

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

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?

I am developing an Access database, one of the uses for which will be mail merging letters and mailing labels. The database records all contain an Area field, which contains an area code in the range 1-10. I've created a query which allows the viewing of records for specific areas (i.e. it filters the data so I can see just area 1, just area 2, etc). Instead of having a separate query for each area I put [Area?] in the Criteria for Area on the query design so that a box appears when I run the query into which I can enter the area code I want, click OK, and then that area is displayed. This all works fine.However, when I come to try mail merging, the query is not visible in the list of ones I can select in Word! If I make a query without the [Area?] variable in then it works OK (i.e. if I specify "1" as the area criteria).Can anyone advise what I'm doing wrong?

Answer:MS Access database

Searching around on the internet, I found a solution to this.Within Word, you have to go into Tools > Options > General Tab and select confirm conversion at Open. This, for some reason, displays a different menu when you select the database as the source for the mailmerge, from which you can select a DDE connection which then gives you the full list of tables and queries from Access.

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?

my sup wants me to design a database to log network equipment with their corresponding users. now i plan to do this in m$ access 2003 and have created all the necessary fields so far and customized them to what they ought to be.

question #1 what should i do next??
question #2 give me some ideas please of how to really get this database app going please.
question #3 how do i make it seem like a program for the end user.

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.

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

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

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

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

[Forms]![FormName]![ControlName] 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.

I have a database for an engineering project that has 3 main tables. These are the ProjectCode, the Area and the CostsThe ProjectCode has multiple Areas and the Areas have multiple Costs. Data entry to the Costs table includes a [ProjectCode], [Area] and an [Amount Aus]

My Area Table has all the area / project code combinations entered as these all have an individual budget figure that needs the costs to compare to

I want my database to be able to sum up the [Amount Aus] in the costs table and update the field [AmountAus] in the Area table, but only for the costs that match the [ProjectCode] and [Area]

Father is running a television repair business. I thought that an access database would be a great way to log in when a customer called. Some information on the customer, television type, the problem etc.

I've looked through the microsoft template, I found a 2003 version of the database program that I want but it involves a lot of b.s. that I can't figure out. the 2007 versions are a bit more user friendly, but I'd rather turn the 2007 version to want 2003 can do or atleast the template does. It's found here,
customer Management
the really cool part about this database is probably the different things you can do. One, you can create an invoice based on the items you set to price and add the taxes to them, then you can add things like different employee's etc etc. I've tried to do it myself, but, there's no real 'help' and i honestly don't know my way around access.

Answer:MS Access Database

Hello,

If you want to save the access database as 2003 open the database and do file save as and 2003 but you may loose some functionality

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.

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

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

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

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

My son is trying to design a booking system for time slots completely in Access as part of a college project. We are having trouble in making the availability of a slot conditional on it not having been booked already.We have designed a booking form which offers timeslots in the form of a combo list box. We are able to apply validation to eliminate multiple bookings, however we would like the booking form to only offer available time slots (and not to display those already booked). Any ideas how this can be achieved please?

Answer:Access database - help please

I don't know if the following link will be any good to you but it seems to cover a similar topicclick here

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.

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

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.

I am trying to produce an access database for client names and addresses to be entered using a form but I want the establishment address to be automatically completed if the establishment name when entered is in an existing table of names and addresses. I want to store the address in the new client database table and be able to add a new address if the establishment name does not already exist.

I have tried various ways of doing this including dlookup, and on afterevent with no success. It seems a very logical thing to do but I cannot get Access to do it. I would be grateful for any help.

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?

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

Code:[FirstNm]=[Forms]![MyFormName]![txtFirstNm] And [LastNm]=[Forms]![MyFormName]![txtLastNm] Hope that helps.

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.

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.

I am involved in a database at work. We are almost ready to implement it and want to remove the test data that we entered in initially. How do I go in the back door and erase the info with out erasing everything else?

Currently I'm working on a project at work and am unsure as to what would be the best way of implementing the following concept: There is a need to track certain access to labs and software within the building. An end user should be able to submit a pre-created form (likely in infopath) and it should automatically be added to a database over a network drive.

I am happy to provide more detail of the task if needed, I just need to know what the best implementation of this concept would be. The process should be something an end user should be able to just submit without difficulty. Thanks in advance.

i have a access file and it wont open the access used to create it was access 2.0 or something and trying to open it using Access 2000

Answer:Microsoft access database

Unless security has been applied to the database you should get the option to Upgrade it when you try to open it in Access 2000.If you get this option to upgrade, follow the prompts and save the new file as a different database name to prevent overwriting the original.If you get a specific error message it is probably down to having security applied to the database or that it has been compiled as part of a distributed program which will present real problems.Copy any error messages you get and post them in here.T

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.

When I go to generate a report in an Access database that consists of about 10 plain text pages, the program crashes. Task manager says not responding. ONLY Access is open, nothing else. And this is a 1.3 Ghz with 256 megs ! Any pointers ? Thanks !!

hi everyonei have question may someone can help me pleaseif i want make id card for some employer by Microsoft Access is this program helpful for this cand i make design for id and put it Microsoft Access and put information in it and like this

i think may question is not verey clear but any way you can tray to understand at the end could i make database by Microsoft Access

click hereIf you take a look at the above image you can see that all i want to do is be able to add a Customer into the form and then check wehter the room is booked in another form. Does anyone know if this is possible and how I would be able to go about it?Thanks,Live Wire

Answer:Access Database Impossible - Help?

Furthermore, if I wanted to remove a customer than I would need to delete his record.However, if I do this I will have no back up data of him. I assume I cant keep a record of customers becuase if I want to clear the room than he will dissappear from the database completely????

I am trying to set Ebay's Item No as the primary key in Access 2000, but it will not allow me to do that. I keep getting null number errors no matter what I try. Nothing at all works. Is this a problem with this version of Access, or does anyone know how to circumvernt this? Better yet, is there anyone out there that is willing to set up a database for us, one that will also incorporate some Excel functions? Thank you.

My boss has just called a meeting to discuss the security of our databases. Currently we have every one of our sales team (who deliver quotes on site) with a copy of the current database on their laptops (no points for guessing security risks there...). This gets updated about once a week by them coming into the office and downloading the new version. The DB itself hold current costings to our company and the sales agents run a front end to give a accurate quote at that time.

My boss has asked us all to come up with suggestions on how to get remote access, while on the move, to this database. He wants the staff to only be able to read the database and not mess about with it. It should really only be used for reference from the front end.

My immediate reaction to this was just to bung it all online and let them use a webpage to log in and view the up-to-date database. Then I remembered the 'while on the move' part.

He is looking for a wireless system. So that no matter where our sales agents are they can get access to our DB.

Can anyone suggest any systems that I could look into implementing or has anyone got a system currently running that would fit this scenario?

Answer:Remote Database Access

He is looking for a wireless system. So that no matter where our sales agents are they can get access to our DBClick to expand...

That's not a realistic expectation. I'll let the network people explain it better than I can. However, access to the database itself will require either a web front end over SSL or a VPN link back to your office using the existing application.

I have a really confounding problem. Situation: Small non-profit organization with 7 workstations, mostly Dell Pentium 4s. Office network uses a Buffalo server and router. I don't know for sure, but assume the network is a simple 10Base-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 2010. I did that yesterday. I first copied the database containing the 2009 tables to a file with the name "10 PublicSailTbls.mdb". 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 2009 Forms (client) side of the split database, changed the name to "2010 PublicSailForms.mdb" and changed the links to the 2010 tables file on the Buffalo. This is the same process I have used for the last 9 years.

I'm creating a database of sales I've made on Ebay. I've entered all the infor and have created a button which, when clicked, shows the buyers details. However, when I click this button it just show the first record in the table. How can I get it to open at the relevant record? All the information I've put in the database is stored in the same table....

Hi folks i am relatively new to using Access Databases and have a query

i have created a form in Access which users manually input data into and i trying to work out if its possible that when data is entered into 2 fields called actual hours and hourly target (both long integers) then a calculation can be done and put into another field within the same form

Hi.. I've been asked to do up an access database to keep records for a computer workshop.. My knowledge on Access is a tad (ok maybe fairly) rusty..

Here's what I've got in mind.. (see attachment).. hope that you can read my scribble.

I'm just not sure on how to get access to actually perform the phone number lookup to see if the customer exists in the database, and also use the customers info to link (or fill) fields in the jobs table.. so basically each time a service job comes in the customer doesn't need to be re-created in the database each time.

I have selected an Access databse to start up from one of the forms. However, when the form opens up it is about half size. How do I get the form to start up in full screen mode? I cant see anything from the options in Tools_Startup that would enable me to do this.

Answer:Access database startup

Found this by typing Form Size into the help screen of Access Set the size and position of a form or reportSet the default size of a form or reportOpen a form in Form view or a report in Print Preview. Size the form or report by dragging the borders of the window. Click Save on the toolbar. Note If the AutoResize property is set to Yes, Microsoft Access automatically sizes the form or report to display complete records. To set the form or report window to the size you want, make sure the AutoResize property is set to No. The AutoResize property for a report is not available in Microsoft Access 2000 or earlier.

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?

Answer: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?

I have downloaded the book collection database from microsoft website but i would like to alter it a little.

When i am entering the details of book on the second box down you can click on the box and enter the books topic IE crime, romance, thriller and so onand then when you enter the next book you have only to enter the first letter and it is entered automaticly.

My question is how do i copy this feature as i would like to have another so i can easley enter where i got the books from without having to type all the infomation in.

Hope someone can help please

Answer:Access Book Database

49sam, I think that you are talking about a Combo Box. This can be added to the form using the Controls Toolbox Wizard, which creates it for you.Have you created a Table for where you get the books from?

I have an ACCESS database several excel files imported that contact 3 or 4 columsn of data to evaluate. I created queries to identy all the item codes and there corresponding values. I need to create a query that will identify only the item codes where 3 variables do not exactly match for each segment: MM, KK, UB(Price List, Debit Credit, Damage Track). In addition, those items that have blanks or zeros for those 3 veriables need to be identified as well.

I am looking for help creating database that i can use for my company. I want it to do my accounting as well as integrate my payroll and employee management into it. Accounting software is very expensive for my small time company not to mention payroll software. If anyone can help me that would be very much appreciated

Does anyone know of a program/option/tool to repair a microsoft access database that can be run from command line (I don't want any user interaction, I want to be able to schedule it).

The systems do not have Microsoft Access installed, they use a Delphi program with ado connections to an ms access db, and the delphi program runs a compact every time it opens, but the db still gets corrupted and needs repair from time to time.

Currently, I have to log onto the machine, open odbc and do a repair through that, but I would like to be able to schedule a regular repair to run without needing a connection to the db, and hopefully avoiding the user ever seeing the error message.

So far, all I have been able to find are programs that use a gui interface (which I can do with the odbc), or programs that require ms acess or ms access runtime installed, neither of which exists on these machines.

I need more than help looking for someone who can create a database in Access for me

I need to trackemployee time CashTipsexpenses and a little more

Anyone interested in a small project?

More than just a spreadshet that I alredy useTom

Answer:Need help writing an Access database

Tom, I can do it for you, but I am not sure how long it will take as I have about 4 other posters that I am trying to help with less time to program.It will also depend on how sophisticated you want it.