Microsoft Access & Microsoft SQL.

Aug 7, 2006

Questions / Help :

What I would like to know about Microsoft SQL Server & Access 2003 :
I am a novice at creating my own database.
I would like to use Microsoft SQL Server & Access 2003 .
I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 .
Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003.
I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness.
If you intend to reply, please be very specific & in plain English.

Can someone help me ?


1Can Microsoft SQL Server 2000 work with Microsoft access 2003.
a.Is this do-able .

2Can Mysql also work with Microsoft access 2003

3What is the difference between Microsoft SQL Server & Mysql.

4And any other information that may help me.


Thank You For Your Time.
John Calcitrai.

View Replies


ADVERTISEMENT

HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL Statement Expect

Mar 27, 2007

My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:

We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.

I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.

When I try to upload a file to the script I get this error:

Line: 42
Char: 7
Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'.
Code: 0
Url: (URL address blocked: See forum rules)

Here is the part of Connect.asp that errors:

Code:<script LANGUAGE="javascript"><!--var DSNString, TheDF, TheRS;//DSNString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C: hedata estdisbo.mdb;User Id=admin;Password=;";//DSNString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C: hedata estdisbo.mdb;Uid=Admin;Pw d=;"DSNString = "DSN=testweb; UID=; PWD=";function public_ConToDB(){ TheDF = DP.CreateObject("RDSServer.DataFactory",this.text1.value);DC.DataSpace=DP;DC.Server = this.text1.value;DC.Connect = DSNString;//DC.Connect="d: hedatadisboweb.udl";}function public_GetRS(SQLCommand){ TheRS = TheDF.Query(DSNString,SQLCommand);DC.SourceRecordset=TheRS;return (TheRS);}function public_GetDC(){ return (DC);}//--></script>

Its included in a file called FileRead.htm here is the part that refers to the error lines:
Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");

I set an alert after this line but it doesn't pop up.

ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.

Sincerly,
Joseph Russell

View 14 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 1 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 13 Replies View Related

Microsoft Access HELP!

Apr 25, 2006

Ok so I have a new project. I have run all queries and appended them to my tab inventory. My mission is to take all of the query's and create a table that combines all missing parts info (I.E.> date, part#, plant, location, inventory, reorder pt.) How do i do this and if you need more information please message me back. I would greatly appreciate any help.

View 2 Replies View Related

S.O.S!! Microsoft Access !!!

Jul 4, 2007

Hi guys,

I need help with microsoft access!

I have a report writer in access which i use to generate reports from act! (a CRM software by sage).

Recently, there has been some changes and development in act! software (we added new fields into it). I am trying to update the tables in access with the new fileds, but am not able to do so.

Kindly request for some assistance.

View 9 Replies View Related

Microsoft Access Authentication

Oct 4, 2005

For a databse which I am going to create, I would like to have an authentication system which utilises the database users which I specify, however instaed of using a password the idea would be to use a fingerprint scanner to logon. T^his would be for an A - Level IT project and I would seriously like to know how to integrate biometric security into a database. If anyone knows how to do this please post CLEAR instruction possibly with some SCREENSHOTS if possible.

Thanks

View 1 Replies View Related

Microsoft Access Security

Jul 26, 2006

This query is in relation to an Access 97 database.

A problem that we are consistently having is that whenever people are using the database under different user names, it only allows one user at a time to use it. So basically if three of us are on it updating files or enquiring on client details, two of us are locked out leaving only one in. Any help in this matter is greatly appreciated.

View 1 Replies View Related

Doing Exam On Microsoft Access...

Feb 8, 2007

I'm not doing one this minuet but I would still appreciate help.

the exam is in the UK and with AQA.

does anyone know of any sites which will give me tasks to do to test myself.


Thanks in advance:D

View 8 Replies View Related

Synchronisation In Microsoft Access

Jun 2, 2007

Please consider the situation below:
There is a central server and there are many client PCs connected to the server. On each client PC, there is an access database file that will be frequently updated by the user of the PC.

What I want to do is to allow the user on each of the client PC to backup their database file to the central server;

At the server side, it is free to use any architecture(eg using file system or another database to store the file) to facilitate the backup purposes. One of simplest solution is to upload the entire database file to the central server everytime. However, the problem is the access database file on each client PC is quite big, hence it is better not to upload the entire file but only to upload the updated data to the central server.

Is there a way to synchronise the data with central server without upload the entire database file? What kind of architecture should built up in the central server if there is a way?

Any input is welcome:)

View 5 Replies View Related

Microsoft Access And The SCCI

Aug 3, 2007

Hi there Access forum,

