DataBase - Access
Asked By qwerty
18-Nov-09 03:09 PM
I have a couple users that are getting this error message when they are
trying to import excel into access "You entered an expression that has an
invalid reference to the property"
Anybody have any ideas why this is happening?
Thanks
Access 2003
(1)
Office
(1)
Excel
(1)
Bontrager
(1)
MeIt
(1)
Externaldata
(1)
Spreadsheets
(1)
Times
(1)
Jerry Whittle replied to qwerty
We need a lot more info to even take a WAG.
Is it the same Excel spreadsheet or all spreadsheets?
What happens when someone else tries to import the spreadsheet?
Exactly how are they doing the import: Macro, code, manually.
And the big question: What version of Access?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
qwerty replied to Jerry Whittle
Hi Jerry,
Thanks for getting back to me
It is any spreadsheet they try to import to Access. They import their
spreadsheet
manually ever time. This is only happening to 4 users in a corporate office.
I have
try reinstalling several times with no luck. If the users goes to another
computer
they are able to import the spreadsheets with no problem. It is just their
own PC
that are having the problem. This just started happening about a month ago.
They are using Access 2003 and also the computers that are able to import the
spreadsheet with no problem are using Access 2003.
Jerry Whittle replied to qwerty
Unfortunately it sounds like their machines. Sometimes reinstalling does not
help. I have had to wipe a computer's hard drive and completely reinstalled
everything from the OS on up to get things to work right. If those users are
due a new computer anytime soon, this might be another good reason to do so.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
AccessVandal via AccessMonster.com replied to qwerty
You might want to Repair MS Office in the Control Panel - Add and Remove
Programs. Try to repair from there first. I think is Change or Repair.
--
Please Rate the posting if helps you.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200911/1
Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1
Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1 Office 2007 (1) Office 2003 (1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access
2010: Essential Diffs? DataBase Sounds like Access 2010 is something of a different animal from preceding versions. Could anybody generalize the big issues? - - PeteCresswell Access Discussions SQL Server (1) Virtual PC (1) Windows XP (1) Visual Studio 2010 (1) SharePoint (1) Access 2010 (1) Office 2010 (1 Access 2007 (1) One starting point would be to browse Access team's blog. http: / / blogs.msdn.com / access / default.aspx Click on "2010 Intro Series" tag, which is high on the top of code will run and fire. In fact you do not even have to have a Access installed on your computer. This is a true engine level store procedure and trigger system
Access 2010 with Sharepoint 2010 DataBase I found this article http: / / sharepointproconnections.com / Articles / tabid / 149 to me was these two points: client." Hopefully this means you can test out the Access 2010 in a browser capabilities. 2.0 AA compliance. Level 1 browsers, which support 100 on other platforms. Level 2 browsers will have some limitations in rendering and behavior." Bob Access Discussions SQL Server (1) MySQL (1) Visual Basic for Applications (1) SharePoint (1) Access 2007 (1) Access 2010 (1) Office 2003 (1) Windows 7 (1) Well, the question is do you really need to go to that that version of shaerPoint. Sharepoint becomes a new target environment for us people building office automation applications. The standards and feature set will use for the cloud is going to
Considerations migrating from Access 97 mdb to Access 2003 (or up)? DataBase What are the things I need to watch for? I know about sheet properties and Sandboxing mode and making sure to run Jet 4.0 SP8 for 2003 but what else should I look for? We're kind of at the end of the road (so it seems) with Access 97. It does not play well with Windows 7 Professional even in XP Mode, the is crashy / unsreponsive at times. I figure moving up to a more 'modern' version of Access can help alleviate some of these problems and allow it to run native in Windows XP mode. So I am all ears for recommendations on migration or ways to get Access 97 to work properly in Win 7. Thanks a bunch. Access Discussions Visual Studio .NET (1) Windows XP (1) Office 2007 (1) Access 2007 (1) Access