Ask a Question related to ASP.NET General, Design and Development.
-
Marina #1
Re: Access table names
That depends on exactly what you are doing.
But basically 'work' is a keyword, which is why the problem occurs. If you
reference it as [work] it should be fine, but generally I recommend you do
not name tables and columns with keywords.
"Tracey" <traceywillicombe@hotmail.com> wrote in message
news:086701c35a9f$1a50d1f0$a601280a@phx.gbl...> I am trying to load data into a datagrid from an MS Access
> table called 'Work' but I get an error saying 'Syntax
> Error in FROM clause'. If I just change the table name to
> Work1 it displays okay.
>
> Does anyone know if there is a reason why this would
> happen?
Marina Guest
-
Database table names
In the database tab of the Application panel, when I go down the hierachy to the tables dreamweaver shows the full path instead of just the table... -
querying field / column names in Access table
I got great info on my last post, so let's try this one and see if my luck is still good: I have an Access table with about 30+ columns / fields... -
ASP/Access 2002: how do I get column names from table (in order) using OLE DB?
When I use ADOX to get columns(fields) of a table, they are *auto-sorted alphabetically by name*. I need to get the list of field names as they... -
How best to grab SQL table names?
I've got a script that goes through SQL files and returns an array of table names. To find table names I use: while ($_ = <FILE>) { if ($_ =~... -
Dataset and table names.....
I have a stored procedure that queries a sql server database and returns the multiple data tables ( 7 to be precise) these tables are the results of... -
S. Justin Gengo #2 Re: Access table names
I have a list of MS Access Reserved words in the code library on my site:
[url]www.aboutfortunate.com[/url]. Search the code library for: reserved words
There are a lot of them...
I hope this helps.
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
[url]www.aboutfortunate.com[/url]
"Out of chaos comes order."
Nietzche
"Marina" <zlatkinam@nospam.hotmail.com> wrote in message
news:ufKjk%23pWDHA.1872@TK2MSFTNGP12.phx.gbl...you> That depends on exactly what you are doing.
>
> But basically 'work' is a keyword, which is why the problem occurs. If> reference it as [work] it should be fine, but generally I recommend you do
> not name tables and columns with keywords.
>
> "Tracey" <traceywillicombe@hotmail.com> wrote in message
> news:086701c35a9f$1a50d1f0$a601280a@phx.gbl...>> > I am trying to load data into a datagrid from an MS Access
> > table called 'Work' but I get an error saying 'Syntax
> > Error in FROM clause'. If I just change the table name to
> > Work1 it displays okay.
> >
> > Does anyone know if there is a reason why this would
> > happen?
>
S. Justin Gengo Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
