Windows Support Forum

Access database move

Q: Access database move

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.

Thanks

Relevancy 100%
Preferred Solution: Access database move

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

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.

https://forums.techguy.org/threads/access-database-move.1007102/
Relevancy 75.68%

Windows nd Ed workstation win NT Sp server Microsoft Access I have an access database with a form that has command buttons for opening the database for editing and for Solved: computer another How to to database access move running a report I am using it locally on a windows workstation that is on a network It works just fine I want to move the database to the server and access it from there I copied the files to server and created a shortcut to the form on the server share permissions are good Neither the form or database will open and there is an error message stating that the path C access db mdb is not valid This path is the path from the local machine What is happening is Solved: How to move access database to another computer the form is trying to find the database on the local machine and not the server I went into the form properties and set the quot Record Source quot path to the new server location trying both UNC and mapping and then I got the error message that the server path does not exist it does I can see it over the network Thanks for any help James nbsp

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

Thanks
Mark
 

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

Google: import access to sql server
 

https://forums.techguy.org/threads/copy-an-access-database-to-sql-server-database-using-vb-net.1045442/
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.
 

https://forums.techguy.org/threads/exporting-ms-access-database-to-mysql-database.389139/
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.
 

http://www.pcreview.co.uk/threads/how-to-open-existing-database-from-another-database-using-access-vba.4070487/
Relevancy 59.34%

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
 

Relevancy 59.34%

My faithful PII has finally failed. My HD is good BUT... I have my business database program on that drive. As I found out earlier on this site, I cant just stick my HD into another PC and boot it ...it wont.
How can I migrate my database which is on my C: drive to a new PC?
The Database program is an Agricultural one that logs farm records.

A:How to move a database program

You haven't identified your program, however, you need to install the database program
onto your new PC; you should then be able to copy your database files over.

I would imagine that you have backup copies, on separate media.

You could install your old disk in the new computer as a slave drive, search for all database files
and copy to new C:\ drive, or import as below.

In Access, for example, the database file extension is .mdb, so you would search *.mdb on the old drive to find all files.

Or, you could put your old hard disk in an external case; you should then be able to copy or import
your database(s).

In Access, for example, to import, you would select: File / Get External Data.
Should be something similar in your program of choice.

That PII lasted well.

http://www.bleepingcomputer.com/forums/t/277638/how-to-move-a-database-program/
Relevancy 58.05%

I have a sharepoint server running a database in sql server 2005 express and want to move it to a new server running SQL 2005 standard edition, what is the easiest way to go about this..
i have come across this and I want to know if it will work
http://msmvps.com/blogs/cgross/archive/2007/03/24/moving-your-wss-3-0-databases.aspx
 

https://forums.techguy.org/threads/solved-move-upgrade-sharepoint-database.716440/
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.
Thanks
 

Relevancy 56.76%

