Access 2K to MSDE

With Acces 2000.
When i go to migrate a BD in Access 2000 to MSDE.
Acces 2000 gives me an overflow error.
I suppose it is an overfolw error ( in spanish DESBORDAMIENTO)
Is it possible to migrate from acces 2000 to MSDE ?
See How to Convert an Access Database to SQL Server
http://support.microsoft.com/default...EN-US;Q237980. This
paper has links to other papers that detail the errors and issues
invoving using the upsizing wizard.
--Mary
On Thu, 7 Oct 2004 09:24:56 +0200, "Miguel Genol" <mgenol@.teleline.es>
wrote:

>With Acces 2000.
>When i go to migrate a BD in Access 2000 to MSDE.
>Acces 2000 gives me an overflow error.
>I suppose it is an overfolw error ( in spanish DESBORDAMIENTO)
>Is it possible to migrate from acces 2000 to MSDE ?
>

Acces to SQL guidence?

OK I have been trying on my own to move from Access to SQL express/Developer. I have not found much in the way of guidence. Any suggestions? I would rank myself as fairly advanced with Access but just a newby to the SQL products... I keep blasting into walls and issues in the SQL world and would rather learn from someone elses' hardship rather than re-invent what has been undoubtably been already discovered.

I do fairly advanced reports and Large imports, Hence the need for developer rather than express, since the express import facility is hopelessly crippled. Even the developer SSIS is not well doccumented and seems pretty buggy and hard to use, even with the wizzards, As for reports.... well I'm expecting that to be a fairly had road to climb also...

Your are in a common position so rest assured many of us have been there. One of the easiest things I tend to do in this situation is learn as the need arises.

For example, creating relationships in access is very easy. You will find no such "GUI" way in sql server to create relationships. You can instead use management studio to do the same thing, but you just won't have the pretty layout that access has.

Also, if you are familiar with access you probably are aware of using an access project (intended I think for an SQL server type database situation).

So I would jump around this forum and other forums and find out the answers to the questions you need as these issues arise. You may want to pickup and intro to sql server book just to get an overview of the tools in sql server, but if you are the hands on type you may just want to jump right in. When you do install the dev edition you will (or may be -- I was) overwhelemd by the number of features installed. Keep it simple and focus on one task at a time.

E.g. create a simple db and run some queries and forget about configuring remote access and things like that at first.

I hope some of this was helpful. Do you have any specific questions about the change?

Ranginald|||

Thanks for the reply. Indeed that is exactly what I'm doing, jumping in that is. Its the way I've always learned the next new thing, in fact I've been involved with computers for more than 20 years now...Generally books are for sissies!

But on the other hand do you have any you would particularly single out as being good?

Here is some of my experience which may help the next person on this trail....I still don't get why someone has not addressed the topic more comprehensively since it seems that this is a path that many will be embarking on....

Actually I find the GUI table relationship thing to be fairly transferable to SQL management studio, so far. I miss being able to use vb in queries though...

