|
|
 |
| Home » Forums » DBManager General |
|
|
| access queries. (1498 previews) | |
| access queries. | Posted in 13th, 07/2005 02:38 by access  |
| When I try to copy a table from a ms_access database to another engine I get the 'cannot execute select query'.
I get the same message when I try to run a query on the access database. I have attached several different ms_access databases and I get the same messages. I am running enterprise 3.0.3 with the access engine component on xp. grono04 |
|
| Re: access queries. | Posted in 13th, 07/2005 10:16 by support |
| Hi,
Instead of dragging/dropping the tables out of MSAccess you may try using the DAO Import Wizard. The reason for that is that the wizard does a lot of extra work in order to convert the structure before writting it into the target database. Does the same error happen if you execute a query into the Query Editor? I.E. SELECT * FROM [mytable] Is the Datasheet opening correctly for MSAccess tables? PS: We are about to release DBManager 3.1.0. THis version brings the new Data Migration Wizard, which is not being used as default drag/drop operations. THis wizard does all the work required for moving data and structure from one engine to same/another database. Best Regards, Support / DBTools Software |
|
| Re: access queries. | Posted in 13th, 07/2005 07:25 by access |
| SELECT
[CARDS].[*] FROM [CARDS] From this query I get 'The select statement icludes a reserved word or an argumant name that is misspelled or missing, or the punctuation is incorrect' grono04 / |
|
| Re: access queries. | Posted in 14th, 07/2005 09:57 by support |
| Hi,
Ops, this is a bug indeed and it is fixed for the new version. Actually it fails on other engines too. The new version, Enterprise Edition will be released this week and the Freeware next week. Best Regards, Support / DBTools Software |
|
| Re: access queries. | Posted in 22th, 07/2005 04:21 by access |
| I have installed 3.1 but it still behaves in exactly the same way gronos04 |
|
| Re: access queries. | Posted in 22th, 07/2005 10:12 by support |
| Hi,
Strange, we made the very same test and it worked. Could you send us more information about your system? - Windows version (and Service Pack installed if any) - MSOffice version ( or at least the DAO version, check About Box for that) - Which database server are you trying to copy the MSAccess table to? Did you try to use the Migration Wizard? Is the same problem happening? If it is could you send us a copy of the MSAccess database so we could run some tests here? At least it would be nice to know the MSAccess table structure. Thanks, Support / DBTools Software |
|
| Re: access queries. | Posted in 22th, 07/2005 11:43 by support |
| Hi,
After your message I decided to take a look at the setup in order to find out if everything was ok. We have found out that the setup for DBManager Enterprise Edition has a wrong DLL for the MSAccess component. We have updated the setup and also sent an email to all registered users with information about how to download and install the fix for this component. In case you don't receive this email, please notify me again and we will send you the file attached. Thanks for the feedback. In the hurry to release the new version, the wrong component was added to the setup script. Best Regards, Support / DBTools Software |
|
| Re: access queries. | Posted in 25th, 07/2005 12:35 by access |
| Unfortunately even after installing 301EN1-1 I still cannot execute a select query on the attached msaccess databases.
Copying tables into mysql works well. I need to manipulate data directly on the msaccess database. I am running XP service pack 2. DAO is 3.6 gronos04 |
|
| Re: access queries. | Posted in 25th, 07/2005 10:03 by support |
| Hi,
What version is this (301EN1-1)? Is the drag and drop working properly now? Is there any error message for the query? Could you send us a copy of the query that is failing? This would be important, to know why exactly is this error being raised. Best Regards, Support / DBTools Software |
|
| Re: access queries. | Posted in 25th, 07/2005 11:42 by access |
| I have set up a mdb called test.
I have 1 table with 2 fields. There is one record in the table. SELECT [tbltest].[*] FROM [tbltest] From this I get the following error. 'Executing query wait......... The select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.' The versionb that I am using is the last version publisheded This should have the correct dll. I installed it over the first published edition of 3.1.0 The drag and drop works perfectly. gronos04 |
|
| Re: access queries. | Posted in 26th, 07/2005 09:36 by support |
| Hi,
I have found the problem. The query parser is breaking the SELECT queries and using a wrong DAO method to execute them. You can fix this manually. All SELECT queries must have the SELECT and the list of fields in the same line. For example your query would be: SELECT [tbltest].* FROM [tbltest] or simply SELECT * FROM tbltest We are fixing the problem. Thanks for the feedback. Best Regards, Support / DBTools Software |
|
| Re: access queries. | Posted in 28th, 07/2005 09:30 by access |
| Thanks,it works perfectly as you suggest. gronos04 |
|
| Re: access queries. | Posted in 28th, 07/2005 09:30 by access |
| Thanks,it works perfectly as you suggest. gronos04 |
|
| access queries. (1498 previews) | |
Legends Topic has Replies Topic With no Replies
|
|
| Home » Forums » DBManager General |
|
|
Copyright © 2001-2024 dbTools Software. Best viewed with IE 7.x, Chrome or Firefox 3.x or higher at 1024x768 Register | Contact US | Forums | About US |