Are you trying to insert the value [ It doesn’t really matter though because I am not using it for anything. Students Click Here Join Us! Home Forum What’s New? Write is as follows: The unique key is an autonumbered field so I was thinking I could use that, BUT if I delete records the count won’t be contiguous.

Uploader: Moogutilar
Date Added: 18 June 2005
File Size: 20.7 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 77044
Price: Free* [*Free Regsitration Required]

I am not a computer guru; neither am I a neophyte.

According to my predictions it would take 7, years to show a ROI based on my current Adsense earnings If so, double check datatypes. Here is the statement Tech support scams are an industry-wide issue where scammers attempt to trick you into paying for unnecessary technical support services.

How satisfied are you with this response? The unique key is an autonumbered field so I was thinking I could use that, BUT if Mocrosoft delete records the count won’t be contiguous.

If you can’t see what’s wrong, post that here. Here are some things to check, though: By joining you are opting in to receive e-mail. Steele, Nov 12, After that, you can post your question and our members will help you out. Thanks very much Ed.


Microsoft JET Database Engine error ‘e14’ Syntax error – Microsoft Community

Thanks for marking this as the answer. Hope you get a chuckle out of the site This makes a good argument for going with MySQL, but I feel like that’s almost like colaberating with the enemy I imagine that might just work. As I implied, if you’re not calling from within Access, I don’t believe there’s any way you can return random rows.

Dinh, Nov 11, You can help microsotf yourself from scammers by microskft that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Marc Everlove, Nov 11, I was thinking as much The url is http: However, the randomizer query you linked to has come up a few times, so it is probably the best option.

Frankly I am trying to learn to program and I woule like to learn ONE language and get proficient, before I go on to others.


You can see where it gets tedious I am just struggling through this. However, my patience with computers is very limited and I am unfortunately, very dependent. What’s amiss with it??? This site in other languages x.

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause HELP!!!!!-VBForums

I got the statement from a tutorial. Click Here to join Tek-Tips and talk with other members! Hi, I am building a SQL query on the fly – part of the code is as follows: If so, your SQL should be something like this: Thanks to any and all who help and in step by step directions with terms I understand.