473,734 Members | 2,647 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access2000 >> MSDE >> migration route (complexity? | administration? )

Is there a specific path I can follow to upsize my access 2000 database
which has:

20 tables - mixture of primary and foreign tables
20 queries (action, select etc)

Built on top of this access database is a set of front-end ASP pages and
backend administration pages using a combination of stored queries etc.

I am very hesitant about the whole process as I have just my application
working close to how I want it and have no idea of the complexity involved.

I have seen from www.aspfaq.com that there appears to be a free utility
called WEB DATA ADMIN which will allow a web GUI to make add,modifying and
deleting tables or generating queries easier. But, this also appears to be
geared towards the .NET community....tr ue?

I realise there is a 2 gig limit on space - should be fine - but are there
any other problems in using this as a pre-sql server entry point?

Feedback appreciated
Jason


Jul 19 '05 #1
2 1628
If memory serves you should be able to use Access2000 to create a database
in MSDE.

I believe if you create a new Access Project (instead of a database) then
you can connect to your MSDE server, and build the tables etc.
"jason" <ja***@catamara nco.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Is there a specific path I can follow to upsize my access 2000 database
which has:

20 tables - mixture of primary and foreign tables
20 queries (action, select etc)

Built on top of this access database is a set of front-end ASP pages and
backend administration pages using a combination of stored queries etc.

I am very hesitant about the whole process as I have just my application
working close to how I want it and have no idea of the complexity involved.
I have seen from www.aspfaq.com that there appears to be a free utility
called WEB DATA ADMIN which will allow a web GUI to make add,modifying and
deleting tables or generating queries easier. But, this also appears to be
geared towards the .NET community....tr ue?

I realise there is a 2 gig limit on space - should be fine - but are there
any other problems in using this as a pre-sql server entry point?

Feedback appreciated
Jason

Jul 19 '05 #2
Yeah - I have only tried using projects once before and I ran into
connection problems when I attempted to connect to a remote sql server
database and gave up.

I like the idea - though - it would allow me to hit the ground running.

Was there not a further limitation in actually generating queries in Access
to run inside MSDE or sql server....

Thanks
Jason

How do I handle this aspect?
"Tom B" <sh*****@hotmai l.com> wrote in message
news:uw******** ******@tk2msftn gp13.phx.gbl...
If memory serves you should be able to use Access2000 to create a database
in MSDE.

I believe if you create a new Access Project (instead of a database) then
you can connect to your MSDE server, and build the tables etc.
"jason" <ja***@catamara nco.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Is there a specific path I can follow to upsize my access 2000 database
which has:

20 tables - mixture of primary and foreign tables
20 queries (action, select etc)

Built on top of this access database is a set of front-end ASP pages and
backend administration pages using a combination of stored queries etc.

I am very hesitant about the whole process as I have just my application
working close to how I want it and have no idea of the complexity

involved.

I have seen from www.aspfaq.com that there appears to be a free utility
called WEB DATA ADMIN which will allow a web GUI to make add,modifying and deleting tables or generating queries easier. But, this also appears to be geared towards the .NET community....tr ue?

I realise there is a 2 gig limit on space - should be fine - but are there any other problems in using this as a pre-sql server entry point?

Feedback appreciated
Jason


Jul 19 '05 #3

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

Similar topics

1
1926
by: Keith R | last post by:
I have VB6, and eventually plan to upgrade to dotnet. I will soon start writing an application that will be mostly local (client?) but will interface with a server a few times, to authenticate users (and assign a user code), and at the end of the program, to upload some data back to the server. I figure I can write all the local stuff in VB6 (I'll have to learn more about the server side stuff, never done any of that before) but I...
0
1121
by: reinier | last post by:
Hello MSDE'ers, First a happy newyear without to much problems, whatsoever! Sofar I am not able to create a SQLdatabase, on an other computer, using a simple network. I am using VB.NET v2003 (Server explorer) & MSDE, downloaded from: http://www.microsoft.com/downloads/details.aspx? FamilyId=A0DAC778-60A6-4B11-8AA8-
14
2482
by: Mark B | last post by:
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a scheduled hard-boot occurred during a ms-security patch install overnight. They couldn't get the server working again so they transferred our site www.orbisoft.com to a new W2003 IIS6 server they set up. That was a week ago. Since that transfer, all of our ASPX pages that use Access2000 databases have stopped working.
1
292
by: jens | last post by:
Hello NG, This question regards a migration of a vb6 application to .NET Since 2 years we develop and extend an administration/reporting application based on VB6, Crystal Reports 10 and MS SQL Server 2000 which is including as well the control of an Excel calculation module via COM.
6
1439
by: MAT | last post by:
Hi. I developed a software that uses a Access 2000 database communication (with odbcConnection), because I have Office 2000 in my PC. The Software does not run in a PC that has Access 2003 (because of an error by database communication). What should I do in order to make the SW run in all PCs (with office 2000 or offive 2003). Thanks..
10
2699
by: lesperancer | last post by:
you start with a small application in access97, then you have more modules and more... and you reach the point where tables like 'item' and 'employee' reach the limit and you know there's more indexes required for RI to come does creating a RI programatically instead of the relationship window still consume one of the 32 indexes ? does access2000 / 2003 allow more indexes per table ?
22
3513
by: amygdala | last post by:
Hi, I'm trying to grasp OOP to build an interface using class objects that lets me access database tables easily. You have probably seen this before, or maybe even built it yourself at some point in time. I have studied some examples I found on the internet, and am now trying to build my own from scratch. I have made a default table class (DB_Table), a default validation class (Validator) which is an object inside DB_Table and my...
1
1327
by: sebastien1101 | last post by:
I have to produce a new application using now Visual Studio 2005 & Sql server 2005 express Before with VS2003 i use the msde Boostraper to deploy my database.... What i have to do with sql server 2005 express ?
0
8776
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
9449
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9310
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
9182
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6735
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
6031
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
4809
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3261
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
2180
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.