Razzak, I'm confused. I've been using R:Base since R:Base 2.0 and always thought I knew my way round the product. Recently I installed in on my C: drive prior to deploying it to our division. When I create a new database (name is Test) without any data I can define a table (name APPLL) without any problem. When I try to create a form I get ' -ERROR- Syntax is incorrect for the command SELECT (2045)'.
All I do is select Forms from Database Explorer. Next select New Form. Type in a Form Name of APPLL. Select a Table/View Name and enter APPLL (table name). Select Form Comment and enter 'Data Entry'. Click Use Form Wizard and press OK. At that time I get the error message ' -ERROR- Syntax is incorrect for the command SELECT (2045). Any advice you can provide will be appreciated. It seems that no matter what I try to do I get this error. Thanks. Bill Gerrish, Senior Fisheries Biologist CT Aquatic Resources Education (CARE)<http://www.ct.gov/dep/cwp/view.asp?A=2696&Q=386682> & Constituent Services, Inland Fisheries Division<http://www.ct.gov/dep/cwp/view.asp?a=2696&q=322680&depNav_GID=1632> Connecticut Department of Energy and Environmental Protection<http://www.ct.gov/deep/site/default.asp> 79 Elm Street, Hartford, CT 06106-5127 P: 860.424.3480 *F: 860.424.4055 *E: [email protected] [cid:[email protected]] <http://www.facebook.com/CTFishAndWildlife> www.ct.gov/deep<http://www.ct.gov/deep> Conserving, improving and protecting our natural resources and environment; Ensuring a clean, affordable, reliable, and sustainable energy supply. [Have you caught a fish today?]
