I have basic knowledge of microsoft Access and do very little with script and coding. I also design websites and can code in HTML and have good skills in Dreamweaver etc.
If I want to create a database driven website is Visual Web Developer 2005 a good software choice??
The way I see it the software will allow me to use my design skills and database knowledge to create the data driven website without needing alot of knowledge about MYSQL and PHP etc.
I have developed an Access mdb file with lots of tables, forms, queries, reports, and VBA code. I want to be able to distribute this to Access-less users. I understand that the Access Developer Extensions enable this to be done and that the two wizards assist.
My first question is this: Are the Access Developer Extensions and the two wizards included in Visual Studio 2005 Professional Edition?
I ask because this is what was recommended by a Microsoft representative and is what I’ve purchased. This came along with something called MSDN Library, but I’m not sure what that allows me so it is possible that this library will contain the elements that I’m searching for, but so far I’ve not found it.
Are the Access Developer Extensions only provided as part of the Visual Studio for Microsoft Office Tool package, as I’ve seen referenced in several forums and articles, including yours, or are these in fact part of other tools, such as the Professional Edition of Visual Studio that I’ve purchased?
I have a user running office 2007, with a program called Dev_Tracker wthat uses a front end of access 2000. This program allows a user to log in their project hours. The skinny is that when they lauch the program and try to make an entry they receive this error message:
Run-time error 3075
syntax error in date in query expression tbl_timesheet.weekof=#2.4.2008# AND tbl_timesheet.user=dworden.
If the user logs into another machine it works fine so it appeare to local to the machine. I have cleaned the registry and done other tweaks but no luck.:confused: Any ideas would be helpful.
Hi, I have created a database with Office developer 1.5 and I am having problems creating my runtime version. I have been told that the VBA included in this program wont do the job, that I must purchase a full version Visual Basic 6.0. Is this true? Thanks all
I'm trying to locate the Developer Extensions so that I can compile my Access 2003 application to distribute to my end user.
I'm getting totally lost in the myriad of documents and links on the MS website that keep sending my round in ever decreasing circles. I've downloaded Visual Studio Express - Visual Basic Edition but can't seem to find it in there.
Can anyone point me in the direction of the software that I need to be able to distribute my Access 2003 applications.
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)
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.
Can anyone tell me how to do a date formatting that will change 5/10/05 into May 10, 2005 in a table and report? Or do I have to use a text field instead? Thanks!
The company are using Access 97 as the front-end to a SQL2000 database. Tables are updated, queries run and forms used. They are moving to SQL2005 but not considering updgrading Access 97. Will the current queries, forms etc still work? Thanks.
When using 'ww' as the criteria in the DatePart calculation it will not accept 1 for 6th Jan 2005 which is week 1, you have to enter 2 and it will select it, in fact all the weeks so far in 2005 are out by 1. To cure it you can add on -1 to the query and it works fine until you go back to the previous year and it screws up those dates.
I'm trying to set up an access 2000 .adp project connecting to a SQL server 2005 database. I can set up the connection ok, but once I have completed the setup process, I can the following error messages if I try to creat any new database objects:
If I try to create a new object (a view or table etc), Access tells me that:
'I do not have exclusive access to the database at this time. your changes will not be saved.'
If it's a view, I then get the following message:
'The Visual Database Tools within Visual Studio 6 and Access 2000 do not support some new features of SQL Server 2000. Because you are manipulating an object in a SQL Server 2000 database, some operations will be unavailable to you. In rare cases, you might not be able to save the database object you modified. In other cases, you will be able to save the object, but its previously existing settings for features new to SQL Server 2000 will be lost. In most of these cases, you will be warned if the Save operation will eliminate existing settings or property values.
For a complete description of the interaction between SQL Server 2000 and Visual Database Tools within Visual Studio 6 or Access 2000, see Microsoft Knowledge Base article Q266277, "Using Visual Studio 6 and Access 2000 Visual Database Tools with SQL Server 2000." Knowledge Base articles are available in the MSDN Library Visual Studio documentation or at http://support.microsoft.com/support/.'
To supress this message next time you design a SQL Server 2000 object from Visual Studio 6 or Access 2000, check the following box.
Finally, I get the following error.
'You are connected to a version of sql server newer than sql server 2000. save will be disabled'
Obviously I want to be able to creat and save new objects.
Can anyone help? I've sone some searches on the MS support site, but have not found anything that appears to be relevant.
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.
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
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
We are looking for an Access Developer for a small business. You must be in the New York City area and willing to come in for an interview. I will check this board every 1-2 days.
I must say when I read stuff about access which is all in vb I get to thinking that I can`t call myself a database guy.
I create a lot of databases for my company which allow people to gain sales history data for customers, enter and view visits to agencies, enter data for phone calls, process product returns, access and display requested data from the main sql server, suffice to say there isn`t a department in the company which doesn`t use one of my databases.
However I have to admit that there is almost no vb code in these databases even though I`ve attended a vb course (I have forgotten all of it as I`ve not used it). It`s all done with queries and macros.
I like to think that these databases work well and fairly quickly. I find it fairly quick to work with queries and macros.
So what do people think is the big advantage of code? Am I just a lazy chuffer who should go hang my head in shame :o
I was wondering if there's an easier way to getting the "developer's extensions" so I can deploy my program as a PROGRAM rather than an .mdb file. I don't really feel like shelling out $600 for a "subscription" to MSDN. Or maybe there's an easier way to deploy the program than using developer's extensions? I'm using 2003. Thanks!
I have an Access application I need to package for redistribution. Following the instructions on MSDN, I purchased Visual Studio Tools for Office 2003 to acquire the Access Developer Extensions which include the Package Wizard.
After installing VSTO, I found that Access Developer Extensions are not included. Can anyone tell me where I can get a copy of Access Developer Extensions? Is the Package Wizard available for download anywhere? Perhaps someone with an MSDN subscription would be nice enough to make this available to me?
Are any instructions availalbe for creating an installation file for an Access MDE file and including the Access Runtime?
Im trying to use the developer extensions in Access 2003 to package my database with an installer, now when packaging the database you get the option to include an MDW security file however this then copies the MDW on to the users PC
and refernaces the MDW on the users C drive in the shortcut in creates. How can i get it to referance my MDW file on my server ? so when i need to make changes to group permissons ect these can be made in the MDW on the shared server
Is there anyone based in or near Nottinghamshire (UK) who would be interested in reviewing the current database system we use at our office? We are a skiing holiday company and the database is fairly complex.
It was created about ten years ago and over time has had various bits and pieces added on etc. and I am under the impression it is currently a mess!
I am looking for a professional database developer, not an amateur who fancies themselves as such! If anyone can help, please post your details and credentials and I'll give you a shout.