Re: database/LabVIEW naming-dependancy blues

you are most welcome
This is the reason I like this forum - straight answers when possible and compassion when your code doesn't work :smileysurprised:

When I use the access database I always stick an autonumber field in
the structure (handy for getting things like the last 100 records)
Also watch which fields become indexes. Queries that read data based on nonindexed fields can become dreadfully slow.

I tried using MySQL a couple of years ago but could never get datebased
queries to work correctly. Oracle, foxpro, access and sqlserver work
very well.
.

Relevant Pages

  • Re: Partial read-only access
    ... Generally the most straight forward way of doing this is, ... Front End (Forms, queries, code, reports) and Back End ... Nick Coe ... > One of the departments use an Access database that I ...
    (microsoft.public.access.security)
  • Re: Data Access Pages
    ... > queries, forms and macros to enable it to be operated over the internet. ... > data can be edited manually via data access forms, ... if there are any example of access database being controlled via web ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access and Excel
    ... via append queries and update queries. ... > Excel spreadsheets. ... > wanting to create some sort of Access database for her as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: office 2003 Word mailmerge with Access
    ... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: Mail merge from access Database
    ... Word 2003 uses a thing called OLE DB to connect to the Access database. ... however, both Access tables and Access Queries are listed in that dialog box, although Queries are described as Views. ... OLE DB does not "see" all types of table and query. ...
    (microsoft.public.word.mailmerge.fields)