I have a split database, BE on a LAN, each user has FE on machine. Some of my tables need to be periodically updated from Excel spreadsheets. Some need to be...

Back in the days of Access 2003 and before, Access supported the creation and management of the following custom...

Issue: I have a linked table (ODBC) each time I run a query a pop- up box appears asking for my password for the other system. I then design a make table...

Is there a way to change the default Find settings from Whole Field to Any Part of the Field? The user has to keep switching it. Many thanks in advance.

Hello, I am looking for recommendations on what software development methodologies to use for developing a Microsoft Access application. I know there are...

I have MS Access 2002 database with email addresses and a txt file. i am trying to email the txt file to the email addresses in my database automatic to all...

File--Get External Data For File Name --ftp.xx.com i typed username and pass and connected successfuly.. I chose my db but i says that invalid path name?...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I'm building a simple database app with Access, and thought that rather than using the Access wizards, I would start the process by working out...

Is it possible to set an auto number in a table , which is the primary key, to start with a defined number say...1000. Thanks

how can i find someone that i can give my required info to and have them design my database for me? -- Dragonfly

Hello. I am in the process of designing a database that, in addition to having the members name, address, etc., will have a group of check boxes. The check...

I'm trying to figure out the best design for a new database for a composite primary key (CPK) where one of the fields may be a NULL - a violation of a primary...

I have a memo field that the user can insert markers that will be replaced with data in a query process. Example: Dear {1} where the {1} will be replaced with...

Hi, I'm linking tables from other access databases to my master access database in run-time via ADO code. I can do it for databases which has no password...

I want to create an access database. Now from a query that I will be doing every month from MySQL i will be importing an excel sheet. Now on this sheet there...

My OS is Win2000, version 5.0, SP3. I'm using Access 2000, and it seems that there are only two options for sorting a field - Sort Asending, or Sort...

Database splitting question: I have a db that contains data tables (fixed information), dynamic tables (info that changes based on users input), queries,...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I have a couple of basic questions, hope you can help. I have an employees record set. The employees take computer tests. If the employee came into employment...