In the database that I am creating I need to be able to rename the file
with a name that the user specifies using the Save As Dialog window (I
already have the code that brings up this window). In other words, I
need to write code that makes a copy of the current database and saves
it with a new name. I've read that it is a bad idea to copy a file
that is currently in use so I am at a loss of what I should do. Any
suggestions?
Re: Problems with DataSets in DataSources window when renaming the source database ... They are naturally displayed and available in the DataSources... When I rename the database I obviously also change the database name in the ... I have also done some more testing and it seems like the DataSources window... (microsoft.public.dotnet.languages.csharp)
Re: MS Access "Upsizing" Tools in SQL Server ... Create the database manually (on SQL Server 2005), ...window, choose Link Tables, choose ODBC Databasesand then choose the DSN ... You'll want to rename the old tables to "tableName_old" then rename the ... (microsoft.public.sqlserver.tools)
Re: Message Alert ... You or another user can press the F11 key to show the database window... So the two strSQL lines needs to be changed also: ... assembled strSQL by pressing Ctrl + G, which opens the Immediate ... (microsoft.public.access.modulesdaovba)
Re: Prompting for password ... but requires the use of hooks (therefore I would ... > password in most cases to connect to the other database.... > The only pre-programmed dialog window for this is the InputBox, ... > Community, please sign in to the Community and mark these posts as ... (microsoft.public.access.security)