First up, a pre-emptive request to excuse me if I show my ignorance - I'm not really an Access user/developer, I'm a SCM person.

We have a team that develops Access dbs and they are looking to integrate better with ClearCase. At present, they use the UNIX client and transfer whole, binary Access dbs, then source-control the binary file. They would like to be able to integrate better - my understanding, from them, is that VSS will control individual tables/forms, etc. I assume this is because it integrates via the SCC interface.

I cannot find anything about the SCC interface in my Access tool (just part of the Office distribution handed out to all desktops here) apart from a reference to Office XP Developer.

Can anyone provide me with any more information (even if that is just to point me elsewhere)?

Using VSS is not an option, by the way - the SCM standards specify ClearCase or Subversion (which would access the SCC interface via the PushOK proxy).

Thanks in advance - Adam Cheney

View 2 Replies View Related

Microsoft Access To Word, Please Help

Nov 9, 2007

Hi there, I am doing a project for my A level computing, and for my mum's financial advising.

I am to assume no knowledge of computing on her part, and so i cannot make it up to the end user to know how to mailmerge.
I was wondering if you could help.
I can have it in a query, form or table form, whichever is best for this, but i need to be able to make a button which exports a record into a MS word mailmerge. This is just to make a simple letterhead. I need a button that says " Write to client ", and once it is clicked it needs to open a letter addressed to them. This is my problem. I have noticed when the data is in a report, there is an export to MS Word button, which is very close to what i want as i could use that and get a good enough mailmerge, but is there a way to run this from a macro or using VB? I did VB last year for my computing project and so i understand a fair amount of it. I want to just make one word document, which will open as mailmerged with the clients data.
Please help if you can, I am sure it is possible as i can see you can mailmerge from access, and there is even a button to do it.... kind of, i just need to be able to make my own.
Thankyou so much for your help.
Steve
( Microsoft Access 2003 )

View 1 Replies View Related

Microsoft Access HotKeys

Jan 23, 2008

Greetings All,

I work for a College within my area and have recently been asked to create a database for storing and testing data. With mild experience, I believe I have done well so far but a co-worker asked me the other day if there was a way to create or modify the hotkeys in Access. I've tried researching this on the Net and only found lists of which hotkeys do what. If anyone knows whether or not adjusting hotkeys is doable, please let me know.

Thanks for your time and have a great day...

Kyle

View 4 Replies View Related

Microsoft Access Help Needed

Jan 11, 2005

Hello there

I am trying to sort out some data. Because it is too huge for microsoft excel, I have to use Access to open it. But when I managed to open the data and wish to edit the data, it keep popping out this message "Updating data in a linked table is not supported by this ISAM"

Can anyone help me to sort this out?


Thank you very much

View 2 Replies View Related

Microsoft Access Combo Box

Apr 28, 2005

I have 2 combo boxes. When the form loads
the user selects a value from the combo box if the value is
not 10 or 99 i want the user to be able to select a value from
the list in the combo box else i want it to put in 0, 173 respectively
when i put the formula in the control source i can get the values
0 and 173 to work but if the user selects a different value then
i am unable to select any thing from the list?? can someone please
help me
thanks

View 1 Replies View Related

Microsoft Access Database

Mar 14, 2008

hi everyone i just want to ask how to create a database microsoft access and connect it to my webpage...like for example a certain content in my web is downloads (music, videos etc.). then i want to add another music in my web..how can i do that in microsoft access
hope u can help me guys...thanks!

View 1 Replies View Related

Search Function In Microsoft Access

Jan 12, 2006

Hi everyone,

Thanks for taking the time to read this.

I will firstly give you the low down on the business that I am doing the database for. It is a Car Restoration Business, where we deal with vintage/classic/muscle cars and restore them to the former glory.

I do not know Microsoft Access very well, I have attached a file with what I think is a databae I could be wrong. The main function of this database is to search for suppliers for a specific car part for a specific car.

So if I want to find a doorhandle for a 1970 Ford Mustang, I need the suppliers pertaining to those criterias to come up.

How do I get this to happen?

Thankyou for your help

Jess

:confused:

View 1 Replies View Related

Microsoft Access And Date Formating

Mar 13, 2006

Hi,

I am having trouble with the format of dates comming from access, if I view a table in access with a field of Date/Time the date is formatted correctly as dd/mm/yyyy, but when I retreve the date from my ASP page the format changed to mm/dd/yyyy. I can successfully change the format using a date format function but is there a way of getting access to send the date in the correct format in the first place or know why it's doing this. I am using access 2003 and the following connection string

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:webSites estWebdataBasefcd_db_080306. mdb"

