Re: Upsize to SQL
Tech-Archive recommends: Fix windows errors by optimizing your registry
apex77 wrote:
My Access database uses a front end (containing forms, queries and
macros), and a bcak end (tables). I have recently upsized the back
end to SOL. Now my queries, macros, forms do not work because they
cannot locate the new tables. Is there a tool that will allow me to
relink the queries, macros, forms without re-writing the over 200
queries that are in my database front end?
Why not restore the original table names to the linked tables?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
Relevant Pages
- Re: Automating a database table update
... suggest (including reading up on macros in the access 2000 ... Append queries won't update ... The final forms and reports are based on the final 6 ... you would use the odbc link manager to gain ...
(microsoft.public.access.macros) - Re: Automating a database table update
... accomplishes the same end result as deleting the table and recreating it ... if you've read the Macros section of the Access Bible, ... Append queries won't update ...
(microsoft.public.access.macros) - Re: Createing linked forms: "Object is closed or doesnt exist"
... How do you make queries and such available for use in forms? ... that forms and macros lock into but I have yet to find this. ... I am mainly an Oracle programmer and now working in Access ... you can use a VBA procedure to open a ...
(microsoft.public.access.modulesdaovba) - RE: How do I setup a search in a Microsoft Access Form
... Solution without adding any macros, queries or other "codes": ... We do TONS of this with our database, and it's WAY easier than setting up ... This command highlights the text, ...
(microsoft.public.access.forms) - Re: Data Access Pages
... > queries, forms and macros to enable it to be operated over the internet. ... > data can be edited manually via data access forms, ... if there are any example of access database being controlled via web ...
(microsoft.public.access.modulesdaovba) |
|
