Access Development Extensions
Oct 27, 2005
I am need of urgent help with the following situation:
Currently my project has been developed on my computer with frontend Access, backend SQL Server (on our companys server). Now that I am testing release as soon as I create the package and install it on any other computer it says that it cannot connect to the SQL Server...
Is there something I should add (macro) or otherwise to make sure that it recognises the SQL server and connects?
As a point of note the release will be on the RunTime engine rather than full access.
Thanks for any help.
Phil
View Replies
ADVERTISEMENT
Aug 26, 2005
Hello:
I've been using Access as my database development tool for a few years. Now I would like to start learning how to use Access in conjuction with other tools (such as ASP, vb.Net, etc.) to develop web applications. Can anyone point me in the right direction, offer ideas on how to get started? I don't know how things work between an Access db and the Web.
Thank you very much.
Raneil
View 4 Replies
View Related
Oct 16, 2005
I recently got asked by a friend to set up a database for him to store his business contacts (so he can do mailshots etc) along with some basic order history. I've come up with the basics of this database (attached). There is still some work to do on it, a bit of tidying up and some reports etc but I need to go and see him show him what I've done and to clarify exactly what reports and stuff he wants.
I'm only doing this in my free time but he has said he'll pay me for my efforts. I don't feel I can really charge an hourly rate though as I'm still only learning the ropes and what might take me several hours might only take an experienced developer an hour or even 10 mins! :o
So I guess what I'm asking, is could those of you who are self-employed, or indeed anyone who has some idea of what the going rates for databases are, take a look at what I've done and give me an estimate of how long it would have taken to put together something similar and how much you would charge for it (either in total or per hour).
I'm also sure that some of what I've done could have been done a lot better, so if anyone has any views on improvements I could make, I'm all ears. :)
View 2 Replies
View Related
Aug 29, 2005
Hello,
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?
Thanks,
Redluv@gmail.com
View 6 Replies
View Related
Nov 8, 2005
I am self-taught on Access and have designed a quite basic database for a friend who owns his own company. This is a client contact database designed to hold information about his clients and their companies, but also to send reminders to Outlook when they haven't been contacted for a while - ie. to make my friend more proactive in his business.
This was a project which I originally agreed to work on for a fixed price. Needless to say, I undersold myself and probably because I am self-taught, with the number of hours I have put in, I probably got paid 2p an hour!
The project is drawing to a close, but he wants to pay me per hour for any further development to the system, and for any similar work he wants doing, problem is I haven't a clue what to charge him per hour?
Any ideas, without divulging your well-earned salaries of course!
View 8 Replies
View Related
May 4, 2005
I forked out nearly £600 for Visual Studio.NET Professional Special Edtion, which was advertised as coming with the Visual Studio Tools for Microsoft Office. Which it did. I checked the Microsoft site and they advertised the VSTO as coming with the Access Developer Extensions, so I went ahead with the purchase.
Now I've since found out that the Access Developer Extensions are yet again separate from all this, so I will have to spend more money. That annoys me but I can live with it (I've no choice really), but where can I purchase the Access Developer Extensions CD? I have scoured the web and haven't found a single source, but apparently it does exist. As an additional note, I am based in the UK.
View 5 Replies
View Related
Dec 24, 2005
Hi,
I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it,
I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case.
Sure enough I was right again, Can any one help?
My problem is when I open the custom startup wizard or the custom package wizard it opens a form that is suppose to have templates to choose from so to get started, How ever there are no templates in the form the form is blank. Which leaves me stuck with no options to get started.
All I installed on my PC is the access 2003 developer extensions, did I not install some thing I should of?
Thanks; Any Help will be greatly appreciated.
View 1 Replies
View Related
Apr 12, 2006
Hi,
I wonder if it is necessary for the client machine in which a deployment (with runtime) is going to be installed, to have also installed any Access version or if the runtime deployment licence is enough.
Thank you,
Gilbert
View 2 Replies
View Related
Jun 6, 2007
hi,
how and where can i download Access 2007 Developer Extensions?
or
does anybody knows when it will be released if not so.?
View 1 Replies
View Related
Jul 10, 2007
This is a repeat of an old thread but all the Microsoft links have been broken because of Office 2007
We are trying to deploy an Access 2003 runtime solution for about 6 users and I would *like* to download a free version of the Access 2003 Runtime. Any idea where I might get it from?
Failing that we would buy it but I want to know exactly what to buy/what works/etc Upgrading to Office 2007 is not an option at the moment.
Martin
View 2 Replies
View Related
Feb 20, 2008
Hello,
As some of you probably noticed there is a bug in de access 2007 developer extensions.
When you package your solution and for the root install folder you select (all users) you get a warning when you startup your packaged solution.
When you select current user you dont get a message.
Does anybody know if this problem is solved by microsoft?
View 5 Replies
View Related
Feb 27, 2008
A few days ago I had a Vista-crash. I reinstalled Vista (Ultimate) and
Microsoft Office 2007 Professional. Before this crash, I installed Access
2007 Developer Extensions and it worked perfect. But since I reinstalled
Office 2007, the Developer Extensions option doesn't appear anymore in the
Office button. I tryed with the Access Options - Add-ins - Manage COM Add-ins
- GO - Add - Program Files - Microsoft Office - Office12 - ADDINS -
AccessDE.DLL - OK. This was not successfull: Any suggestions? Thanks
Luc Ringoir
Belgium (Europe)
balloonplanning@skynet.be
View 1 Replies
View Related
Aug 31, 2005
I'm considering re-writing my access97 database to access 2003
and turning it into a self-executing db for distribution to computers that don't have any versions of access installed.
I was told purchasing Microsoft visual studio tools for office 2003, which has access 2003 developer extensions, could do this.
Does any body have any experience with trying to accomplish this? And if so, are there any tek-tips that you can recommend to make this maybe a little easier, I'm not sure what it will do to .mdb file?
Thanks--any suggestions will be much appreciated.
View 6 Replies
View Related
Dec 24, 2005
Hi,
I've finally opened the Visual studio for MS Office systems tools 2003 box and found the access 2003 developer extension CD and loaded it,
I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case.
Sure enough I was right again, Can any one help?
My problem is when I open the custom startup wizard or the custom package wizard it opens a form that is suppose to have templates to choose from so to get started, How ever there are no templates in the form the form is blank. Which leaves me stuck with no options to get started.
All I installed on my PC is the access 2003 developer extensions, did I not install some thing I should of?
Thanks; Any Help will be greatly appreciated.
View 3 Replies
View Related
May 8, 2006
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.
View 14 Replies
View Related
Jan 8, 2014
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies
View Related
Jan 1, 2007
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?
Any help or advice is greatly appreciated.
View 3 Replies
View Related
Dec 5, 2005
I'm after a bit of advice....
Have developed a booking system for a client, Access 2003 adp front end with SQL Server 2000 backend, they want to offer search and view facilities on their intranet and possibly on the internet. Very broad but Simple question, whats the best way to do it ?:eek: having never done any web development....
It will purely be a couple of combo boxes populated from the SQL server for selection, followed by the display of the results, possibly with an email button.
At a loss as to where I should start, can I do anything in Access or possibly ASP.NET or something else ????
Apologies if this is in the wrong thread, and many thanks in advance for any responses,
GRW
View 1 Replies
View Related
Oct 30, 2006
Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication
Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered.
whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that I can't afford not to but hopefully after a couple of biggies like this it will be possible.
Thanks
Humph
View 2 Replies
View Related
Nov 28, 2007
Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get my updates made on time.
Any ideas?
View 2 Replies
View Related
Jul 22, 2007
Hello,
I am looking for some advice on how to go about solving a problem.
I created a database 1 primary table with 1 other table, linked in a form with a 1 to many relationship.
The PK is auto assigned for both tables.
I want to have say three different companies use the same database but with some kind of unique ID for each company so when I bring all of the data together into one database it will all merge but be sortable by the company that created the data.
As some of you will note I thought that defining the PK for each record was the way to go but it seems that this is not going to work.
Any suggestions?
Thanks!
Fen How
View 2 Replies
View Related
Apr 10, 2008
I doing a db that is supposed to show the development plan of some persons.
2 tables:
graduates
departments
in the graduates table there are among other data about the graduates, four fields for their departments in the next year.
i have called them:
rotation 1
rotation 2
rotation 3
rotation 4
these rotations should be choosed from the departments table, so i have created a lookup dropdown list in these fields.
now i want to show a query that shows a list of all the departments with the linked graduates. something like this:
Rot 1: Rot 2: Rot 3: Rot 4:
dep 1: Ben John - James
dep 2: James Ben John -
dep 3: - - James -
dep 4: John - Ben -
dep 5: - - - John
dep 6: - James - Ben
'-' = meaning empty field (onley for illustration in this forum)
My question is how i set up the links between the tables to create a query that show this.
Thank you.
View 1 Replies
View Related
Apr 11, 2007
Hi,
I need to create a Database in Microsoft Access. Can anyone name me 3 different development methodologies I could use?
Thanks.
View 2 Replies
View Related
Sep 27, 2004
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!
View 2 Replies
View Related
Aug 15, 2007
Hi
I'm building a Software Licensing Database & I have come across this particular problem and i am not 100% sure which way would be the best way for me to solve it. So far I have created the database so that a user/software/license can be added to the system. The main form display's users information and below in a tabbed subform it displays the installed software on the machine. On the second tab it displays the license's attached to that machine. On each of these subforms its provides the user to add/delete software/license's however my problem is with error handling within the system. I have managed to make it so that a user can only selelct license's that are specific
Each License can cover anywhere from 1 to <x-amount> of pc's. What I want to be able to do is the user can select a license if their is 1 available and a small text box which denote's how many license's are available. So i know im going to need a license count which is easy enough using a SUM within a query. It is the error handling that im stuck on. I need to create a statement using the 'equal to or greater than' operator if possible saying
If NumberofLicenses >= then add license
Else If vbOKonly message - "Insufficient License's to cover this piece of software please purchase & add the new license to the system then try again"
Something along those lines.. I just dont know where this would go or how to write it! If anyone has a better way of achieving this.. fire away im open to ideas!
cheers
Ally
View 1 Replies
View Related
Mar 23, 2007
Has anyone heard when the 2007 Developer Extensions are going to be released for download?
View 1 Replies
View Related