Hello All I have an excel sheet which I want it to be converted to CSV and move that data from CSv to oracle databse I have a Vbscript that converts excel to CSV To to that Excel and move then CSV file from oracle to convert database. data an CSV but the way in which my To convert an Excel file to CSV and then move that data from CSV to oracle database. excel sheet is formatted it is not coming up properly There are some cells which I dont require and want them to be skipped and only the headings and their respective data should be coming up To convert an Excel file to CSV and then move that data from CSV to oracle database. onto the CSV file I am attaching the excel sheet and also the screenshots of that excel sheet showing the cells and the text needed to be skipped highlighted in a red box Please help me with this to have the CSV file by skipping these data and then load that data to oracle database in two tables where in one table will have data from some rows in CSV and another table will have a row of data from that CSV file Here is the VBscript that I have been using Code COLOR B AF WorkingDir COLOR COLOR COLOR COLOR quot C Users vijaywp Desktop quot COLOR COLOR B AF Extension COLOR COLOR COLOR COLOR quot XLS quot COLOR COLOR B AF Dim COLOR COLOR fso COLOR COLOR COLOR COLOR myFolder COLOR COLOR COLOR COLOR fileColl COLOR COLOR COLOR COLOR aFile COLOR COLOR COLOR COLOR B AF FileName COLOR COLOR COLOR COLOR B AF SaveName COLOR COLOR B AF Dim COLOR COLOR objExcel COLOR COLOR COLOR COLOR objWorkbook COLOR COLOR B AF Set COLOR COLOR fso COLOR COLOR COLOR COLOR B AF CreateObject COLOR COLOR COLOR COLOR quot Scripting FilesystemObject quot COLOR COLOR COLOR COLOR B AF Set COLOR COLOR myFolder COLOR COLOR COLOR COLOR fso COLOR COLOR COLOR COLOR B AF GetFolder COLOR COLOR COLOR COLOR B AF WorkingDir COLOR COLOR COLOR COLOR B AF Set COLOR COLOR fileColl COLOR COLOR COLOR COLOR myFolder COLOR COLOR COLOR COLOR B AF Files COLOR COLOR B AF Set COLOR COLOR objExcel COLOR COLOR COLOR COLOR B AF CreateObject COLOR COLOR COLOR COLOR quot Excel Application quot COLOR COLOR COLOR COLOR objExcel COLOR COLOR COLOR COLOR B AF Visible COLOR COLOR COLOR COLOR B False COLOR COLOR objExcel COLOR COLOR COLOR COLOR B AF DisplayAlerts COLOR COLOR COLOR COLOR B False COLOR COLOR B AF For COLOR COLOR B AF Each COLOR COLOR aFile COLOR COLOR B AF In COLOR COLOR fileColl ext COLOR COLOR COLOR COLOR B AF Right COLOR COLOR COLOR COLOR aFile COLOR COLOR COLOR COLOR B AF Name COLOR COLOR COLOR COLOR COLOR COLOR COLOR COLOR B AF If COLOR COLOR B AF UCase COLOR COLOR COLOR COLOR ext COLOR COLOR COLOR COLOR COLOR COLOR B AF UCase COLOR COLOR COLOR COLOR extension COLOR COLOR COLOR COLOR B AF Then COLOR COLOR 'open excel FileName Left aFile InStrRev aFile quot quot Set objWorkbook objExcel Workbooks Open aFile SaveName FileName amp quot csv quot objWorkbook SaveAs SaveName objWorkbook Close End If Next Set objWorkbook Nothing Set objExcel Nothing Set fso Nothing Set myFolder Nothing Set fileColl Nothing COLOR I am also attaching the CSV file being generated change the extension from txt to csv with this script Please Help Thanks in advance nbsp

A:To convert an Excel file to CSV and then move that data from CSV to oracle database.

https://forums.techguy.org/threads/to-convert-an-excel-file-to-csv-and-then-move-that-data-from-csv-to-oracle-database.1092886/
Relevancy 55.9%

Hi all,

Here's one that's got me vexed.

Is there a way to select a row in a continuous form and do a "Move up" or "Move Down" so that it not only moves the record on the form but also shows this resequencing in the ouput report.

Currently the row source is an SQL query from a table.

Chris
 

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 is....download the Trial Version and play around with it for quite a while.

http://www.sevenforums.com/microsoft-office/191698-any-problems-using-access-2007-database-access-2010-a.html
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 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.

Scott
 

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.
 

https://forums.techguy.org/threads/access-97-database-in-access-2000.443343/
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.

http://support.microsoft.com/kb/208204/en-us
 

https://forums.techguy.org/threads/cant-access-ms-access-database-wizard.553449/
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?
 

https://forums.techguy.org/threads/two-access-the-database-is-not-available.1169220/
Relevancy 49.88%

Hi,can smb help me with sites that have tutorials about the relation of vb.net with access databases or sql databases.
Thanks
 

https://forums.techguy.org/threads/vb-net-with-access-database.879782/
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)

TIA

Tom
 

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.

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

https://forums.techguy.org/threads/ms-access-database.780963/
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.
 

https://forums.techguy.org/threads/access-database.228833/
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%

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
 

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
 

https://forums.techguy.org/threads/access-database.706441/
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.

thanks.
 

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?

thanks
 

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.
 

https://forums.techguy.org/threads/access-database.686973/
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,
renee
 

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.
 

https://forums.techguy.org/threads/access-database-help.382787/
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%

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

https://forums.techguy.org/threads/access-database.69985/
Relevancy 49.88%

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

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

!!!!!!
 

https://forums.techguy.org/threads/database-ex-here-need-help-with-access.82658/
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 Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

A:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

https://forums.techguy.org/threads/access-database.37131/
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?

thanks
 

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

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:

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

https://forums.techguy.org/threads/access-database.271656/
Relevancy 49.88%

Hi

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)
 

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.
 

https://forums.techguy.org/threads/access-database.225858/
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 Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

A:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

https://forums.techguy.org/threads/access-database.28990/
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%

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%

