Exactly what do you have in the expression for the OnLoad event on the form? The error message you are getting indicates that it can't find anything in the...

Thanks for letting us know you found a workaround. As a rule of thumb we always try to put the data in SQL Server (except in very specific situations),...

sgmunson (5/1/2012)

I'm hoping to find a provider that works for OLEDB or ODBC on that SQL instance so I can import data from MS Access directly instead of...

You shouldn't have any problems connecting to SQL Server either with an .ADP or .MDB version database. We do it all the time. If you are using ODBC,...

TravisDBA (4/27/2012)

david.wright-948385 (4/27/2012)

As father to five: carpenter, salesman, psychologist, geneticist...

I've been in it pretty much since the beginning (remember paper tape?), sort of out for a decade plus being a manager of techical people, retired and started a consultancy,...

I should have added this on my original reply. If you do get a resolution to your problem from another source, it would be helpful to others to post...

Since it is an ADP, all forms and reports will be using either SQL Server views or stored procedures as their data source. Note however that some of those...

You can tell what type of database the Access front-end is from it's file extension. Prior to 2007, there were four common ones, .mdb and and .adp, and .mde...

Sorry - the day got more than a little crazy. It sounds as if you may have an ADP format database, which connects directly to SQL Server. But...

You do have SP1 based on that version number, and I am not aware of any hotfixes published subsequently that deal with Excel export issues. Access pivots have never...

There were some issues with exports to Excel in the initial release of Access 2010. Most of those were resolved with SP1 when it was released in mid-2011, so...

OK - that's a result of the difference in the way that SQL and Access represent True. In SQL it's a +1 - in Access it is a -1....

Is the Option Group bound to the correct field (you have the button selected in your screen shot)? That's one possibility - another issue with Access and SQL bit...

What version of Access are you using (2007 or 2010)? Also what sort of network are you connected to? The easiest way to connect to a database is...