Re: tool to re-reference forms after usizing?

I've always been partial to Find & Replace, but I know others who swear by
Speed Ferret (which I hate to admit that I've never been able to get to
work!) I don't think there's going to be a difference between the two in
terms of accuracy.

The tricky thing with any such tool, though, is ensuring that you are very
explicit in telling it what to change. If you've got tblCustomer and
tblCustomerAddress, remember that changing tblCustomer to something else
will also change the beginning of tblCustomerAddress!

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jon" <Jon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:94AFFC18-88AE-44BB-9A2B-171317112AB2@xxxxxxxxxxxxxxxx
> Hi there,
>
> thanks for those, dont suppose you have tried any and which is the most
> accurate?
>
> The reason we are upgrading is the database was originally built in access
> 97 about 8 years ago for 4-5 users. since then it has grown and grown and
> bits have been bolted on and now it about 30-40 users accessing on a daily
> basis. unsurprisingly access is a bit unhappy with this and we may be
> taking
> on a few more users. Now we need to get it on a more stable platform which
> runs quicker and upsizing to sql seemed the logical choice as we support a
> few third party systems running sql server as well.
>
> trouble is its proving to be a bit tricky and with 400 odd forms, 700
> reports and about 1000 queries i dont really want to be going through them
> and re-referencing everything by hand!
>
> cheers,
>
> Jon
>
> "Douglas J. Steele" wrote:
>
>> While the AutoCorrect feature may do it, there are also 3rd party
>> products
>> that are known to work.
>>
>> Three that I'm aware of are
>> Find & Replace: http://www.rickworld.com/products.html
>> Speed Ferret: http://www.moshannon.com/speedferret.html
>> Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "Jon" <Jon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:35FB71E8-680E-4775-A9F8-AF42F530082A@xxxxxxxxxxxxxxxx
>> > Hi
>> >
>> > I am in the process of upsizing an access database to sql server.
>> >
>> > The reason for this post is because after upsizing i would like to
>> > rename
>> > columns, tables and queries in the sql database as originally the field
>> > names
>> > were put together with no logic at all and are an absolute mess. I
>> > understand
>> > that i would have to then change all the queries etc.. to show the new
>> > names.
>> >
>> > What i would like to aviod if possible is having to go into each form,
>> > report, marco and re-select the fields. Are there any mapping tools out
>> > there
>> > which can do this for me? dont mind buying something if there is.
>> >
>> > also, is it possible to produce an extract of report/query names from
>> > an
>> > access database?
>> >
>> > Thanks,
>> >
>> > Jon
>> >
>>
>>
>>


.

Relevant Pages

  • Re: ODBC parameters and system resources
    ... Install MSDE or use an existing SQL Server. ... I connect to an Access database of about 500MB in size. ... there is the "Not enough space on temporary disk". ... What can a "System resource" be apart from disk space and RAM? ...
    (comp.databases.ms-access)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Set daoDbs = Nothing ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to retrieve ms access database full information version
    ... I want to retrieve the full version information from a access database ... ie, while SQL Server IS the database, MSAccess is a Office product. ... There is another more direct way using the Object Model, ... the MS Access OLE Automation Guide handy. ...
    (microsoft.public.vb.com)