473,836 Members | 1,505 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.ad p" 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.
Jul 20 '05 #1
3 6125
See comment inline.

"*no spam*" <no*****@yahoo. com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
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(Exi sting 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.ad p" 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.

Jul 20 '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******* *******@TK2MSFT NGP09.phx.gbl>. ..
See comment inline.

"*no spam*" <no*****@yahoo. com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
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(Exi sting 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.ad p" 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.

Jul 20 '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.goo gle.com...
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******* *******@TK2MSFT NGP09.phx.gbl>. ..
See comment inline.

"*no spam*" <no*****@yahoo. com> wrote in message
news:34******** *************** ***@posting.goo gle.com...
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(Exi sting 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.ad p" 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.

Jul 20 '05 #4

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

Similar topics

7
2595
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 discovered that it was created using SQL Server 2000. Is this the reason that my MSDE 7.0 doesn't see the .mdf? If so, how can I use this database with my 7.0? Backup from 2000, restore to 7.0? Thanks for any help.
1
1311
by: Jer | last post by:
Using an access project front-end to an MSDE database, I'm trying to import a spreadsheet using File->Get External Data->Import. After I select the spreadsheet name, I tell it I want to import into an existing table and select the table name from the list. The name in the list is dbo.Cost_Data. When I tell it to finish, it says the table does not exist. If I do the same steps as the database owner, the table name does not contain the...
4
2558
by: Vikrant | last post by:
Hey friends Can someone please suggest that how many recordset can be opened simultaneously for a MS-Access 2000 Database.Does that make any difference if we use ODBC or some other way of connecting to the database.
0
1306
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 Administrator. MSDE is set for Windows Authentication only. On using the Microsoft SQL Server Database Wizard to create an Access
0
1102
by: Lou Arnold | last post by:
I can't create a database in MSDE with MS Access. Why? Some details: 1) Single computer - so there is no domain controller. 2) No firewalls. A fresh install of Win2K SP4, MSDE 2000A and MS Access SP3. 3) All is done thru the standard Windows Admin account. 4) MSDE is set for Windows Athentication. 5) I can create a database with Osql.exe and with a MSDE Plus, a 3rd party Admin tool.
3
1430
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 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...
0
1273
by: TJS | last post by:
I need to import a delimited text file to an msde table, I found discussion item below. anything available for msde which is comparable to this Jet example? ================================= The TEXT ODBC driver calls the Jet database engine and reads text files via Jet's Text IISAM driver. You may try code similar to the following: Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp;Extended...
6
1805
by: baramee | last post by:
I develop web application by asp.net with ms access. In general , it work fine. But if hit rate of web is very much, it occure error 'Unspecified error'. it error on conn.open. My code will be closed and destroyed connection object always. I think that problem come from database concurrency. I can't change database to sql server because it about budget. How can i fix this error? Thanks in advance.
12
2323
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 database backend as a single user. Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous change to make while NOT limiting the number of simultaneous web...
0
9671
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10551
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9379
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7793
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6979
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5650
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5828
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4458
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3116
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.