--------------------------------------------------------------------------------

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)
 

https://forums.techguy.org/threads/database-help-access-03.707936/
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.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.

http://www.vistax64.com/system-security/261294-runtime-error-75-path-file-access-error-call-access-database.html
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:

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

https://forums.techguy.org/threads/access-printing-a-single-report-off-of-a-single-record-from-an-access-database-form.99807/
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%

Hi guys is there anyone out there that can help me I need to create a appointment system for a doctors surgery but I can get the appoinment system to work.

I just want to book appointments for 3 doctors and a nurse. But its not playing and its driving me mad now lol please i beg anyone who can help me please
 

Relevancy 49.02%

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.
 

https://forums.techguy.org/threads/access-database-criteria.129100/
Relevancy 49.02%

Is it possible to open an entire access database (reports, queries, tables, etc.) as read-only? I figured out how to make forms read only but I would like to just make the entire database read only.

Thanks,
Kristy
 

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 _____________
 

Relevancy 49.02%

i m very much a beginner at access java database help java i m currently working on a database application and i m using access to create my database my instructions say that i m to access database java help create a database w four tables and then lists the fields for each table but i m having a little trouble w the access part of this my problem is that my instructions for the fields will look something like this create table names personID int DEFAULT AUTOINCREMENT firstName varchar NOT NULL lastName varchar NOT NULL i can create the table and of course i can create the fields but i m not sure where i need to implement quot int DEFAULT AUTOINCREMENT quot and quot varchar NOT NULL quot will that be done in my java code or do i need to do that somehow in access i m not asking anyone to do my homework for me i m just having trouble w access i ve emailed my teacher w this same question but i have a feeling that i ll get faster replies here any help will be appreciated thanks nbsp

A:access database java help

