Microsoft Monopoly Means No Documentation

Sep 19, 2004

I spent a great deal of time trying to load up a picturebox with an image stored in an Access data base.

The thing that was most troubling was the complete lack of documentation.

Every feature that exists in VB or Access had many, many man days spent in development. Which means that someone has extensive documentation on it.

Yet, when I went to Microsoft web site to look it up, I was told my product (access) was not supported in the us, but rather I had to pay $99 to speak with someone.

It is a shame that the Microsoft monopoly is able to steal from the consumers and the little developers. Not to get to political but i think it is unfortuante that the bust up of microsoft was averted. It is really a drag to the little developer the lack of documentation and proper development of so many features of their products.

Perhaps I am missing something but is there a place to find proper documentation on the various components - with examples of use?

View Replies


ADVERTISEMENT

Does Anybody Know What This Means?

Mar 15, 2006

Danny,

Below is a outline of the new application that I would like you to write.

In a nutshell, this application will test the connectivity to specific network dirves/directory and display whether the connectivity test passed or failed. I see this as something that automatically runs once started then displays the results. Understanding "error" handling will be an important part of this.

Test cases to include:

a) Tag Inventory System = W:Company Shared DataTagInv
b) Maintenance Stores System = W:Company Shared DataEngineeringMtceStores
c) Customer Information System = Z::CustInfo
d) Sales System = Z:SalesSys
e) Alfak Database = ODBC connectivity to Alfak/Gupta database
f) etc

The test cases are to be in a table for ease of editing rather than hard coded.

Please review this and come up with a skeleton design on paper on what you think I want based on the above and we will discuss tomorrow at 9am.


-----Can somebody tell me what he intends for me to do ? I am kind of confused

View 1 Replies View Related

Can Someone Tell Me What This Command/method Prefix Means??

Apr 6, 2006

Hi

I am new to VB.

Can anyone tell me what the 'ac' part of a method, such as 'acReport', actually means. I am guseeing it may be something like Active Command or similar.

There is no other reason that curiosity for me wanting to know this...or is there??

Thanks in advance

View 1 Replies View Related

Tables :: What Means A Table To Appear As Entity On Diagram

Nov 16, 2013

what means a table to appear as an entity on the diagram? And how to identify the cardinality of a relationship and how to specify which is mandatory and which is optional.

View 5 Replies View Related

Index Documentation

Apr 6, 2007

Have the situation where a database backend is on a number of sites and if changes have to be made to the design structure of the backend database I would like to run a VB generated report to check that all indexes are correct. While this is not an issue with single field indexes, I have issues with multi field indexes.

Has any one got some ideas on reporting on this?

Thanks

View 11 Replies View Related

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

How To Keep Track Of Documentation For BE / FE Revisions

Apr 1, 2007

Hello everyone,

I have been wondering about how I'm going to keep track of revisions for one of my databases.

Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the FE. All table data in stored in the BE and linked to the FE.

I have recently got my act together and started documenting all the revisions I make to the BE and FE of the database. To do so, I created two tables with the following fields:

RevID (PK Auto increment),
RevDate
RevNumber
RevisionNotes
TimeDateStamp


I called them tblRevisions_FE, tblRevisions_BE. I placed both tables in the BE.

Whenever I make changes to BE / FE, I record it in the appropriate table.

However, because I often work on the FE of the database off site, I don't have access to the BE table (tblRevisions_FE) to record the new changes for the FE.

One alternative I thought of was just recording the revisions in a text document, and asking the client to manually record these in the tblRevisions_FE (via a FE form).

I did have tblRevisions_FE located in the FE, but when each db user got a copy of the FE, there would also be 4 copies of the table floating around.

Does anyone have any suggestions about how to manage documentation of FE revisions in this situation?

View 9 Replies View Related

Creating Database Documentation/help

Apr 25, 2005

Hi I need to create a documentation - help system in my Access database. Can you give some guide lines and tips? General of course... like how to link a help file or something like that...
thanx for the helping hand

View 2 Replies View Related

Crerating A List Of Queries For Documentation

Jul 17, 2006

I'm attempting to create documentation for an existing Access database - literally, it's a work-flow document.

It was relatively easy typing out the list of tables, modules, and Macros, but I have god-only-knows how many queries.

Is there any way to export a text list of query names to include in my documentation?

Regards and thanks!

Susan

View 3 Replies View Related

Examples Of System Documentation Needed

Oct 7, 2004

Hey all,

I was wondering if anyone has an example of a system documentation that could be shared. I'm about to start writing one myself and I'm not sure what to include in the documentation. Thanks in advance!

Regards,
Swee

View 2 Replies View Related

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

Aug 9, 2005

Can I connect to money using A97?

View 5 Replies View Related

Bloody Microsoft...

Jan 14, 2007

Any one come across this problem recently?

Latest windows update recommended installing Internet Explorer 7.

Well, why not. Installed, checked it out, big deal.

Went to open a db on a networked computer at home, one that I had been playing with all afternoon, and got this...

Microsoft Access will not open the file due to security reasons as the computer I am accessing is not a trusted source or not part of my intranet.

http://members.dodo.com.au/predatorsoftware/images/security.JPG

So now I cant open the Db from my laptop.

Does anyone know how to make my networked computers "Trusted"

Signed

Pssssd Orff

View 8 Replies View Related

Microsoft SharePoint

Jan 22, 2007

I am running Windows Server 2003 for my company and require Microsoft SharePoint.

I've had a look on Microsoft.com but it confuses me with all kinds of stuff....

What do i need?

View 2 Replies View Related

Microsoft Question

Jan 16, 2008

Ok. This has nothing to do with Access, but I couldn't find a website that would give me fast feedback on this problem.

I am trying to open a file in Microsoft Word, but it says I need to install a Microsoft Office Words converter. Anyone know where I can download this ONLINE?? I have version 2003.

Any help would be appreciated.

View 5 Replies View Related

Microsoft Web Browser

Aug 29, 2005

Hi

I need to be able to do the following things with the Microsoft Web Browser:-

1. Back page
2. Find what the current pages
3. perform code on load of a new page

Help

Sean

View 4 Replies View Related

Microsoft Forms....

Dec 28, 2005

Hey,

i got a form patient information and in that form there is an unbound text box, when you click the box a form opens showing the medical history.

i can easily do this but i have come across a problem.

on the patient info form i want to go to patient id P003 and then when i click the unbound text box i want it to open up the form showing the medical history of patient id p003 not p001 the first field.

does anyone knw how to do this and could some one help me..

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

Microsoft Excel

Oct 15, 2006

How can I use Microsoft Excel to creat my useraccount and assign passwords for keycards

View 1 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 Jet Database Error

Jul 27, 2005

I had a fully working database that I decided to clean up by standardising naming formats etc. I have changed the tables names and changed all VBA links etc to the new table names.

This all appears to work fine. The database is still doing exactly what it should be doing. The only problem is whenever a record is updated I get the following error,

"The Microsoft Jet Database Engine cannot find the input table or query, "***". Make sure it exists and that its names is spelled correctly".

Where the missing table is the previously renamed table. All the updates etc work correct to the renamed table but I get this error whenever it is updated. I tried renaming the tables to their original names but then I got the same error for the new names.

Anyone got any ideas or will I have to rebuild the database.

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







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