Possible to do remote access?

[roland_access]

Is it possible via VBA to remotely open a database on another computer?

For example, doing maintenance on a networked (but not split) database, when complete instead of telling users that its now accessable again, automatically opening the database on other computers on the network.

 

[jatfill]

I've never seen anything that could open a database remotely... however, you might consider the 'net send' command as part of a VBA procedure that would notify users at the end of a procedure that the database was available again.

Call Shell("net send /users The database is now available for use.")

the "/users" options sends the message to everyone on your LAN... but you can also target specific users if you only need to notify a handful of people.

Your original idea would be a nice one though... I understand having to kick people off of a database to do maintenance & backups... it can be a real pain & forces me to do lots of updates after hours

 

[doulostheou]

I was trying to figure out how to use the net send command to send to more than one specific user at the same time. For instance, my unit is networked with another unit. Whenever I use "net send *", it sends a message to the entire office. I want to isolate the 50 computers my unit uses to receive the messages. I found out how to send it to one specific user, but I don't really want to have to send a message 50 times.