There are over 210,000 records in a txt file. One record has three columns with space split. To import this file into ms access, system replace spaces into comma. And then using insert into, system im
I have created a MySQL database but I need to be ab开发者_如何学Cle to create reports for it using MS Access.
I created a view on SQL Server 2000 and linked the view to my Access 2007 database via ODBC. Opening the view from Access showed what looked like a duplicate value. I updated my开发者_运维技巧 view to
Problem: I have a couple of views (Access ADP with SQL Server). I want to create a basic continuous form for those views, one form for each view. These views contain totally differences column name de
I want to create a database of products where each product can have multiple colours. I wanted to know if it\'s possible to create a form开发者_StackOverflow社区 which allows the user to enter the Pro
I have a number of pass-through queries setup in a MS-Access database with pre-defined ODBC connection strings. The problem is the database can link to one of two MySQL databases. The user selects the
I have a module in a large Access database which attempts to count the number of unique records in a table using the ECount (Extended D-Count) function written by Allen Browne (here: http://allenbrown
I have a C# database-driven application with a multi-table Access database as the back end. I addition to the tables I have several views that reformat the tables fo开发者_运维技巧r ease of viewing. M
I have a standard form in MS-Access which lists a bunch of orders, and each row contains order no, customer, etc fields + a button to view notes and attached document files.
I have an Access 2007 database that tracks document progression through time. The progression goes like:
加载中,请稍侯......