Sorry, I do not know Java at all, but I do know Access. Those look like instructions to Access.
The first "int DEFAULT AUTOINCREMENT" means Use an Integer value and it is Autoincremented by the table.
The other 2 mean Text of 30 characters (maximum presumably" but must not be Null ie nothing, so an entry must be made.
Why not try implementing it and then make some entries and see if that is what happens.
 

https://forums.techguy.org/threads/access-database-java-help.469953/
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?
 

https://forums.techguy.org/threads/clearing-an-access-database.329705/
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:
http://www.mvps.org/access/general/gen0013.htm
 

https://forums.techguy.org/threads/access-compacting-a-database.168828/
Relevancy 49.02%

I want to make a database listing CDs and track titles. I can't figure out how to go about this, since the number of tracks vary so widely on different CDs. Some CDs have 23 tracks! Do I need to create 23 fields just for those few?

Better yet, can I make an expandable field that will keep creating new data fields as needed?

I know how to set up a basic database, so I don't need help with that.

Thanks.

A:MS-Access: How to Create a CD Database

The idea that you propose in having a single table that lists the CD Name (Album Name) and the tracks together as a single line item isn't a very effective method of making that database for exactly the reasons you raised. Rather than having them in one table, split them up and relate them.

The way I would go about doing this is...

Table 1: Albums
Fields: Album Name, Artist, Year, Genre, Whatever other fields you might add
Primary Key: Either make it a composite key with Album Name and Artist or create an additional field which contains a unique identifier such as a Number. I would suggest creating a unique field as the primary key as it is easier to work with.

Table 2: Tracks
Fields: Song Title, Artist, Album, Track Number
Primary Key: I would go with Song Title and Artist as a composite Primary Key.

Table 3: Artists (If you so choose)
Fields: Artist, any other info about the artist or group you wish to include.
Primary Key: Artist Name

The important thing is the relationships between these three tables.

Albums Table is related to Tracks Table in a One to Many Relationship (One album has Many songs).

Albums Table is also related to the Artist Table in a One to Many Relationship as well (One Artist may have Many Albums).

You need to determine what you want to have as your primary keys which will determine what the foreign keys will be in the related tables. For example, if in the Albums Table you use the Name and Artist as the Primary Key, then these fields would be related to the corresponding fields in the Tracks Table.

You don't have to follow my model exactly, but do you understand the idea of splitting up the Tracks and Album Names fields into different tables and relating them? This eliminates the problem of constantly having to add fields for new tracks. It'll also make queries significantly easier to sculpt.

Hope this helps

http://www.bleepingcomputer.com/forums/t/339703/ms-access-how-to-create-a-cd-database/
Relevancy 49.02%

Hello,

I am upgrading my membership database for local sports club

I am trying to visualize payments, but I dont know how to link the toggle buttons in my form with table fields (see attached file)
 

A:MS Access members database

Can you tell me what the database is designed to do?
As it does not appear to be designed correctly for keeping records of membership payments etc.
What are the p, n, s and plj field for?
 

https://forums.techguy.org/threads/ms-access-members-database.1084298/
Relevancy 49.02%

i have fields in my database, and the first field is autonumber which is set as the primary key...

the next field starts with Lname, Fname, Add, state, and so on...

how do i sort the Lname field which stands for last name to be in alphabetical order everytime a user inputs that information through a visual basic program.....

thanks..
 

Relevancy 49.02%

I am working on a class assignment Basically we are a group programming a business application We are making a personal finance application and I am working on the database in Access I have a table for credentials which has the username password and ID The next part is where I need advice and perhaps reference if you can I need to have an expenses table of some degree I Database Advice Access was thinking about making various tables with a date column I would have many of these the date column is for an object in the actual application there will be many expense tables obviously I was wondering how would I structure that Would I make a table Access Database Advice of just foreign keys and one of the foreign keys link back with the userID How would you actually program that in VB Would I reference the actual table of the expense say savings or would I reference the table of just foreign keys Advise tips Thanks nbsp

https://forums.techguy.org/threads/access-database-advice.1157624/
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:
http://www.5star-shareware.com/Business/MS-OfficeAdd-Ins/access-passkey.html
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...
http://www.intertek.org.uk/services/

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

HTH
Gram
 

https://forums.techguy.org/threads/ms-access-database-locked.167419/
Relevancy 49.02%

Is there a way in an access database to not display data that is older than the data that is being entered?

For example, I have a database that keeps track of when users become certified. I do not want to get rid of the old information, but I do not want to display the old data on the form.
 

Relevancy 49.02%

Hi, I'm having problems opening my access database - I've an awful feeling its corrupt. I get this message when I try ot open it ...
Unrecognized database format and it lists the file path. The file is in .mdb format so I'm confused as to why it won't open. I need this file to be accessible as its got 2 weeks worth of data on it - both of my backups are corrupt too
Any ideas ...
 

Relevancy 49.02%

I am trying to install Outlook 2000. I get ..."Error 1919, error configuring ODBC data source, ODBC error 6, MS access database component not found in registry. Verify that the file MS access database exists and that you can access it." I have tried searching for this file with out luck. I have downloaded all XP updates. The "free" expert phone consultation that comes with certain services and hardwear, had me doing a lot of reconfiguring of my system to solve other problems. All kinds of things didn't work after that. I have finally managed to get every thing working again, but wonder if this is something else that the "expert" had me turn off. Any suggestions would be appreciated.
 

A:can't find MS access database

Hi nvb,I dont know if this will help,I found it during a search,
This error is caused by missing operating system components on your PC. These components are required to connect to ODBC databases.

Resolution
1. Download and install Microsoft Data Access Components v2.7 from Microsoft. Note that the download link is at the bottom of the Microsoft's web page.
2.
Download and install Microsoft Jet 4.0 SP3 from Microsoft. Note that the download link is at the bottom of the Microsoft's web page

And I think the place to go to for that is here http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860
 

https://forums.techguy.org/threads/cant-find-ms-access-database.125103/
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?
 

https://forums.techguy.org/threads/solved-access-database-help.969410/
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.

Cheers
jimbo

http://www.sevenforums.com/software/119141-database-ms-access-backend-vs-ms-sql.html
Relevancy 49.02%

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?
 

A:MS Access Database-need help asap

Try opening each table and deleting each record one by one.
 

https://forums.techguy.org/threads/ms-access-database-need-help-asap.250237/
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.
 

https://forums.techguy.org/threads/splitting-an-ms-access-database.36539/
Relevancy 49.02%

--------------------------------------------------------------------------------

Hey all,

I have at least two user's that access a 212 MB Access database. It was working fine up to a few days ago. Now they are having some funky stuff happening. Using both or either Access 2000 and Access 2003 they are getting this error message some times when they try to open the database:

"You do not have exclusive access to the database at this time. Any changes you make may not be saved."

This happens to multiple users. When they access the database a .ldb file appears indicating it is locked. Some times the user can make changes and some times not. The file is located in a place similar to this: G:\share\subfolder\atc board database.mdb

I've Google'd the error message and haven't found anything that really fixes the issue. Any thoughts?
 

A:Access database issue

Has one of the users set up a Short cut where the command line is using the Exclusive option?
Have you Compacted and Repaired the database?
 

https://forums.techguy.org/threads/access-database-issue.589142/
Relevancy 49.02%

Hi there,

Just checking with you guys.

Will this database work if a job needed one or more parts?

I can post a print screen of the relationships between the tables.
 

Relevancy 49.02%

I want to share a database from my Windows XP pc with a laptop with Vista. I have tried network sharing, usb replicating and cannot get the information I put into the laptop to replicate on the pc. I have a feeling this should be easy, but cannot find a way to do it. Help much appreciated?
 

A:Sharing access database

Are you using replication to allow you to work on the laptop remotely and then synchronize the changes later on? If so, after you make the data changes and network them back together are you using "Tools">>"Replication">>"Synchronize Now"? This will synchronize the changes you have made in both.
 

https://forums.techguy.org/threads/sharing-access-database.599379/
Relevancy 49.02%

Hi,

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.

Thanks
 

Relevancy 49.02%

Built an accounting database:AR, AP, CD,PR,JE, GL........etc.
Looking for help with some access 2013 issues.
1 Need to tie all those tables to create a general leger and a financial statement(It's not the GL I'm concerning
about as much as how to move data from tables to GL
e.g.- For AP every entry on a form has two sides one debit another credit and they need to be reflected in
GL by account number and that where my problem is

2 In my forms need to have a multiple line entries per transaction (like a sales order)
 

A:access 2013 database

nphcpa, welcome to the forum.
I am not sure what "AR, AP, CD,PR,JE, GL........etc." are, but it sounds like the overall design of the database may not be optimal.
The fact that you have to have the "move data from tables to GL" suggests that the data should be in a GL table but identified by it's source and split up via Queries for data input/editing.
As for item 2 it sounds like you should have a "Line Entry" sub table and subform for the Transactions.
Can you show me a screenshot of your table Relationships?
 

https://forums.techguy.org/threads/access-2013-database.1125481/
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 to build a simple database in access with a few queries and reports. I also need a form and possibly a switchboard.

I have the start but I don't know how to build a dependent combo box and could use some help. Is there anyone out there with the time to help me get this straighten out.

Thanks
Michelle
 

Relevancy 49.02%

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

I need to track
employee time
Cash
Tips
expenses and a little more

Anyone interested in a small project?

More than just a spreadshet that I alredy use
Tom
 

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

https://forums.techguy.org/threads/need-help-writing-an-access-database.1046556/
Relevancy 49.02%

Hi! I'm a web designer - new to databases.

I'm setting up a database for a DJ company, and wanted a second opinion. Is it better to create one table called "Events" (which would necessarily hold a space for only occasionally required fields like BridesName and GroomsName), or to break the table down into a table for Weddings, Parties, Mitzvahs, etc. and either risk some form of redundancy. I'm leaning toward the first option, but wasn't certain, and wanted a second opinion.

Thank you!!!

PS - Using Access 2007 (but I don't know that it's relevant to this question) Thank you.
 

A:Access - Database Set Up Question

There are rules in deciding how many tables to use.

1 nf/2nf/3nf - nf=normalized form.

1 table with all events should be fine.
 

https://forums.techguy.org/threads/access-database-set-up-question.600771/
Relevancy 49.02%

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.
 

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 m looking to start creating some of my files in Access Everything I have for my work is done in Excel but I think some of it should be in Access I do not know Access very well but would like to learn I would like database Access Create to start with something fairly easy I am using Access One of my job duties is to input data for water meter readings These readings are read approximately weekly and I need to generate a report monthly Sometimes the data will come in sporadically and possibly multiple times per week maybe once per day at times The report that I would need to see is - and it would be nice if I could Create Access database choose the month to report on as well - assuming we will use the current month every meter read as of today or the last day of the month and find the difference between the readings from the first day of the month So Jan reading minus Jan reading I could make the date the unique key as there will always only be one reading per day I would need the totals for each meter who the meter belonged to Create Access database and what duration month the information was retreived from I m not worried about how it looks as long as it s there I have this in Excel but it s cumbersome and I think it s the wrong program There are Create Access database other things I use these values for Some of the metered readings are used to find irrigation flows for farm circles Those are currently kept in another spreadsheet there are lots of these spreadsheets These daily gallon figures are then used in other calculations where each day has several other possible inputs these inputs are hours put into different cells locations These figures are used with another daily number to obtain a final daily loading figure These do work in Excel so I m not in a rush to get this its currently in operation My line of thinking was that it would be better suited for an access database I would love some additional input on this Can somebody please help me setup a database that will assist in this area I can manage the table but that s about it I realize this is a large project overall if able to keep this in small bits maybe it will be easier nbsp

Relevancy 49.02%

Hello:
I have this database that I need to complete. I have completed the basics but can not seem to figure ot how to do the rest of it. Can someone help me.

Here is what I am trying to do:
1. Final section greyed out when no is selected for response
2. Change current stage field when key fields are populated
For example:
- When exit meeting is entered, the current stage should automatically change to tracking.
- When response needed is not checked, current stage should be completed.
- When response needed is checked, current stage should be in acknowledgement.
3. Have the BOG and Internal Due Dates Met fields automatically calculated in the background

In addition: I also need a switchboard created but I think I can figure it out. I do have reports I need though.
1. Open Report
2. Tracking Report
3. Completed Report
4. Acknowledgement Report

I have attached the file. Thank so much
 

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.
 

https://forums.techguy.org/threads/access-database-creation.84278/
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.
 

https://forums.techguy.org/threads/access-cant-save-database.302068/
Relevancy 49.02%

Hi all I ve just started a new job and my manager want me to build a access program I have never built a program before or have any great knowledge in doing so but I have work on access before never took a class I have started the program but I think I did things backward Building access an database I created the table just how I want it the form is working fine expect one field I can t get to work how I want The problem is first when the information is inputted into form some of the combo box and bond box with formula do not generate in table second I can t get them to show on queries either last am clues less on what to do with report and queries background information This database have to pull information from an original excel sheet Where working with retirees who is still receiving a discount for insurance discount is base on year of service I will need to generate a report for Building an access database the insurance company and also to our finance company so they can know what to pay to what department I m lost Any help will be greatly appreciated been working on this for weeks nbsp

Relevancy 49.02%

hi everyone
i have question may someone can help me please
if 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

 

A:about Microsoft Access for database

no one can help
 

https://forums.techguy.org/threads/about-microsoft-access-for-database.995144/
Relevancy 49.02%

hi i have a 2010 database with a form which is linked to a table, the form is made up of text boexes and combo boxes, i would like to creat a button that clears the data in the combo boxes only. can anyone help with this,. thanks in advance
 

Relevancy 49.02%

I am planning/trying to build a database that will track the dates certain classes were taken by users, and if the classes were passed or not.

I am very new at Access Databases so any advice, suggestions, opinions, or help anyone can offer will be greatly appreciated.
 

Relevancy 49.02%

Hi,

I have created a new database and would like to share it among my team. However, when another user opens it, it says file already in use. How can I get the database to allow multiuser access.

I need it so that when information is entered it gets updated in real time on other users machines as well.

Please let me know if you have any solutions.

Regards,

Archie
 

Relevancy 49.02%

Hi
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 ?
Ta

Gus
 

Relevancy 49.02%

I tried to open a database but I can't open it. I got an error message "unreconized database format". Is it corrupted? Please help me to fix and how can I open this database. thanks.
 

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%

We have a in house made database here which gives an option to open PDF's while looking at a file, but when these are opened the pdf flashes up then closes immediately, any clues as to why, tried updating and re installing and joy joy

Cheers in advance
 

A:PDF's withing Access Database

You do not say what version of Access is being used or what method is used to open the pdf document.
 

https://forums.techguy.org/threads/pdfs-withing-access-database.1059630/
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.
 

https://forums.techguy.org/threads/access-database-where-clause.297373/
Relevancy 49.02%

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.

--
Burroughs

http://www.bleepingcomputer.com/forums/t/406986/infopath-to-access-database/
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 openoffice.org 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.
 

http://www.techspot.com/community/topics/multiple-access-database.115971/
Relevancy 49.02%

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

The calculation would be actual hours/hourly target

Hope that makes sense

Thanks in advance
 

Relevancy 49.02%

Im creating a database to book both rooms and resources, assign them to staff etc, iv created a barebones system that lets you book the room/resource and assign it to a person on a date, what i need is.. if someone can help that is, is when a date reaches a certain point, say 1 day before.. to pop up a reminder, also.. i need the room to pop up as booked if between dates that are already booked.

Any help would be greatly appreciated,

Steve.