Recent content by BillD

I checked the MDAC version on the Windows 2000 Pro machine using Comp Checker I downloaded. The version Seems to be almost completely compatible with Version 2.8SP1 on Windows XP SP2. The Windows XP machine is compatible with Version 2.8 on Windows XP SP2. Could this be a problem? How would I...

I will check out your suggestion. Right now, I don't know why the Access Front end is working on the XP machine. I am looking at the Database before I split it and converted the back end to SQL Server 2005 Express. I am looking at the call sub forms. This Access database is having the same...

There is no security on the front end Access 2000 database. After more testing, the problem seem to happen when I add call info into the calls sub-form on the main data entry form. I will note here that I have copied the front end to another computer on my home network. The access front end...

I am experimenting with an Access Front End and an SQL Server Back End with Linked Tables. I set up SQL Server 2005 Express on my desktop PC and used SSMA to transfer the tables and some queries to SQL Server. The tables are linked to the Access 2000 Front End. Everything was working fine but...

I downloaded the SQL Server Management Studio Express. It seemed to install OK. Here is what I found under MY Computer-Services and Applications-SQL Server Configuratioin Manager-SQL Server 2005 Services SQL Server (SQLEXPRESS) - Running - Automatic SQL Server Browser - Running -...

I looked at the management tools for SQL server express at the site provided. A prerequisite seems to be windows XP Professional. I ahve windows XP Media Center Edition. I cannot find info if this is OK. ShoulsdI try it anyway? By the way, I created a new database from scratch win Access 2000...

Thanks for the site location. I will try this.

I have been using Access 2000 for over 6 years now. I have customers with XP. I have never had a problem. I have over 40 databases with 10 to 15,000 records on each. Never a problem. I love Access 2000 and Access 2002. Upward and downward compatible. A first for microsoft. In the past, I ran a...

Could you tell me how to create an sql server login and password. I don't know what DTS is but in time I can do anything. Thanks for the advice. BillD

Bob: I tried to upsize the back end Access 2000 database to SQL Server 2005 Express again for the 100th time. This time I tried to upsize only 1 table called "Status". The only field in the table is "Status" which is the primary key.The allow indexing is set to Yes-No Duplicates. Allow Zero...

The simple table did not have a primary key. I used this table for a combo drop-down to select whether someone voted or not. Fields -Yes, No, and Maybe I will try a simple table with a primary key. Thanks again, BillD

I will check out the prepping of tables and post my results. I do not think that this is the problem as I tried to upsize with only 1 of the tables and I received the same result. Table skipped or export failed. The table I selected only had 3 text fields in it. (Yes,No and maybe) Thanks again,BillD

I have split my database to front end and back end. The back end holds only the tables. I used the upsizing wizard in access 2000. The tables were skipped or export failed. What is going on? Help! I should mention here that I have installed SQL Server 2005 Express on this PC. I would like to...