OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

mdb - Syntax error in SQL expression

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
flyeng4
Newbie
Newbie


Joined: 27 Jun 2008
Posts: 1

PostPosted: Fri Jun 27, 2008 7:45 am    Post subject: mdb - Syntax error in SQL expression Reply with quote

I have set up an ODBC connection in Ubuntu to two different Microsoft Access Databases; testprojlist.mdb and test1.mdb. One is a list of projects and project numbers (testprojlist.mdb). The other is just a test with two fields named 'hello' (test1.mdb). I can open the test1.mdb and edit fields with no problem. When I open testprojlist.mdb to edit it gives the error 'Syntax error in SQL expression'. There seems to be some microsoft line feed issues or something.

You can download a screenshot of the problem here:
http://www.adrive.com/public/1e1f5d8d702932459b68db22dbf39adc29a8b9a4290a725c2dd43a1ea22fa3e6.html
Here is a screen shot when the error pops up:
http://www.adrive.com/public/ebf118be1a3e15fca953564dfb382b21789fc6228a920e600d793c6e1871f119.html

Any Ideas?
Thanks in advance,
Bill
Back to top
View user's profile Send private message Send e-mail
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Sat Jun 28, 2008 4:53 am    Post subject: Reply with quote

ODBC connection to mdb files in linux environment very unusable, unstable and the development is abandoned, much of the distributions not included, but Debian and Ubuntu use them.

Try Ubuntu lists.
Or under win connect to mdb and create new file and copy all tables to new odb file and that use under Ubuntu.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group