Search Access Code/Modules/Macros in multiple MDB files

[Henners]

Hi There

We are migrating our network file system from Novell to Windows. (There are
pros and cons)....

In this process, we have noticed that a good bunch of user created access
databases have modules or macro code that points to:

\\NETWARESERVER\share\data

This, as you can imagine is bad. Our developers have always used the shared
drive in their databases so their code is like:

R:\data where R: is mapped to \\NETWARESERVER\share... (These databases are
then fine with a drive map change)

Since we are changing server names, I need a way to scan all the MDB's on
the network (About 2200+) for this code..

Are there any tools available to do this for me? Otherwise I have to open
each database one by one, and search the project for \\Netwareserver

Once I find out the number of databases (hopefully no more than a handful) I
can go and change the code.

Any suggestions would be appreciated.

Please reply with a post, or email te*********@hotmail.com

-Henry

[Lyle Fairfield]

Henners wrote:

Hi There

We are migrating our network file system from Novell to Windows. (There are
pros and cons)....

In this process, we have noticed that a good bunch of user created access
databases have modules or macro code that points to:

\\NETWARESERVER\share\data

This, as you can imagine is bad. Our developers have always used the shared
drive in their databases so their code is like:

R:\data where R: is mapped to \\NETWARESERVER\share... (These databases are
then fine with a drive map change)

Since we are changing server names, I need a way to scan all the MDB's on
the network (About 2200+) for this code..

Are there any tools available to do this for me? Otherwise I have to open
each database one by one, and search the project for \\Netwareserver

Once I find out the number of databases (hopefully no more than a handful) I
can go and change the code.

Any suggestions would be appreciated.

Please reply with a post, or email te*********@hotmail.com

-Henry

It will be less than an hour's work to write code to scan all your mdb
files and replace \\NETWARESERVER\share\data everywhere with R:\Data or
whatever you want.

Hire someone who is located in your area to do this; probably you can
get it done quietly and sucessfully in a day for $100 USD. One problem
with this might be that in changing the drive reference hidden errors
might appear. These would have to be repaired.

If that's not suitable then you could study posts in here that deal
with SaveAsText and LoadFromText, low level DOS file functions and do
your own.

Another possibility is for you to do this manually. You can do a search
and replace on your code. Macros and SQL in saved queries may take a
little longer.

[Larry Linson]

"Lyle Fairfield" <ly***********@aim.comwrote

Hire someone who is located in your
area to do this; probably you can
get it done quietly and sucessfully in
a day for $100 USD.

You really think the OP can find someone competent to do what you describe
for $12.50 USD per hour? I doubt that is so in the area where I live and
work, so I hope they don't get their hopes up and/or insult some competent
developer by offering data entry clerk wages.

Larry

[Lyle Fairfield]

Larry Linson wrote:

"Lyle Fairfield" <ly***********@aim.comwrote

Hire someone who is located in your
area to do this; probably you can
get it done quietly and sucessfully in
a day for $100 USD.

You really think the OP can find someone competent to do what you describe
for $12.50 USD per hour? I doubt that is so in the area where I live and
work, so I hope they don't get their hopes up and/or insult some competent
developer by offering data entry clerk wages.

Larry

? ... I think I suggested one hour's work for $100.