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,

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

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

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