473,326 Members | 2,182 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Can't import Access DB into MSDE

I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:

Access --> New --> Project (Existing Database)

This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to select the .adp file that was just created.

Unfortunately, the "Select SQL Server Database File" dialog is looking
for an .MDF file, not an .ADP file.

If I try to kludge it and select the .adp file anyway, the Test
Connection produces an error:

"Test connection failed because of an error in initializing
provider. The header file "D:\test.adp" is not a valid database file
header. The FILE SIZE property is incorrect."

Any suggestions on how to proceed?

Note:
I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
Administrator running on XP Prof SP2.
Nov 13 '05 #1
3 1409
See comment inline.

"*no spam*" <no*****@yahoo.com> wrote in message
news:34**************************@posting.google.c om...
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:

Access --> New --> Project (Existing Database)
You should:
Access-->New-->Project (New Database)

Here, "Database" means a database on MSDE/SQL Server. The wizard will create
a database on MSDE, so that it can transfer data in *.mdb to the newly
created database on MSDE. *.adp file doen not contain a database (as *.mdb
file does), it is a pure front ent app, containing forms, reports, code
modules. You only select "...Project(Existing Database) when you know there
is a database on MSDE that you want to transfer data from MDB to.

This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to select the .adp file that was just created.

Unfortunately, the "Select SQL Server Database File" dialog is looking
for an .MDF file, not an .ADP file.

If I try to kludge it and select the .adp file anyway, the Test
Connection produces an error:

"Test connection failed because of an error in initializing
provider. The header file "D:\test.adp" is not a valid database file
header. The FILE SIZE property is incorrect."

Any suggestions on how to proceed?

Note:
I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
Administrator running on XP Prof SP2.

Nov 13 '05 #2
Norman - Thanks for the suggestion. I gave it a try and ended up back
at the Access/MSDE bug. Access produces an "Overflow" error and the
database just gets created in Access :(

Might there be some other way to do this?

"Norman Yuan" <no****@nowhere.no> wrote in message news:<#C**************@TK2MSFTNGP09.phx.gbl>...
See comment inline.

"*no spam*" <no*****@yahoo.com> wrote in message
news:34**************************@posting.google.c om...
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:

Access --> New --> Project (Existing Database)


You should:
Access-->New-->Project (New Database)

Here, "Database" means a database on MSDE/SQL Server. The wizard will create
a database on MSDE, so that it can transfer data in *.mdb to the newly
created database on MSDE. *.adp file doen not contain a database (as *.mdb
file does), it is a pure front ent app, containing forms, reports, code
modules. You only select "...Project(Existing Database) when you know there
is a database on MSDE that you want to transfer data from MDB to.

This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to select the .adp file that was just created.

Unfortunately, the "Select SQL Server Database File" dialog is looking
for an .MDF file, not an .ADP file.

If I try to kludge it and select the .adp file anyway, the Test
Connection produces an error:

"Test connection failed because of an error in initializing
provider. The header file "D:\test.adp" is not a valid database file
header. The FILE SIZE property is incorrect."

Any suggestions on how to proceed?

Note:
I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
Administrator running on XP Prof SP2.

Nov 13 '05 #3
It is impossible to get MSDE/SQL Server database created in Access. It is
conceptually wrong. However, if you specified to "create a client/server
application" in the "Upsizing wizard" (*.adp) and the ADP file did get
created, then you can open the ADP file to verify whether the ADP file can
connection the MSDE or not. You do:

1. Double click the *.adp file;
2. Click "File->Connection...."
3. In "Data Link..." dialog box, select/enter MSDE Instance name, select
autnetication mode (Windows integrited, most likely), and try to find the
new database name created by Upsizing wizard in "Select the database on the
server" dropdown list. If you found it, that means the new database is
created on MSDE, if not, means the Upsizing wizard failed before the
database got created (it is not uncommon that Upsizing Wizard failed to
create database on MSDE/SQL Server, due to different reasons).

If the the database did get created, but the data from *.mdb did not get
transferred fully, then you can clear out the incomplete data in the
database in ADP project (remember, the data is not in ADP file, ADP file is
just a front end app to MSDE), verify the database has the ame structure as
the tables in MDB, and go back to the MDB file to re-run the Upsizing
Wizard. This time you choose "Use existing database" and do not need to
create another ADP file (You can create/open numerous ADP file against a
database on MSDE at any time by simply launching Access, when needed).

HTH

"*no spam*" <no*****@yahoo.com> wrote in message
news:34**************************@posting.google.c om...
Norman - Thanks for the suggestion. I gave it a try and ended up back
at the Access/MSDE bug. Access produces an "Overflow" error and the
database just gets created in Access :(

Might there be some other way to do this?

"Norman Yuan" <no****@nowhere.no> wrote in message

news:<#C**************@TK2MSFTNGP09.phx.gbl>...
See comment inline.

"*no spam*" <no*****@yahoo.com> wrote in message
news:34**************************@posting.google.c om...
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:

Access --> New --> Project (Existing Database)


You should:
Access-->New-->Project (New Database)

Here, "Database" means a database on MSDE/SQL Server. The wizard will create a database on MSDE, so that it can transfer data in *.mdb to the newly
created database on MSDE. *.adp file doen not contain a database (as *.mdb file does), it is a pure front ent app, containing forms, reports, code
modules. You only select "...Project(Existing Database) when you know there is a database on MSDE that you want to transfer data from MDB to.

This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to select the .adp file that was just created.

Unfortunately, the "Select SQL Server Database File" dialog is looking
for an .MDF file, not an .ADP file.

If I try to kludge it and select the .adp file anyway, the Test
Connection produces an error:

"Test connection failed because of an error in initializing
provider. The header file "D:\test.adp" is not a valid database file
header. The FILE SIZE property is incorrect."

Any suggestions on how to proceed?

Note:
I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
Administrator running on XP Prof SP2.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
7
by: Mike Watson | last post by:
I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf developed by someone else so I loaded the .mdf into my /DATA folder. But, MSDE/ODBC can't see the database. I subsequently...
0
by: Lou Arnold | last post by:
Why isn't a database created on the MSDE?? Network: Two Win2K Pro machines connected as peers. (No domains.) MS Access is on X, MSDE2000A is on H. MS Access is run under: Windows...
12
by: Dan V. | last post by:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net worker process", therefore doesn't that mean that even 50 simultaneous human users of the website would appear to the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.