If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble with Access Links
Hello,
I have downloaded the add-in access links and followed all the installation steps. When I try to open access form in excel it says there was an error and it could not open. Has anyone else encountered this? Second question: I wanted to use this to create a form for a worksheet that I'm going to put on a network server so a group of users can get to it. Has anyone had any problems or had any success? Thanks, |
#2
|
|||
|
|||
I really wouldn't advise using Excel as a database (which is what it
sounds like you are trying to do). Why not put the data in an Access table and use an Access form. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
These were log sheets that one of our department fills out and then passes to
me. I have the information in an Access database but I'm having trouble getting it to run on the network and not everyone's computers are able to run it away. So till I get everything working properly for the database; I was trying to create them an online version that they could enter the information on and I could just import it to the database. I can just create the form in excel but I saw this add-in and thought it would be so much easier. Thanks for your thoughts!! "Bill Manville" wrote: I really wouldn't advise using Excel as a database (which is what it sounds like you are trying to do). Why not put the data in an Access table and use an Access form. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
OK - that makes more sense.
I think I would have tried one of the following: - give those who haven't got a licensed version of Access the Run-time version of Access instead and use the Access form. - build the form in Excel and write a little code to upload the information to Access via an INSERT query or a Recordset But there's always a variety of ways to achieve ones goals Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 02:15 AM |
How to stop opening of multiple instance of Access 2000 after upd. | Taika Bilbo | Database Design | 9 | January 12th, 2005 08:34 PM |
MICROSOFT INVESTING HEAVILY IN ACCESS | Mike Painter | General Discussion | 39 | October 15th, 2004 03:56 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Turn Excel spreadsheet links off from an Access database | Ricardo | New Users | 2 | May 19th, 2004 01:30 PM |