Thanks for any help and guidance you can give

Joolz

View 1 Replies View Related

Microsoft Access Startup/Pop-up Questions

Jul 27, 2006

I have a database that will be used by a few users who are not very comfortable with Microsoft Access. I have a login screen and a introduction/splash popup. I was wondering if it is possible to bypass the Microsoft Access pop-ups that ask the user if they want to "block unsafe code.." or The security popup that says "This file may not be safe" so that the users go right to the login screen I created within the database. I am worried that there will be variations in answering/clicking these Microsoft Access questions thus causing a variety of complaints when trying to access the database. Thank you

View 1 Replies View Related

Microsoft Access Cannot Open This File

Nov 15, 2006

Hi,
I am trying to open an access database (Access2002) from my computer ( C: est )
and I receive the error :
Microsoft Access cannot open this file.
This file is located outside your intranet or on an untrusted site.

how can I fix this problem ?

regards,
Jam

View 3 Replies View Related

Microsoft Access '97 Error Message

Jan 15, 2007

Does anyone have any suggestions on how to address the following error occurring on my Microsoft Access ’97 database?

Error message: “Out of Memory”

Any thoughts on why this error occurs or what can be done to prevent it.


Many thanks

View 4 Replies View Related

Microsoft Access Cannot Open This File

Feb 14, 2007

We have a database on our network server which I cannot open. I get the following error everytime I try to access it.

This file is located outside your or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location.

I think it has to do with a Microsoft Jet 4.0 Service Pack 8 security update. However, I cannot find the update to uninstall. Others can access the database located on the network, but some get a pop-up that allows them to say "no" and access the file. The pop-up has the following message:

Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?

Can anyone help with this?

View 10 Replies View Related

Creating A Microsoft Access Database

May 17, 2005

I'm not too hot at creating a database in Access, so I was wondering if there was anyone out their prepared to help me construct one.

This database is designed to search for property from various locations and from various price ranges, you can also pick the type of property, the amount of bedrooms and have the result in descending or ascending order.

For location just use: Location 1, Location 2, Location 3, and Any
Price Ranges use: 30,000, 50,000, 70,000, 90,000, and 110,000
Type of property please use: houses, flats, and bungalows
Bedrooms use: 1, 2, 3, 4 or 5+

Fill in any data you wish, I think this needs to have a query setup?

Thanks for your help
Chris Green

View 3 Replies View Related

Microsoft Access Coursework Problem

Apr 8, 2008

I am currently doing my A Level ICT Coursework, my exam board is AQA.

The problem i have encountered is as follows:

I have a form, containing a sub form, within this subform i have a macro which i want to take me to another created form but when doing that copy a certain value in a record across to the new form.

For example.

Subform - Orders
Record to be copied - Order Quantity (within the sub form)
Macro button pressed within the sub form
New form opened
Record in the new form - Adjust Amount (this is where i want the copied data to be input.

Thanks in advance

Nathjones89

View 1 Replies View Related

How To Design A Form In Microsoft Access?

Aug 10, 2007

Greetings. I have the following problem:

I have a list of about 200 crops on a column, and for each crop I have 6 information (income, amount of land, season, etc.) in the following 6 columns. I have this information for about 100 households in 6 villages.

I am now starting to put these info in the computer, and it is an enourmous task. I thought that one way to do it is design a form in Access, and have one file per village. I then want to analyse the data at the household level for each village, and also analyse the data at the village level (after calculating village averages).

I want to recreate the form I used to interview farmers in Access, but I can't figure out how to make Access automatelly have 7 columns in form view (the first with the name of the crop, the next 6 with the information: income, etc.). The idea is to reproduce as closely as possible the form I used to interview the farmers, so as to facilitate the data-entry.

Does anybody know how to let Access automatically sort all the fields into 7 columns? Of course I can design the form manually (putting each field individually in its right place), but then I have 7 x200 fields to move, and it would take a huge amount of time. I can't believe that Access can't do this automatically, but I can't figure out how.

I then plan to transfer the info for analysis to SPSS. Does anybody foresee a problem?

Do I make sense? If anybody can help, I would be very grateful. This is actually very urgent, because I am going to pay somebody to do it, but I have to tell her how to do it over the week-end. Thank you very much!!

View 3 Replies View Related

Microsoft Access Was Unable To Create An MDE Database

Mar 31, 2006

When trying to create an MDE using Access 2002 I get the message

"Microsoft Access was unable to create an MDE database"

The database is split and in Access 2002 format.

Could this be anything to do with References? I say this because I recently downloaded a dll for Redemption to make use of the SafeOutlook Library

Thanks

Oliver

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved