Upsizing to SQL


K

Kirko P

I have about 40 tables which I plan to upsize from Access 2000 to SQL
Server 2000 in the next while. However, a number of the tables (large
in size) are corrupting on a regular basis due to the amount of
queries being run on them (I think), and I need to do something about
it.

I was wondering if it were possible/wise to upsize just these few
tables right now, and still maintain DB integrity. (i.e. if I upsized
these tables, there would be forms which run of both Access and SQL
tables).

I am planning to upsize all the tables within a month, so this
situation would be temporary.

Any help in this matter would be appreciated.

Kirko
 
Ad

Advertisements

L

Larry Linson

How are you using these tables? Perhaps you can find some ways to avoid the
corruption on MVP Tony Toews' site at http://www.granite.ab.ca/accsmstr.htm.
If you have multiple users logged in to the same database, that could well
be the problem. In a multiuser environment, each user should have their own
copy of the front end (queries, forms, reports, etc.) and be linked to
tables in the shared backend (tables with data and relationships).

Yes, you can copy, convert, and link to some of the tables. Those tables
cannot participate in relationships with local or linked Jet tables... the
relationships are in the backend in every case.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing to SQL 2
upsizing to sql 5
Upsizing to SQL 2000 5
upsize to sql server 6
Help with SQL Upsize 0
Upsize to SQL - Query Criteria 4
Opinions on SQL Server upsize 13
SQL upsize 2 databases 2

Top