Server Changed.. macros change?

  • Thread starter Thread starter abc
  • Start date Start date
A

abc

The server name at work changed.. now the macros on our access 97
database aren't running correctly.. is this because of the change in
server name??

please help!
 
Depends. By server, which server? Is it one the app runs from, or one
that the app connects to?

It sound reasonable to assume, but there might be other issues as well.
 
You probably need to relink your tables. You can use the Linked Table
Manager, which you'll find under Tools | Add-Ins in Access 97.
 
It says "There are no linked tables in the database"....

Normally, the macro backs everything up before the macro runs... now
the macro is pulling from the wrong server?
 
obviously then, it is a problem with the connection string, either in a
macro, or specifically in VBA, possibly called by a macro.

do you have local support?
 
You must log in or register to reply here.

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Windows 10 How to create individual shortcut for each user 1
Access Issue, Macro Single Step, Error 3270 0
Record-Locking remains open after closing 0
Can't see updates, different version 1
Access FE, SQL Server BE - suddenly very slow with ODBC errors -HELP! 5
This recordset is not updatable. After upgrade to Windows 2003 Enterprise. 1
Adding a folder results in error in currently working database 4

Back
Top