Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Access in Excel | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |