Search results

:confused: I am trying to create an xml file from a query. I ran the query then selected Export - xml file (using Access 2010). The query generates 637 recs having 9 columns. While it takes about a minute to process, I am only getting the following in my xml file that gets created: <?xml...

Could someone please help me with this problem? :confused: I have the following stmt: DoCmd.TransferText acExportMerge, , SelectedQuery, DataDocFileName, True. Whenever I run it, I get an error msg that the Access engine could not find the DataDocFileName. I've checked it and know it is...

Microsoft database engine could not find the object ""...." when running mde I was having a strange issue - and was writing up this message, when I figured out the problem. just wanted to share in case anyone else has a similiar one: I am using timers to close all forms except the login...

I have Access 2003 linked to SQL Server 2005, - used to have Access backend and now must move to SQL Server . I am testing what happens if errors occur - When testing by deliberately creating a duplicate record in my form, this error came up ODBC Call Failed (# 3146)- and, it also includes a...

I have recently moved a DB over to SQL Server - still using Access as front-end (linked tables). 2 fields having trouble with in SQL Server are both defined to not accept null values and have default values defined as such: ie ('No Donor'). If I remove a value from one of these fields via my...