so far I have a basic import going using ssis, (boy that wasn't easy) The SSIS tool seems very poorly supported, for instance I created an import job (via wizard), and just opened it and closed it with no modifications and it generated errors that it did not generate when first created by the wizard! Not to mention the terminations for truncated fields that there is no ready documentation how to accept rather than terminate.. So an import that took 5 minutes to do in Access took Hours to do in SSIS from a basic Flat text file.

I have imported a bunch of tables from access (easier)

I have done some derived tables and views, (not too hard) but I'm not to the advanced stuff yet.

Written one report, pretty basic and I'm thinking the SQL tool looks pretty hard relative to advanced reports in Access.

|||Glad I could help. I've always liked Wrox books. They are well written and to the point. I'm sure you know this already but whenever I want to buy a book I look on amazon for the user rating first to see if it's worth it.

Good luck.
Ranginald

Acces to a file that is locked by another process

I am writing a package to process perfmon logs. The issue I have come across is that the perfmon process holds onto the log file and SSIS fails because it wants to exclusive read access. Is there any way of getting SSIS to not take an exclusive read on the file.

I can read the file in notepad fine but not SSIS.

check by changing the isolation level of package by default its serialiazable

acces multiple servers

Hi,

I need to access a table from another server in my procedure...I am now connected to say SERVERA...I need to access another table SERVERB.TABLE2 in the same procedure...

Is there a way to do that...

I need to connect to two servers from the same procedure to get data..

Please get back

Thanks,

Hi Swapna,

Yes, there are a few methods, however the most straightforward would be to create a linked server.

Have a look at BOL or http://www.databasejournal.com/features/mssql/article.php/3085211 for more info.

Cheers,

Rob

|||Thanks a lot Rob...It was very helpful

Acces Enterprise console

Hi everyone,
Can someone tell me if there are any tools to access the enterprise console
of sql server from another pc?
I've got 4 w2k clients and 1 w2k server.
Who can help me?
--
Pascual de la Cruz
Data Manager
Generation R
Erasmus MC
P.O. Box 1738
3000 DR Rotterdam
The Netherlands
Phone: +31 (0)10-4087479
Mail: delacruz@.generationr.nlYou simply need to install SQL Server client tools on your other PC. If you
cannot fo that, then log onto your SQL Server using Remote Desktop
connection.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:udIw5qHaDHA.4028@.tk2msftngp13.phx.gbl...
Hi everyone,
Can someone tell me if there are any tools to access the enterprise console
of sql server from another pc?
I've got 4 w2k clients and 1 w2k server.
Who can help me?
--
Pascual de la Cruz
Data Manager
Generation R
Erasmus MC
P.O. Box 1738
3000 DR Rotterdam
The Netherlands
Phone: +31 (0)10-4087479
Mail: delacruz@.generationr.nl|||Yes. Run thesetup program, and you can select Client Components (or whathever the selection is
named).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:uz6UsELaDHA.384@.TK2MSFTNGP12.phx.gbl...
> Where can i find the client tools? Are they on the cd of sql server
> enterprise?
> --
> Pascual de la Cruz
> Data Manager
> Generation R
> Erasmus MC
> P.O. Box 1738
> 3000 DR Rotterdam
> The Netherlands
> Phone: +31 (0)10-4087479
> Mail: delacruz@.generationr.nl
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:eC0Z9gKaDHA.2648@.TK2MSFTNGP09.phx.gbl...
> > You simply need to install SQL Server client tools on your other PC. If
> you
> > cannot fo that, then log onto your SQL Server using Remote Desktop
> > connection.
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > What hardware is your SQL Server running on?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
> > news:udIw5qHaDHA.4028@.tk2msftngp13.phx.gbl...
> > Hi everyone,
> >
> > Can someone tell me if there are any tools to access the enterprise
> console
> > of sql server from another pc?
> >
> > I've got 4 w2k clients and 1 w2k server.
> >
> > Who can help me?
> >
> > --
> > Pascual de la Cruz
> > Data Manager
> > Generation R
> > Erasmus MC
> > P.O. Box 1738
> > 3000 DR Rotterdam
> > The Netherlands
> > Phone: +31 (0)10-4087479
> > Mail: delacruz@.generationr.nl
> >
> >
> >
>

Acces 2000

Hi. I am trying to set up da db with access 2000.
Somewhere I read that I should not use password on my db if I intend to replicate the db.
I don't really understand what "replication" means..Originally posted by david2000
Hi. I am trying to set up da db with access 2000.
Somewhere I read that I should not use password on my db if I intend to replicate the db.
I don't really understand what "replication" means..

FROM BOL:

Replication is a set of technologies that allows you to keep copies of the same data on multiple sites
Replication uses a publish-subscribe model for distributing data:

A Publisher is a server that is the source of data to be replicated. The Publisher defines an article for each table or other database object to be used as a replication source. One or more related articles from the same database are organized into a publication. Publications are convenient ways to group related data and objects that you want to replicate together.

A Subscriber is a server that receives the data replicated by the publisher. The Subscriber defines a subscription to a particular publication. The subscription specifies when the Subscriber receives the publication from the Publisher, and maps the articles to tables and other database objects in the Subscriber.

A Distributor is a server that performs various tasks when moving articles from Publishers to Subscribers. The actual tasks performed depend on the type of replication performed.