0
votes
0answers
13 views

In Access, how can I reset the AutoNumber field as new data is deleted/appended? [duplicate]

Essentially what I have is a temporary table which logs data through an append query. This table is used to store consecutive strings of data, that will be exported to a .csv eventually. What I'm ...
1
vote
1answer
64 views

How to get access into table mode?

An Access database is getting to much data through forms so new copies get made. To make the old data available for searches the tables should be linked. The problem is that the menu group "EXTERNAL ...
0
votes
1answer
334 views

Access: How to match/relate records to each other within the same field?

In my Access Database is a table with project information, the ID is 'projectnumber'. I want to be able to match/link/relate different projectnumbers (all stated in the same field) to each other. So ...
0
votes
1answer
146 views

Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)

I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
2
votes
1answer
966 views

Multiple tables in Microsoft Access that need to feed into one table

In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
0
votes
1answer
771 views

Form no longer updates table; what'd I do?

I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
0
votes
3answers
214 views

Where are microsoft access tables stored?

Does Access store tables and data outside of the *.mdb file ? I have a computer which currently has a large working database on it containing some tables with confidential data. I would like to ...
1
vote
2answers
636 views

Separate tables or single table with queries?

I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
0
votes
0answers
573 views

Link Table manager does not work

I have access 2003. When I use the link table manager to link to a back end it does not work. There are no error messages. It just flashes and keeps asking begging for the location of the BE which ...